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 vote303 views1 answer
Plsql check for string in numeric
SQL
1 vote356 views1 answer
Drop colum oracle 18c
SQL
1 vote301 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
2 votes300 views2 answers
How to view created temporary tables in mysql
SQL
0 vote292 views1 answer
Sql combine results from two tables
SQL
1 vote301 views1 answer
Get count by weekly pivot table sql server
SQL
1 vote323 views1 answer
Age postgres
SQL
3 votes326 views1 answer
Query less than datetime sql
SQL
11 votes330 views6 answers
Mysql else if
SQL
3 votes332 views3 answers
Postgresql random number
SQL