open:
config.inc.php in admin/ with your favorite editor:
<?php
/* Servers configuration */
$i = 0;
/* Server xyz server (http) [1] */
$i++;
$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
$cfg['Servers'][$i]['relation'] = ‘pma_relation’;
$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
$cfg['Servers'][$i]['history'] = ‘pma_history’;
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['extension'] = ‘mysql’;
$cfg['Servers'][$i]['socket'] = ‘/var/run/mysql/mysqld.sock’;
$cfg['Servers'][$i]['connect_type'] = ‘socket’;
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['controluser'] = ‘pma’;
$cfg['Servers'][$i]['controlpass'] = ‘xyz’;
$cfg['Servers'][$i]['auth_type'] = ‘http’;
$cfg['Servers'][$i]['verbose'] = ‘xyz server’;
$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
/* End of servers configuration */
?>u
mysql> create database phpmyadmin;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON phpmyadmin.* to ‘pma’@'localhost’
identified by ‘insert password here’ with grant
option;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT USAGE ON mysql.* TO ‘pma’@'localhost’;
Query OK, 0 rows affected (0.00 sec)
mysql> 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’;
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT SELECT ON mysql.db TO ‘pma’@'localhost’;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON mysql.host TO ‘pma’@'localhost’;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
-> ON mysql.tables_priv TO ‘pma’@'localhost’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
. Such things only happen because
Recent Comments