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

2 votes190 views1 answer
Enum in SQL Server
SQL
2 votes198 views1 answer
Use cases condition in sql query laravel
SQL
0 vote185 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote172 views1 answer
Excute raw query
SQL
0 vote211 views1 answer
Space not removing from column in sql
SQL
0 vote207 views1 answer
How to get data from 2 database
SQL
0 vote212 views1 answer
Excel vba import data to sql server
SQL
1 vote185 views1 answer
Postgresql substring last
SQL
2 votes220 views1 answer
Create delete procedure mysql
SQL
0 vote206 views1 answer
How to alter length character varying postgres
SQL