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 vote280 views1 answer
Mysql query single row
SQL
0 vote264 views1 answer
Check if a word appears at the end sql query
SQL
0 vote328 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
6 votes267 views1 answer
Sqlite foreign key
SQL
10 votes290 views5 answers
Between keyword in sql
SQL
1 vote283 views1 answer
Mysql get character set
SQL
2 votes276 views1 answer
Apex date today add days
SQL
103 votes470 views2 answers
Sql server LIKE '%%'
SQL
2 votes288 views6 answers
In operator in sql
SQL
0 vote288 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL