LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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-06-2005, 09:25 AM   #1
johnnydangerous
Member
 
Registered: Jan 2005
Location: Sofia, Bulgaria
Distribution: Fedora Core 4 Rawhide
Posts: 431

Rep: Reputation: 30
Big problem changed root password for mysql can't login pls comment


I changed mysql root password and somehow now I can't login, i also deleted anonymous accounts how to deal with that, I tried restarting the server.. no luck so far

I used:

mysqladmin -u root password "my_new_password" <--- seems I should have used ' ' not " "...

I tried rpm -e all mysql stuff and reinstalled it and again it asks for that strange password I set ... I can't use it.

pls any tip will do
 
Old 07-06-2005, 11:01 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,475

Rep: Reputation: 87
I ran into exactly the same problem the first time I tried to install MySQL. I uninstalled it several times (I did not use RPM to install it, I installed from a binary package, so I just stopped it and physically went and deleted all its files and directories) and installed it again until I got it working as regards the root password.

What I would suggest is uninstall it (if you can - you say rpm -e doesn't work? I HATE RPM) then install it again.
When it is done installing, set your "root" MySQL password by doing:

[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for root@localhost=password('yourpasshere');

and afterward log into MySQL with

[root@StefanLinux rylan]# mysql -u root -p
Password: <type your password here>

If I remember right, the method you posted that you tried to use is the very same one that locked me out a few times as well.

Hope this helps!

Regards,
 
Old 07-06-2005, 02:44 PM   #3
johnnydangerous
Member
 
Registered: Jan 2005
Location: Sofia, Bulgaria
Distribution: Fedora Core 4 Rawhide
Posts: 431

Original Poster
Rep: Reputation: 30
you hate rpm but use RedHat same here but I consider it more useful, but ontopic I can't do anything I don't have access to "root@StefanLinux rylan]# mysql -u root mysql"
 
Old 07-07-2005, 10:16 AM   #4
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,475

Rep: Reputation: 87


Yeah I like RedHat distros but not their package system...

The fact that I was root (in my shell) doesn't affect the fix I suggested. The MySQL root user and the Linux shell root user are IMO two different things. You can still be a normal, non-root Linux user but have access to MySQL's root-level. (I think!)

Regards,
 
Old 07-07-2005, 05:06 PM   #5
johnnydangerous
Member
 
Registered: Jan 2005
Location: Sofia, Bulgaria
Distribution: Fedora Core 4 Rawhide
Posts: 431

Original Poster
Rep: Reputation: 30
Quote:
Originally posted by rylan76


Yeah I like RedHat distros but not their package system...

The fact that I was root (in my shell) doesn't affect the fix I suggested. The MySQL root user and the Linux shell root user are IMO two different things. You can still be a normal, non-root Linux user but have access to MySQL's root-level. (I think!)

Regards,
no question about that but that's not the point
 
Old 07-08-2005, 01:22 AM   #6
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,475

Rep: Reputation: 87
Well, the only workable fix I can then think off (if you can't get your installed MySQL to uninstall or otherwise remove it) is to re-install, but to make sure that in Anaconda you do NOT select to install MySQL, Apache, or PHP. Then, once the system is up, install from the source and binary tarballs for Aparche and PHP, and MySQL.
 
  


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: still can't login after root password reset andredude Linux - Software 3 12-27-2012 09:48 PM
My root password has changed?!!! defa0009 Linux - Security 35 05-18-2005 04:49 PM
Help Root password changed!!! UmneyDurak Fedora 4 09-28-2004 01:47 PM
someone changed my root password. what do i do? budds Linux - Security 4 09-12-2004 12:09 AM
Somebody changed my root password. Help needed Heartz Linux - Newbie 1 04-13-2002 04:44 PM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration