mysql root password apostrophe prohibits phpmyadmin login

gr33d · 11-05-2009, 06:11 PM

following howtoforge.com tutorial for centos 5.4 with ispconfig 3

i set my mysql root password to a value with an apostrophe:
mysqladmin -u root password 123'456
>mysqladmin -h server.example.com -u root password 123'456
ctrl + c (couldnt figure out how to quit)

installed phpmyadmin. surfed to http://server1.example.com/phpmyadmin
prompted for password--doesnt work
tried root, mysql and leaving username blank too

cant find correct syntax to change password from command line. do i need to somehow escape the apostrophe???

thanks in advance!

Guttorm · 11-06-2009, 08:42 AM

Hi

I don't think you actually set any root password. When you try the command:

mysqladmin -u root password 123'456

The shell see the ' and it will wait until it finds another ' before it will do anything. And since you hit ctrl + c you stopped it.

I think you should be able to login with phpmyadmin using root as username and no password. But you really should set a password as soon as possible. If you want ' in the password, you can use it inside ".

mysqladmin -u root password "123'456"

gr33d · 11-06-2009, 09:55 AM

Blank password did not work. I found a solution that I will post when I get back to my box. It involved stopping mysqld and editing something to allow a passwordless login to mysql.

Thank you for the double-quote syntax though!

gr33d · 11-06-2009, 09:58 AM

Blank password did not work. I found a solution that I will post when I get back to my box. It involved stopping mysqld and editing something to allow a passwordless login to mysql.

Thank you for the double-quote syntax though!

gr33d · 11-09-2009, 09:31 AM

these are directions to follow to reset the password:

http://www.debian-administration.org/articles/442

thanks for the help along the way!