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

244 votes466 views14 answers
Sql n insert
SQL
2 votes182 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote217 views1 answer
How to create notes in mysql
SQL
11 votes171 views2 answers
Mysql set safe mode off
SQL
1 vote190 views1 answer
Mysql select if empty result
SQL
1 vote185 views1 answer
SQL Integer devision
SQL
5 votes239 views1 answer
Migrate sql table another database
SQL
1 vote184 views5 answers
Postgresql difference between two dates in days
SQL
7 votes181 views3 answers
Sql set
SQL
7 votes175 views2 answers
MySQL IF without else
SQL