PHPMyadmin Authentication

[DGK101]

Hi there everybody,

I have a slight problem with mysql and phpmyadmin.

I changed the root password after I istalled mysql.
When I try run PHPMyadmin after the change, it gives me an authentication error(wrong username or password) - I have changed the config file to register the new password....

When I change the root password back to its default(nothing) and I change the config file to reflect no password - phpmyadmin opens perfectly...

I have then set up another user with password but alas no difference in behaviour.

What could be the problem?
I hope you guys can help, it will really be appreciated.

I am running windows XP.

D

 

[HMarcBower]

Not sure what method you're using to change the password for root, but you need to MD5 the password field if you're entering the password in phpmyadmin. You can do this by editing the row to contain the password you want (in plain text... ie. "password") then select the MD5 option in the Function column. When you save out the record, and go back to browse the contents of the user table, it should now be an unintelligible string of characters.

Give that a go...

 

[DGK101]

Hi there,

I have changed the password using the command prompt, when that never worked with phpmyadmin - I downloaded Mysql Administrator from the mysql website - It has options to administer users and there passwords.

Unfortunately that never worked either.

I then changed my phpmyadmin config file to accept user names and passwords via HTTP and not TCP/IP - but still nothing.

I am stumped!

 

[HMarcBower]

When you look at the user table inside the mysql database, though, does it show your plaintext passwords, or is it showing an unintelligible string of alphanumeric characters?

Marc

 

[DGK101]

It shows a long string of jumbled characters.

D