Answer
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
Thanks for the answer, I was searching for it for so long and at I have found it in your post.
Thank you both. I was having the same escape road problem and didn't know how to solve it until I read this article.
Thank you for presenting such fresh viewpoints; this piece has expanded my snow road understanding significantly!
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!
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!
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.
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
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.
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