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 vote304 views1 answer
Oracle list constraints
SQL
6 votes332 views2 answers
How to copy data in sql
SQL
0 vote320 views1 answer
Sql convert float to string
SQL
2 votes302 views1 answer
Select from array in psql
SQL
0 vote294 views1 answer
Oracle execute immediate quotes
SQL
0 vote308 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote326 views1 answer
Spark sql concatenate string and int
SQL
0 vote295 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote313 views1 answer
Sql offfset
SQL
4 votes319 views4 answers
Print pl sql
SQL