Access denied for user 'root'@'localhost' to database 'information_schema'
程序员文章站
2024-03-14 16:57:58
...
在我想把备份的数据库导入到本地数据的时候,发生这个错误,我使用的工具是SQLyog
Access denied for user 'root'@'localhost' to database 'information_schema'
明明是root账号操作的,怎么会没权限呢?
最终发现目标数据库没选对,需要先在目标服务器建一个库,然后下拉选中正确的目标数据库就OK了。
推荐阅读
-
MySQL错误:Access denied for user 'root'@'%' to database 'mytest'
-
Access denied for user 'root'@'localhost' to database 'information_schema'
-
mysql Access denied for user ‘root’@’localhost’ (using password: YES)解决方法
-
mysql ERROR 1044 (42000): Access denied for user ''@'localhost' to database
-
mysql ERROR 1044 (42000): Access denied for user ''@'localhost' to database
-
MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passw
-
error:105 Access denied for user 'root'
-
MySQL: ERROR 1044 (42000) Access denied for user ''@'localhost' to database 'aliendatabase'
-
MySQL: ERROR 1044 (42000) Access denied for user ''@'localhost' to database 'aliendatabase'
-
ERROR 1044 (42000): Access denied for user ''@'localhost' to