MySql Help

Forum: water cooler
Topic: MySql Help
started by: Max

Posted by Max on Mar. 10 2005,14:03

DSL forum probably isn't the place for this question, but I just like you guys better....

I recently upgraded MySQL on an SME (Red Hat based) distro from version 3 to version 4. Anyway, as I was blissfully following the upgrade instructions it informed me that I should supply new root SQL passwords. Well, I don't think it ever had these before and since I've done it my phpmyadmin won't connect to the DB from localhost anymore and other php apps I've written won't connect either.

Does anyone know of a way to "remove" those intialized passwords and set them back to the default value?? I'm the only one on the box, so I don't have to worry about anyone else gaining local access.

Note that I *can* also access (e.g. login) the DB via the MySQL Admin app from a Winblows box.

Any insights appreciated.....

Posted by Matthew on Mar. 15 2005,17:41

On the default mysql install the default root password is blank. Try changing the password with "mysqladmin -u root -p password changeme" and hit return when prompted for a password. If that doesn't work you can try replacing the user database files in /var/lib/mysql/mysql. Get a copy of your old data base, or from another database where you know the root password.

Posted by Max on Mar. 18 2005,14:32

Thanks for the tips. I'll give them a try...