PhpMyAdmin
Revision as of 18:26, 17 November 2006 by <bdi>PhilippeTeuwen</bdi> (talk | contribs)
Install
apt-get install phpmyadmin
cf http://www.phpmyadmin.net/documentation/
GRANT USAGE ON mysql.* TO 'pma'@'<pmahost>' 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'@'<pmahost>'; GRANT SELECT ON mysql.db TO 'pma'@'<pmahost>'; GRANT SELECT ON mysql.host TO 'pma'@'<pmahost>'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'<pmahost>';
/etc/phpmyadmin/config.php.inc
$cfg['Servers'][$i]['host'] = '<sql_host>'; // MySQL hostname or IP address06 WINDO
Add root user connection from <pmahost>
GRANT ALL ON * TO root@<pmahost> IDENTIFIED BY '<root_super_pwd>';