LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
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 07-15-2005, 08:16 PM   #1
k41184
Member
 
Registered: Nov 2003
Location: Sioux Center, IA
Distribution: RH9, Fedora Core I,II,III
Posts: 37

Rep: Reputation: 15
Cannot Log into MySQL root password I just set...


I just set the root password for my mysql server using the following command:

root@struik img]# mysqladmin -u root password 'password
> '


(no password is not what I was really using, it is just there for explanation)
As you can see, the mistake I made was not putting the final ' before hitting enter. So somehow Fedora read this not as the word password but as something else, so I cannot log in, evening use the word password.
Whenever I try to log into root, the following occures:


[root@struik img]# mysql -u root -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


My question obviously is, what did Fedora Think I had entered for a password if not the word password? How can I enter this strange string with a return in it so I can log in to the MySQL server and change the password or can I change it some other way, short of reinstalling the whole Fedora installation.

Thanks in advance for your help.
 
Old 07-15-2005, 08:28 PM   #2
perfect_circle
Senior Member
 
Registered: Oct 2004
Location: Athens, Greece
Distribution: Slackware, arch
Posts: 1,783

Rep: Reputation: 53
strange thing indeed...
for a password recovery try this:
http://www.linuxquestions.org/questi...icle&artid=318
 
Old 07-17-2005, 04:04 AM   #3
stefan_nicolau
Member
 
Registered: Jun 2005
Location: Canada
Distribution: Debian Etch/Sid, Ubuntu
Posts: 529

Rep: Reputation: 32
Bash understood this to mean:
Code:
password<newline>
which is the same as
Code:
password\n
and
Code:
password
 
Old 07-18-2005, 10:57 AM   #4
k41184
Member
 
Registered: Nov 2003
Location: Sioux Center, IA
Distribution: RH9, Fedora Core I,II,III
Posts: 37

Original Poster
Rep: Reputation: 15
Solution Found

Although I wasn't able top get the instructions from the tutorial mentioned above to work, it did prompt me to a few new ideas and I was able to locate a sollution at http://dev.mysql.com/doc/mysql/en/re...rmissions.html
Thanks for your help.
 
  


Reply



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
root password reset log cmsisb Red Hat 5 01-14-2013 04:49 PM
What should I do to set root password backpacker Linux - Newbie 1 06-10-2005 03:19 AM
how to check root password reset log cmsisb Red Hat 1 04-11-2005 07:23 AM
MySQL root password. bulzbb Linux - Newbie 2 03-11-2004 09:32 AM
Mysql root password spintrance7 Linux - Software 7 11-29-2003 04:20 PM

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

All times are GMT -5. The time now is 05:56 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
Open Source Consulting | Domain Registration