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 vote133 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote166 views1 answer
Compare strings lexicographically in sql
SQL
8 votes116 views1 answer
Sql remove characters from string right
SQL
0 vote121 views1 answer
Mysql money value
SQL
0 vote125 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
1 vote143 views1 answer
How to put value in variable mysql
SQL
0 vote134 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote121 views1 answer
Mysql with
SQL
3 votes129 views2 answers
Mysql create timestamp column
SQL
8 votes151 views2 answers
How to fetch data from database without last column
SQL