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 vote210 views1 answer
Systems sql
SQL
1 vote227 views3 answers
Execute sp in sql server
SQL
34 votes257 views6 answers
Alter table add foreign key mysql
SQL
-1 vote218 views1 answer
Add column alter table default value
SQL
0 vote218 views1 answer
How to display value of variable in mysql
SQL
-2 votes213 views1 answer
Create trigger syntax
SQL
0 vote211 views1 answer
List column names of multiple tables psql
SQL
11 votes219 views1 answer
Get ddl materialized view oracle
SQL
1 vote223 views2 answers
Copy database mysql
SQL
15 votes336 views2 answers
Sql order by alphabetical
SQL