phpMyAdmin

I was having a little trouble setting up phpMyAdmin today. After reading the docs I finally figured out why it wasn't allowing me to login. It appears that you login to phpMyAdmin using a mysql username and password, not the *nix username and password. Before you can do this tho, you need to setup a control user account. Here is the code from the side to do so:

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

GRANT SELECT (

    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,

    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,

    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,

    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,

    Execute_priv, Repl_slave_priv, Repl_client_priv

    ) ON mysql.user TO 'pma'@'localhost';

GRANT SELECT ON mysql.db TO 'pma'@'localhost';

GRANT SELECT ON mysql.host TO 'pma'@'localhost';

GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)

    ON mysql.tables_priv TO 'pma'@'localhost';

You should of coarse change your password in this.