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

-1 vote247 views1 answer
Default username and password for oracle 11g
SQL
2 votes280 views3 answers
How to replace null values in sql
SQL
1 vote222 views1 answer
Sql bitwise operators
SQL
0 vote242 views1 answer
Tsql pad left
SQL
0 vote239 views1 answer
Désinstaller postgresql linux
SQL
6 votes229 views2 answers
Can't connect to local mysql server through socket
SQL
2 votes248 views1 answer
Set auto increment from 1
SQL
0 vote230 views1 answer
SQL isnumeric DB2
SQL
1 vote266 views1 answer
Sqlalchemy on delete set null
SQL
0 vote220 views1 answer
Java mysql date format
SQL