The location of the MySQL configuration file depends on the version of MySQL you’re using. The MySQL file is usually located at /etc/mysql/my.cnf or /etc/my.cnf or /etc/mysql//mysqld.cnf. Open the MySQL config using your favorite text editor, such as nano. Flush privileges Enable Remote connections from MySQL config.

Create a new user and allow it to connect to the database server from the specific host (or all hosts).Enable remote connections from the config.To enable the remote connections, we need to do the following steps – By default, the MySQL server only accepts connections from local hosts and not from other hosts. SQLSTATE Host '172.19.0.11' is not allowed to connect to this MySQL server error occurs when the connection request is rejected by the MySQL server. In this article, we will resolve a common error that occurs when connecting to a MySQL database remotely from outside the network or from another host. Application developers may encounter difficulties connecting to a database hosted on a server other than the local server.

Tableplus connect to localhost