Shulou(Shulou.com)05/31 Report--

How to access mysql database remotely? in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Method 1: change localhost to "%"

Modify the "host" entry in the "user" table in the "mysql" database to change "localhost" to "%"

Mysql > usemysql

Mysql > updateusersethost='%'whereuser='root'

Mysql > selecthost,userfromuser

Mysql > FLUSHPRIVILEGES

Method 2: use myuser/mypassword to connect to the mysql server from any host:

GRANTALLPRIVILEGESON*.*TO'myuser'@'%'IDENTIFIEDBY'mypassword'WITHGRANTOPTION

Use myuser/mypassword to connect to the mysql server from the host with ip 192.168.225.166:

GRANTALLPRIVILEGESON*.*TO'myuser'@'192.168.225.166'IDENTIFIEDBY'mypassword'WITHGRANTOPTION

Method 3: universal authorization

Mysql-hlocalhost-uroot

Mysql > GRANTALLPRIVILEGESON*.*TO'root'@'%'WITHGRANTOPTION;// gives access to data as root on any host

Mysql > FLUSHPRIVILEGES

This is the answer to the question about how to access the mysql database remotely. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.