Topic: phymyadmin

[Tom Haynes]

Greetings...

I have done something stupid I think. I was restoring a database that was too big for phpmyadmin. I went to the command line and used "mysql -u root -p database_name < file.sql"

It would not take the password, and so I changed the root password in phpmyadmin. I restored the database just fine, but now the phpmyadmin contrib does not work. Thinking I could change the admin password via the server-manager interface and it would resync the passwords, I did that. No luck....

Does anyone have a suggestion for how to get the phpmyadmin contrib working again?

Thanks...   Tom

[cactus]

It would not take the password, and so I changed the root password in phpmyadmin. I restored the database just fine, but now the phpmyadmin contrib does not work. Thinking I could change the admin password via the server-manager interface and it would resync the passwords, I did that. No luck...

Do NOT temper with the MySQL password, there are specific reasons for that, as explained in the MySQL FAQ for SME Server, there is also the procedure to reset your MySQL root password:

http://wiki.contribs.org/MySQL

[Tom Haynes]

Cactus...

Thanks for the help. This allowed me to reset the mysql password, and I have everything working again.

Take care...   Tom