MySQL报“Access denied for user 'root'@'%' to database”错误的解决方法执行 GRANT ALL PRIVILEGES ON test.* TO 'test_user'@'%' WITH GRANT OPTION 报错;错误原因user表中 'root'@'%' 没有grant的权限解决方法- **修改grant权限**
```
update mysql.user set Grant_priv='Y',Super_priv='Y' where user = 'roo
开启MySQL8远端登录You are not allowed to create a user with GRANT创建用户
Choose here
javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql
create user 'root'@'%' identified by
mysql安装完毕，默认不允许root用户远端登录，通过下面代码即可开启
Choose here
javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql
#登录数据库
mysql -uroot -p
use mysql;
#查看root用户权限
select `user`,`hos
Hot
Top
