MySQL Authentication

We had a problem getting phpMyAdmin to authenticate with MySQL correctly.

phpMyAdmin has three options for Authentication type...only Config works with the new version of MySQL.
Also, mysql changed the way that passwords are encrypted. This posed a unique problem for us because we copied over our old database by using the files, rather than an export.

The solution was to: 1) Use Config authentication. 2) Remove the root user from the database, reinitialize the users table, then reselect an initial root password.

Also, change the root password using (when logged in console): set password = old_password("NEWPASS");

Link to this Page

Setup on I-spy last edited on 24 February 2006 at 3:52 pm by flying-nun.cc.gatech.edu