Step 3 of remote connection to MySQL

The following article describes how to remotely connect to a MySQL database. We will describe the procedure in three parts, including how to create a new user correctly, the actual steps for modifying the configuration are described as follows.

1. Create a new user

 
 


  
  
Grant all on *. * to 'username' identified by "xuys1234 ";

 
 

2. modify configurations

Sudo vim/etc/MySQL/my. cnf

Bind-address = 127.0.0.1 to be commented out

3. Restart MySQL

 
 


  
  
Sudo/etc/init. d/MySQL restart

 
 

To change the password, use the following statement:

 
 


  
  
UPDATE user SET password = PASSWORD ("new password") WHERE user = 'name'; flush privileges;

 
 

The above content is an introduction to the remote connection to MySQL. I hope you will get some benefits.