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

17 votes173 views6 answers
Get last record in sql
SQL
0 vote141 views1 answer
Sql: extract day text from datetime value
SQL
2 votes135 views2 answers
Mysql all columns
SQL
0 vote138 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote133 views1 answer
Object Information
SQL
2 votes145 views6 answers
Mysql change timezone
SQL
8 votes140 views3 answers
Connect python to mysql
SQL
1 vote383 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
2 votes147 views2 answers
Mysql show table column comments sql
SQL
1 vote188 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL