Mysql allow remote connections

#open /etc/mysql/mysql.conf.d/mysqld.cnf 
#and change
#bind-address            = 127.0.0.1
#to
#bind-address            = 0.0.0.0

#then grant root all privaleges to root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

#If you ran above command and accidently
#did not change password for root you can run this:
ALTER USER 'root'@'%' IDENTIFIED BY 'MyNewPass';

Source: stackoverflow.com

Enable remote access for MySQL

[root@server #] nano /etc/csf/csf.allow
tcp:in:d=3306=IP-HERE

Source: pcx3.com

Similar codes

2 votes346 views2 answers
Sqlalchemy filter or
SQL
0 vote278 views1 answer
Get last run query sql server
SQL
3 votes338 views2 answers
Mysql import gz
SQL
4 votes347 views4 answers
What is primary key
SQL
4 votes314 views2 answers
Sql vs mysql
SQL
2 votes338 views1 answer
How to find constraints on a table in oracle
SQL
7 votes357 views3 answers
Sql set
SQL
0 vote328 views1 answer
Mysql foreach insert
SQL
6 votes352 views2 answers
Insert into select mysql
SQL
0 vote426 views1 answer
Run docker container with database as rds metabase
SQL