phpmysql root用户无权限解决办法
时间:2021-07-01 10:21:17
帮助过:4人阅读
>
use mysql;
Database changed
mysql>
select User
from user;
+-----------+
| User |
+-----------+
| mysql.sys |
| root |
+-----------+
2 rows
in set (
0.00 sec)
mysql>
update mysql.user set authentication_string=password(‘123456‘) where user=‘root‘;
Query OK, 1 row affected,
1 warning (
0.00 sec)
Rows matched: 1 Changed:
1 Warnings:
1
mysql>
flush privileges;
Query OK, 0 rows affected (
0.02 sec)
mysql>
两行命令解决问题,再打开Phpmysql4.7或刷新 试试
phpmysql root用户无权限解决办法
标签:tab hang div sele upd use date 刷新 data