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

This article will explain in detail how to solve the setting problem of MySql remote connection. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

If you use web and the database are not on the same server, the MySQL server needs to allow remote links for the site to function properly.

There are two ways to set up remote links for MySQL:

one. Change the meter.

It may be that your account is not allowed to log in remotely, only in localhost. At this time, as long as on the computer in localhost, after logging in to mysql, change the "host" entry in the "user" table in the "mysql" database from "localhost" to "%"

Mysql-u root-pvmwaremysql > use mysql;mysql > update user set host ='% 'where user =' root';mysql > select host, user from user

two。 Authorization law.

For example, if you want myuser to connect to the mysql server from any host using mypassword.

GRANT ALL PRIVILEGES ON *. * TO IDENTIFIED BY 'mypassword' WITH GRANT OPTION; if you want to allow the user myuser to connect to the mysql server from the host with ip 192.168.1.3 and use mypassword as the password GRANT ALL PRIVILEGES ON *. * TO IDENTIFIED BY' mypassword' WITH GRANT OPTION

This is the end of this article on "how to solve the setting problem of MySql remote connection". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.