Home >Database >Mysql Tutorial >How to access mysql database remotely?

How to access mysql database remotely?

黄舟
黄舟Original
2017-08-10 14:27:302419browse

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.How to access mysql database remotely?

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

7.How to access mysql database remotely?


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.

How to access mysql database remotely?

10.Complete

How to access mysql database remotely?


##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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn