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 vote357 views1 answer
Cahnge column name apex oracle
SQL
0 vote316 views1 answer
Sql select first and last record of each group
SQL
2 votes346 views1 answer
Revokeprivileges mysql
SQL
0 vote353 views2 answers
Create-toys-table-with-toy_name-column
SQL
15 votes344 views4 answers
Mysql export database command line
SQL
0 vote356 views1 answer
Oracle list datafiles
SQL
0 vote326 views1 answer
Horizontal join sqlite
SQL
0 vote313 views1 answer
Mysql trim characters
SQL
0 vote318 views1 answer
Alter table myisam to innodb
SQL
3 votes328 views1 answer
MySQL DELETE JOIN
SQL