Remote connection with MySQL
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;
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.