MySQL remote access permission, allowing remote connection to be enabled _ MySQL
Source: Internet
Author: User
MySQL remote access permission, allowing remote connection to enable bitsCN.com
MySQL remote access permission, allow enabling remote connection 1. log on to mysql Database mysql-u root-p to view the user table mysql> use mysql; Database changedmysql> select host, user, password from user; + -------------- + ------ + principal + | host | user | password | + -------------- + ------ + principal + | localhost | root | * principal | 192.168.1.1 | root | * A731AEBFB621E354C D41BAF207D884A609E81F5E | + ---------------- + ------ + --------------------------------------- + 2 rows in set (0.00 sec) can be seen as the root user created in the user table. The host field indicates the Host to log on to. The value can be an IP address or a host name. (1) If you want to log on with a local IP address, you can change the Host value to your own Ip address.
2. implement remote connection (authorization). Changing the host field value to % indicates that the root user can log on to the mysql server on any client machine. we recommend that you set the value to % during development. Update user set host = '%' where user = 'root'; change the permission to ALL PRIVILEGESmysql> use mysql; Database changedmysql> grant all privileges on *. * to root @ '%' identified by "root"; Query OK, 0 rows affected (0.00 sec) mysql> select host, user, password from user; + -------------- + ------ + --------------------------------------- + | host | user | password | + ---------------- + ------ + host + | localhost | root | * host | 192.168.1.1 | root | * host | % | root | * A731AEBFB621E354CD41BAF207D884A609E81F5E | + ---------------- + ------ + ----------------------------------------- + 3 rows in set (0.00 sec) in this way, the machine can remotely access MySql.3 on the machine with the username, root password, and root password to achieve remote connection (change the table method) use mysql; update user set host = '%' where user = 'root'; in this way, the remote user can access Mysql through the root user. author XL.LiangbitsCN.com
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.