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 vote375 views1 answer
Ubuntu stop mysql from starting on boot
SQL
-1 vote366 views2 answers
Create temporary table sql
SQL
4 votes425 views1 answer
Oracle table statistics
SQL
0 vote372 views1 answer
Geopoint from json mysql function
SQL
20 votes367 views3 answers
How to open postgresql in mac
SQL
0 vote310 views2 answers
How to combine two sql queries in one result
SQL
0 vote374 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote338 views1 answer
Mysql local password denied
SQL
3 votes374 views1 answer
Create a table with an id in mysql
SQL
0 vote347 views1 answer
Count characters of string mysql
SQL