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

0 vote106 views1 answer
Sql server express download
SQL
0 vote111 views1 answer
Add alternate add column sql
SQL
0 vote127 views1 answer
How to retrive the today date sql
SQL
13 votes100 views6 answers
Mysql update from select
SQL
0 vote61 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote116 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote113 views1 answer
View to table
SQL
0 vote114 views1 answer
Rollback to name in sql
SQL
25 votes132 views1 answer
How to update an attribute in MySQL
SQL
3 votes174 views1 answer
Mysql group_concat distinct
SQL