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

This article introduces how to set remote access permissions in the MySQL database, the content is very detailed, interested friends can refer to, I hope it can be helpful to you.

1. Enter the MySQL server

2. Mysql > GRANT ALL PRIVILEGES ON *. * TO 'root'@'%'WITH GRANT OPTION

/ / Grant any host permission to access data

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

GRANT ALL PRIVILEGES ON *. * TO 'myuser'@'%'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.6, and use mypassword as the password

GRANT ALL PRIVILEGES ON *. * TO 'myuser'@'192.168.1.3'IDENTIFIED BY' mypassword'

WITH GRANT OPTION

3. Mysql > FLUSH PRIVILEGES

/ / the modification takes effect

Mysql > EXIT

4. You need to set the firewall to release the access to port mysql 3306. Control Panel-> windows Firewall-> Advanced Settings, open another interface.

Select the inbound rule in this interface, then select the new rule in the right column, next select the port, next select TCP/ specific local port and enter 3306, next select allow connection, next default, enter the name you want to give, such as mysqlport, and click finish.

On how to set remote access permissions in the MySQL database to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it 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.