Procedure for connecting to the MySQL database remotely

The following articles describe the correct procedure for remotely connecting to the MySQL database and the tools required for local configuration of the MySQL database, the following is the main content of the article. If you are interested in the actual operation process, you may wish to browse the following article.

By default, you cannot remotely connect to the MySQL database. A permission error is reported when you connect to MySQL-Front.

You need to configure it locally in MySQL:

 
 


  
  
# MySQL-p

  
  
Enter password :******

  
  
MySQL> grant all on *. * to 'root' @ '192. 168.0.2 'identified by 'Password'

  
  
->;

 
 

After the execution, you can log on to MySQL with the root user on the remote machine 192.168.0.2.

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