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?