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'; GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';
htdocs $ cat config.inc.php <?php $cfg['blowfish_secret'] = 'my blowfish secret';
$i = 1; $cfg['Servers'][$i]['verbose'] = 'Server'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'pmapass';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $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]['designer_coords'] = 'pma_designer_coords';
$cfg['ShowPhpInfo'] = true;
$cfg['SkipLockedTables'] = true; $cfg['LoginCookieValidity'] = 14400; $cfg['DefaultLang'] = 'english-utf-8';
$cfg['DefaultCharset'] = 'utf-8'; $cfg['FilterLanguages'] = '^(ru|en|ja)';
$cfg['AvailableCharsets'] = array( 'utf-8', );
$cfg['TitleTable'] = '@TABLE@ - @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@'; $cfg['TitleDatabase'] = '@VSERVER@ / @DATABASE@ | @PHPMYADMIN@'; $cfg['TitleServer'] = '@VSERVER@ | @PHPMYADMIN@'; $cfg['TitleDefault'] = '@PHPMYADMIN@'; $cfg['SQLQuery']['ShowAsPHP'] = false; $cfg['ForceSSL'] = true;
htdocs $ crontab -l @daily svn up ~/www/htdocs/
|