PhpMyAdmin

From YobiWiki
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Navigation
Tools