#1044-用户'root'@'localhost'对数据库'information_schema'的访问被拒绝 [英] #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

问题描述

有人向我们出售了一个脚本，不确定是否可以正常工作，因此我需要在脚本为时已晚之前对其进行测试，但是我遇到了错误#1044-用户'root'@'localhost'的访问被拒绝数据库"information_schema""

Someone sold us a script and not sure if it's working so I need to test it before it's too late however I'am getting the error "#1044 - Access denied for user 'root'@'localhost' to database 'information_schema'"

我无法完全放置代码，因此这里是pastebin链接: http://pastebin.com/P4dPRHaf

I wasn't able to put the code entirely so here is the pastebin link : http://pastebin.com/P4dPRHaf

我进行了搜索，但由于对这些内容没有经验，因此找不到真正的帮助.请注意，我正在使用Wamp服务器&当我尝试在PHPmyAdmin上导入.SQL文件时收到此错误，我猜数据库中已经存在information_schema，但是不确定应该删除哪一部分，等等.

I searched but couldn't really find a lot of help since i don't have experience on those stuff .note that I'am using Wamp server & getting this error when I try to import the .SQL file on PHPmyAdmin I guess that information_schema already exists on the database however not sure what part should I delete etc...

推荐答案

这将您从自己身上救出来.

It's saving you from yourself.

您不应在信息模式数据库上运行语句(除非您真的知道自己在做什么).该数据库用作指示服务器如何运行的元"存储库.很有可能您不需要触摸它，如果这样做，您很可能会弄乱服务器.

You should not be running statements on the info schema db (unless you REALLY know what you're doing). The database serves as a "meta" repository that dictates how the server operates. Chances are that you have no need to touch it and you'll likely brick your server if you do.

这篇关于#1044-用户'root'@'localhost'对数据库'information_schema'的访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！