症状:在phpmyadmin那边打不开表,提示 #1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'
解决:
1、在服务器登录mysql
# ./mysql -uroot -p
> source /path/to/phpmyadmin/examples/create_tables.sql;
> GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY '';
> flush privileges;
> exit;
2、在浏览器刷新phpmyadmin,发现可以打开表了