LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-19-2004, 08:47 PM   #1
osat3ch
Member
 
Registered: Jan 2004
Location: Portsmouth, NH
Distribution: FC3, FC4
Posts: 45

Rep: Reputation: 15
Unhappy MYSQL password problem.


I followed these instructions to set the pw in mysql but now I can't login to MYSQL

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit


now when I type... i get

[root@localhost mylinpc]# mysql -u root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)


I find now I have to log back in to change the pw to YES for the program I want to run that uses mysql. How do I do that?
 
Old 08-19-2004, 09:25 PM   #2
Boby
Member
 
Registered: Feb 2004
Posts: 781

Rep: Reputation: Disabled
Hi!

mysql -u root mysql -p your_password
or
mysql -u root mysql -p

Now you can use MySQL.
Boby
 
Old 08-20-2004, 10:00 AM   #3
osat3ch
Member
 
Registered: Jan 2004
Location: Portsmouth, NH
Distribution: FC3, FC4
Posts: 45

Original Poster
Rep: Reputation: 15
ty

i saw the help file i just didn't know the syntax

thanks a lot
:-)
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL 4.1 user/password problem devfreak Linux - Software 4 03-23-2006 02:54 PM
Mysql password problem (need to erase old) runlevel0 Programming 1 07-27-2005 02:22 PM
mysql password problem varala_kanth Linux - Newbie 1 06-10-2004 04:19 AM
Mysql Password Problem Flossie Linux - Software 6 04-09-2004 04:22 AM
mysql - problem with start and password CharlesButters Linux - General 0 11-09-2001 04:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:38 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration