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

60 votes266 views6 answers
Add column in sql
SQL
1 vote104 views1 answer
Table information in sql server
SQL
0 vote112 views1 answer
Sparql list all graphs
SQL
1 vote142 views1 answer
Size of all tables in a schema oracle
SQL
6 votes113 views3 answers
Mysql remove user privileges
SQL
0 vote107 views1 answer
Sql value exists in column
SQL
0 vote107 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes101 views1 answer
Oracle number to percentage
SQL
-1 vote125 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote108 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL