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 vote118 views1 answer
Change date in pivot table to month in sql server
SQL
17 votes129 views6 answers
Get last record in sql
SQL
0 vote117 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote276 views1 answer
Power bi connect to postgresql
SQL
-1 vote156 views1 answer
Minus vs except in sql
SQL
0 vote116 views1 answer
How to see the query of a view in mysql
SQL
0 vote115 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
11 votes127 views2 answers
How to import mysql database command line
SQL
0 vote77 views1 answer
Online sql compiler
SQL
0 vote146 views1 answer
Isnull in sqlite
SQL