Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: Tom Haynes on May 14, 2011, 03:24:17 AM

Title: phymyadmin
Post by: Tom Haynes on May 14, 2011, 03:24:17 AM

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

Title: Re: phymyadmin
Post by: cactus on May 14, 2011, 08:31:28 PM

Quote from: Tom Haynes on May 14, 2011, 03:24:17 AM

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

Title: Re: phymyadmin
Post by: Tom Haynes on May 14, 2011, 10:24:06 PM

Cactus...

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

Take care...   Tom