0

ERROR 1130 (HY000)

We encountered the error while testing a database connection from one of our app servers to a database server, using the MySQL client

ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server
MySQL MySQL (My- Structured Query Language)
Comments
alentmy
May 07 2025
It seems we need to investigate the database connection settings and ensure that the MySQL client is properly configured to connect from the app server to the database <a href="<a href="https://escaperoad2.github.io">escape">https://escaperoad2.github.io">escape</a> road 2 </a> server.
Add a comment
matthew
asked Oct 06 2021
edited Oct 06 2021

Answer

0

On the database server, we have to check the host the user above is allowed to connect from.
Run the following SQL commands to check the user’s host:

 MariaDB [(none)]> SELECT host FROM mysql.user WHERE user = "database_username";

Run the following GRANT command to enable MySQL access for the remote user from a remote host

 MariaDB [(none)]> GRANT ALL ON database_name.* to 'database_username'@'10.24.96.5' IDENTIFIED BY 
 'database_password';%%
 MariaDB [(none)]> FLUSH PRIVILEGES;%%
 MariaDB [(none)]> SELECT host FROM mysql.user WHERE user = "database_username";

To give a user remote access from all host on a network, use the syntax below:

MariaDB [(none)]> GRANT ALL ON database_name.* to 'database_username'@'10.24.96.%' IDENTIFIED BY 
'database_password';

After making the above changes, try to remotely connect to the MySQL database server once more.

mysql -u database_username -p -h 10.24.96.6

We hope this solution helped you in solving your Mysql remote connection erro

Add a comment
linuxhelp
asked Oct 06 2021
Post your Answer
0

Thanks for the answer, I was searching for it for so long and at I have found it in your post.

Add a comment
AndrewBrewer
asked Jun 10 2022
Post your Answer
0

Thank you both. I was having the same escape road problem and didn't know how to solve it until I read this article.

Add a comment
ColeHarry
asked Dec 24 2024
edited Dec 25 2024
Post your Answer
0

Thank you for presenting such fresh viewpoints; this piece has expanded my snow road understanding significantly!

Add a comment
Ethancarter
asked Feb 19 2025
edited Feb 20 2025
Post your Answer
0

In Escape Road City 2enter link description here, you will have the opportunity to explore secret roads and find a way to escape before being detected by the police!

Add a comment
annaeat
asked Mar 07 2025
edited Mar 08 2025
Post your Answer
0

In escape road city 2, you will have the opportunity to explore secret roads and find a way to escape before being detected by the police!

Add a comment
annaeat
asked Mar 07 2025
edited Mar 08 2025
Post your Answer
0

thanks for sharing that. What I appreciate most about https://slope-online.org/ is how it teaches you patience and precision. You can’t just rush blindly—you have to focus, anticipate, and adapt. It’s an amazing challenge every time.

Add a comment
emilyjohnson63
asked Apr 11 2025
edited Apr 12 2025
Post your Answer
0

It seems we need to investigate the database connection settings and ensure that the MySQL client is properly configured to connect from the app server to the database server.escape road 2

Add a comment
alentmy
asked May 07 2025
edited May 08 2025
Post your Answer
0

I’ve recommended stickman hook to friends of all ages, and they all loved it. It’s accessible for younger players but also engaging enough for more experienced gamers. That wide appeal is one of the reasons it stands out among other casual games.

Add a comment
emmascott
asked Jul 16 2025
edited Jul 21 2025
Post your Answer