On the database server, we have to check the host the user above is allowed to connect from. In this case, we have to make some changes to the database server to enable the user to connect remotely. The error indicates that the host 10.24.96.5 that the database user is connecting from is not allowed to connect to the MySQL server. We encountered the error while testing database connection from one of our app servers to a database server, using the mysql client as shown. This is one of the common remote database connection errors encountered by users. In this quick article, you will learn how to solve the “ ERROR 1130 (HY000): Host x.x.x.x is not allowed to connect to this MySQL server” error in MySQL/MariaDB database deployment on a Linux system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |