I am currently trying to connect to a MySQL database through connections on my ignition localhost. In the URL, I have place the computer's IP I am trying to connect to, the port number, and a database name of a database on the other computers MySQL. jdbc:mysql://(IP OF HOST I AM TRYING TO CONNECT TO -TAKEN OUT FOR SECURITY):3306/test_db . When trying to connect, I get this error message : Cannot create PoolableConnectionFactory (null, message from server: "Host '(HOST NAME- I TOOK OUOT)' is not allowed to connect to this MySQL server"). Please provide any help that you may recommend on validating the connection.
Add the appropriate user/origin login information to that MySQL instance. By default, you only get a root user that can connect from localhost (not via any other IP address).
I tried this and changed the user and password in ignition. Still the same error message: cannot connect to MySQL database
is not allowed to connect to this MySQL server
You need to change the permissions on the MySQL side of things. MySQL is rejecting you. You need to say what user, from what ip address, is allowed to login.
If you do SELECT Host, User, FROM mysql.user; in your MySQL workbench what do you see?
1 Like