#1698 – Access denied for user ‘root’@’localhost’
创建一个和root同等权限的账号。 用下面的代码创建一个新用户，并将所有的权限赋予这个用户。 CREATE USER ‘yourName’@’localhost’ IDENTIFIED BY ‘yourPassword’; GRANT ALL PRIVILEGES ON *.* TO ‘yourName’@’localhost’ WITH GRANT OPTION; FLUSH PRIVILEGES; 将yourName改为用户名，yourPassword改为你定义的密码。
Warning in ./libraries/plugin_interface.lib.php#551
用vim编辑plugin_interface.lib.php文件： vim /usr/share/phpmyadmin/libraries/plugin_interface.lib.php 将 if ($options != null && count($options) > 0) { 改为 if ($options != null && count((array)$options) > 0) {
ERROR 1067 (42000): Invalid default value for ‘created_at’
问题是由于sql_modes导致的，你通过命令检查当前的sql_modes： show variables like ‘sql_mode’; 删除sql_mode中的“NO_ZERO_IN_DATE,NO_ZERO_DATE”就可以了。 通过root权限用下命令将sql_mode全局设置为： set global sql_mode = ‘ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBS … 继续阅读
Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable
编辑文件/usr/share/phpmyadmin/libraries/sql.lib.php的613行 nano +613 /usr/share/phpmyadmin/libraries/sql.lib.php 替换 ((empty($analyzed_sql_results[‘select_expr’])) || (count($analyzed_sql_results[‘select_expr’] == 1) && ($analyzed_sql_results[‘selec … 继续阅读