Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
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.×