blocks|key|2036513|text|+++++GRANT+ALL+PRIVILEGES+ON+*.*+TO+'root'@'127.0.0.1';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2036514|http://dev.mysql.com/doc/refman/5.1/en/adding-users.html|unstyled|offset|length|2036515|编辑。|2036516|这是因为mysql服务器处于read_only选项中。关掉它|2036517|使用root用户连接到服务器：|2036518|mysql-h+localhost-u+root-p|2036519|然后运行命令：|2036520|mysql>+set+GLOBAL+read_only+=+false;

mysql>+FLUSH+TABLES+WITH+READ+LOCK;
mysql>+UNLOCK+TABLES;|2036521|EDIT2；|2036522|您必须停止服务器并运行以下命令|2036523|mysqld_safe+--skip-grant-tables由于根pwd+chg|style|CODE|2036524|因此，停止服务器并正常启动它。|2036525|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1K|0|0|0|0|0|0|0|0|0|0|0|V|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|1C|8|@]|9|@$G|1D|H|1E|1|1F]]|A|$]]|$1|I|3|J|5|F|7|1G|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1H|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1I|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1J|8|@]|9|@]|A|$B|C]]|$1|Q|3|R|5|F|7|1K|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1L|8|@]|9|@]|A|$B|C]]|$1|U|3|V|5|F|7|1M|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1N|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1O|8|@$G|1P|H|1Q|10|11]]|9|@]|A|$]]|$1|12|3|13|5|F|7|1R|8|@]|9|@]|A|$]]|$1|14|3|-4|5|F|7|1S|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|E]]]]

<pre><code> GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
</code></pre>

<a href="http://dev.mysql.com/doc/refman/5.1/en/adding-users.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/adding-users.html</a>

EDIT.

this because your mysql server is on read_only option. to turn it off

connect to the server with root user:

<pre><code>mysql-h localhost-u root-p
</code></pre>

and run the command:

<pre><code>mysql&gt; set GLOBAL read_only = false;

mysql&gt; FLUSH TABLES WITH READ LOCK;
mysql&gt; UNLOCK TABLES;
</code></pre>

EDIT2;

you must have stop the server and run this

<code>mysqld_safe --skip-grant-tables</code> due to root pwd chg

so stop the server and start it normal with a start

blocks|key|2036551|text|当服务器使用--跳过-授予-表运行时，禁用所有MySQL安全性，因此不允许GRANT命令。您可以做的是访问"mysql“数据库，并直接选择和更新需要更改的行。在您的情况下，它将是user表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2036552|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

When your server is running with --skip-grant-tables, you disable all MySQL security so you're not allowed GRANT commands. What you can do, is access the "mysql" database and directly SELECT and UPDATE the rows you need to change. In your case it will be the user table.

blocks|key|230223|text|我也有过同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|230224|您可以将skip-grant-tables添加到[mysqld]标记的#+The+MySQL+server下的my.ini文件中，并重新启动mysql服务器。|offset|length|style|CODE|230225|现在您可以打开phpmyadmin并转到mysql数据库中的user表。确保密码属性的值为空，主机属性值为localhost。我正面临着第二个错误。PHPMyAdmin试图以“localhost”的形式连接主机值，表中包含值127.0.0.1。|230226|从my.ini中删除跳过授予表并重新启动mysql服务器。这应该能行。|230227|entityMap^0|0|4|H|O|8|Z|I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]|$D|R|E|S|F|G]|$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

I had the same issue. 

You can add <code>skip-grant-tables</code> to the my.ini file for the <code>[mysqld]</code> tag, under <code># The MySQL server</code>, and restart the mysql server. 

You can now open phpmyadmin and go to the user table in the mysql database. Make sure that the value of the password attribute is empty and that the value of host attribute is localhost. I was facing the second error. PHPMyAdmin was trying to connect with host value as 'localhost' and the table contained the value 127.0.0.1.

Remove skip-grant-tables from my.ini and restart the mysql server. This should work.

blocks|key|2036582|text|一个简单的插图解决方案！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2036583|​|2036584|📷|atomic|offset|length|2036585|2036586|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/f1f7a3283018a836709a193db5441e75.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

<h2>A simple Illustrated solution!</h2>

<a href="https://i.stack.imgur.com/beT2u.png" rel="noreferrer"><img src="https://i.stack.imgur.com/beT2u.png" alt="enter image description here"></a>

blocks|key|230255|text|我通过重新安装服务器解决了这个问题。新配置(my.ini)不包含--skip-grant-tables选项，而且我能够按预期的方式连接到服务器。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|230256|在进行新安装之前，不要忘记备份数据库。|230257|entityMap^0|M|6|W|J|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

I solved the issue by reinstalling the server.
The new configuration (<code>my.ini</code>) does not contain the <code>--skip-grant-tables</code> option and I am able to connect to the server as expected.
Don't forget to backup your databases before you do the new installation.

blocks|key|894184|text|单击图像中的配置显示|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|894185|单击图像中的my.ini显示|894186|在mysqld之后添加skip-grant-tables并在图像中保存显示。(此处编辑的拼写问题)|894187|现在重新启动mySQL。就这样|894188|unstyled|894189|894190|​|894191|📷|atomic|894192|894193|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/b740df5182d7bbe1904901feba00c3ab.png|imageAlt^0|6|2|0|6|6|0|B|H|0|6|5|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|M|7|1F|8|@]|D|@]|E|$]]|$1|N|3|-4|5|M|7|1G|8|@]|D|@]|E|$]]|$1|O|3|P|5|M|7|1H|8|@]|D|@]|E|$]]|$1|Q|3|R|5|S|7|1I|8|@]|D|@$9|1J|A|1K|1|1L]]|E|$]]|$1|T|3|P|5|M|7|1M|8|@]|D|@]|E|$]]|$1|U|3|-4|5|M|7|1N|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11|12|-4]]]]

<ol>
<li>Click on config show in image</li>
<li>Click my.ini show in image</li>
<li>add skip-grant-tables after [mysqld] and save show in image. (*edited spelling issue here)</li>
<li>Now restart mySQL. that's all</li>
</ol>
<a href="https://i.stack.imgur.com/XhwEp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XhwEp.png" alt="enter image description here" /></a>

I know this type of question has been asked lots of times, but none answer my problem. 
Please read carefully.

I was running my website on localhost using Wamp server normally. When today i decided to run an Acunetix scan for vulnerabilities on my localhost server.

Acunetix sent tons of commands to the mysql table in short period of time ( since it's localhost the commands went fast ) which cause my mysql server to crash with the error:

<pre><code>#1130 - Host 'localhost' is not allowed to connect to this MySQL server 
</code></pre>

What I've already tried:

Running mysql through mysqld --skip-grant-tables
I had access to mysql while on that, so I tried running

<pre><code>DROP USER 'root'@'127.0.0.1'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';
</code></pre>

But I got the error:

<pre><code>mysql&gt; DROP USER 'root'@'127.0.0.1'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt
ion so it cannot execute this statement
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'TO 'r
oot'@'%'' at line 1
</code></pre>

I admit I do am a mysql noob but I did my homeworks and searched google, but was unable to find the solution.

Any help ?

I managed ti fix the issue by reinstalling wamp server and fully uninstalling, even with the mysql.

#1130 - Host 'localhost' is not allowed to connect to this MySQL server - After running an Acunetix scan

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我知道这类问题被问了很多次，但没有人回答我的问题。请仔细阅读。我正常使用Wamp服务器在本地主机上运行我的网站。今天，我决定对本地主机服务器上的漏洞进行Acunetix扫描。Acunetix在短时间内向mysql表发送了大量命令(因为它是本地主机，所以命令执行得很快)，这导致mysql服务器出现错误：#1130 - H...

问#1130 -在运行MySQL扫描之后，不允许主机'localhost‘连接到此服务器
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问#1130 -在运行MySQL扫描之后，不允许主机'localhost‘连接到此服务器EN