mysql报错：1044 -Access denied for user ‘root‘@‘%‘ to database ...

使用Navicat远程连接，新建数据库报错:

点击确定之后却报错:1044 -Access denied for user ‘root‘@‘%‘ to database
1.查询用户表看root用户权限

1. SELECT host,user,Grant_priv,Super_priv FROM mysql.user;

复制代码

1. [/code] [size=5]2.赋予权限[/size]
3. 然后发现很多的权限都是n 于是我修改了权限:
4. [code]use mysql;
5. update user set Update_priv ='Y' where user = 'root';
6. update user set Select_priv ='Y' where user = 'root';
7. update user set Insert_priv ='Y' where user = 'root';
8. update user set Update_priv ='Y' where user = 'root';
9. update user set Delete_priv ='Y' where user = 'root';
10. update user set Create_priv ='Y' where user = 'root';
11. update user set Drop_priv ='Y' where user = 'root';
12. update user set Reload_priv ='Y' where user = 'root';
13. update user set Shutdown_priv ='Y' where user = 'root';
14. update user set Process_priv ='Y' where user = 'root';
15. update user set File_priv ='Y' where user = 'root';
16. update user set Grant_priv ='Y' where user = 'root';
17. update user set References_priv ='Y' where user = 'root';
18. update user set Index_priv ='Y' where user = 'root';
19. update user set Alter_priv ='Y' where user = 'root';
20. update user set Show_db_priv ='Y' where user = 'root';
21. update user set Super_priv ='Y' where user = 'root';
22. update user set Create_tmp_table_priv ='Y' where user = 'root';
23. update user set Lock_tables_priv ='Y' where user = 'root';
24. update user set Execute_priv ='Y' where user = 'root';
25. update user set Repl_slave_priv ='Y' where user = 'root';
26. update user set Repl_client_priv ='Y' where user = 'root';
27. update user set Create_view_priv ='Y' where user = 'root';
28. update user set Show_view_priv ='Y' where user = 'root';
29. update user set Create_routine_priv ='Y' where user = 'root';
30. update user set Alter_routine_priv ='Y' where user = 'root';
31. update user set Create_user_priv ='Y' where user = 'root';
32. update user set Event_priv ='Y' where user = 'root';
33. update user set Trigger_priv ='Y' where user = 'root';
34. // 退出mysql
35. exit

复制代码

3.再次查询的时间去确认权限已修改

4.重新启动mysql 

1. // 重启mysql服务
2. service mysqld restart

复制代码

5.革新navicat,重新创建数据库 --成功

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。