Hi,
I have problem with remote connection to my MySQL database.
My changes in /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
.....
#bind-address = 127.0.0.1
I also run this lines in mysql: mysql> CREATE USER ‘monty’@‘%’ IDENTIFIED BY ‘some_pass’; mysql> GRANT ALL PRIVILEGES ON . TO ‘monty’@‘%’ WITH GRANT OPTION; mysql> FLUSH PRIVILEGES;
and finally: sudo service mysql restart
Unfortunelly I still cant’ connect with my database. What is the problem?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @rubenlech
Can you check if MySQL is listening on all interfaces:
And then let’s check the state of the firewall: