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 vote295 views1 answer
Sql remove non numeric characters
SQL
0 vote272 views1 answer
Change schema of all tables postgres
SQL
4 votes299 views2 answers
Oracle unlock account
SQL
0 vote274 views1 answer
Set mysql socket file docker windows
SQL
0 vote284 views1 answer
Oracle sql number to varchar2
SQL
0 vote288 views1 answer
Alter rename command in mysql
SQL
5 votes268 views1 answer
Mysql get last day of month
SQL
2 votes223 views1 answer
Sql group by different columns
SQL
0 vote286 views1 answer
Update and keep original value sql
SQL
1 vote289 views2 answers
Sql server add time to date
SQL