How to access mysql database remotely?

How to access mysql database remotely.

1. First make sure it is installed and can be used, and remote access to the database is turned on;

2. If the other party is not a fixed IP, you can use a peanut shell to act as a fixed IP. How to install the peanut shell and how to use it

3.The next step is to visit

4. First enter cmd

5.

6. This will open the command prompt, as follows:

7.

8. After opening, enter mysql -h your IP or peanut shell account -uroot -p the password of the database

For example:

mysql -h30.158.59.78 -uroot -pabc123
mysql -htom.xicp.net -uroot -pabc123
9

9.

10.Complete

##Note

Pay attention when operating and observe and follow the steps.

The above is the detailed content of How to access mysql database remotely?. For more information, please follow other related articles on the PHP Chinese website!