标题:在phpMyAdmin中提示“Configuration of pmadb… not OK”解决办法   出处:向东博客 专注WEB应用 构架之美 --- 构架之美,在于尽态极妍 | 应用之美,在于药到病除 时间:Sat, 17 Sep 2016 20:45:57 +0000 作者:jackxiang 地址:http://jackxiang.com/post/8952/ 内容: 在phpMyAdmin中提示“Configuration of pmadb… not OK”,如下图所示: “Configuration of pmadb… not OK”解决办法,这个问题不大,不影响使用,仅仅是一个警告。如果不想总是看见这个警告,可以用如下办法来解决。 (1)初始化phpmyadmin数据库 cd /Library/WebServer/Documents/phpmyadmin/sql mysql -u root -p < create_tables.sql Enter password: mysql> CREATE DATABASE phpmyadmin; Query OK, 1 row affected (0.02 sec) mysql> use phpmyadmin Database changed mysql> source /data/htdocs/dev.XXX.com/phpmyadmin/sql/create_tables.sql (2)创建数据库用户 CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'pma'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; (3)配置config.ini.php文件 vim config.inc.php /** * phpMyAdmin configuration storage settings. */ /* User used to manipulate with storage */ // $cfg['Servers'][$i]['controlhost'] = ''; // $cfg['Servers'][$i]['controlport'] = ''; // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass'; 参考: http://wlb.wlb.blog.163.com/blog/static/46741320158199711556/ http://bbs.vpser.net/thread-13962-1-1.html Generated by Jackxiang's Bo-blog 2.1.1 Release