PhpMyAdmin
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.inc.php
$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>';
Troubleshooting
After an update, I could not get the home page anymore, it gave an obscure internal error.
Apache2 log said:
/var/www/phpmyadmin/.htaccess: Option Indexes not allowed here
This htaccess file is in fact, via symlinks, /etc/phpmyadmin/htaccess
Commenting out the following line solved the problem.
Options +FollowSymLinks -Indexes