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

In this article, the editor introduces "how to enable remote access by mysql" in detail, with detailed content, clear steps and proper handling of details. I hope this article "how to enable remote access by mysql" can help you solve your doubts.

Mysql enables remote access:

1. Open mysql server and set mysql access permissions

Mysql > grant all privileges on *. * to 'root'@'%' identified by' youpassword' with grant option

Description: Root represents the user name,% represents all ip addresses, or you can set the specified ip address

2. Executing flush privileges

3. Looking at the user table, you can see:

The value of host is%, which means that when root users log in to mysql, any ip can be allowed to access mysql server.

4. If you use the mysql management tool navicat, you cannot connect to the database, and you will be prompted with an error number (10038).

Solution:

Command to open

Vi / etc/mysql/my.conf

Set

Bind-address = 127.0.0.1

Change to

Bind-address = 0.0.0.0

Then restart mysql Server:service mysql restart

After reading this, the article "how to enable remote access by mysql" has been introduced. If you want to master the knowledge points of this article, you still need to practice and use it yourself. If you want to know more about related articles, please follow the industry information channel.

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.