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

This article mainly introduces the MySql8 how to set up remote connection related knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe you will get something after reading this MySql8 how to set up remote connection article, let's take a look at it.

1. Log in to Mysql

Open the terminal control panel and enter mysql-uroot-p your Mysql root password to enter.

Windows press win + r to enter cmd enter, enter mysql-uroot-p your Mysql root password in the control panel

The login is successful as shown in the figure.

2. Enter the mysql library

Enter use mysql to switch the database, and the switch is successful as shown in the figure

3. Execute the update permission statement

Update user set Host='%' where User='root'; explains that "%" refers to all addresses.

As shown in the figure, the modification is successful.

4. View permissions

Select host, user from user; view permissions.

5. Test the link using the database connection tool

Database tools recommend Navicat 15 tools

Click here to download (installation package and free tutorials) extraction code: uzd8

5.1 New connection

5.2 data related information

This is the end of the article on "how to set up a remote connection in MySql8". Thank you for reading! I believe you all have a certain understanding of "how to set up a remote connection in MySql8". If you want to learn more, you are welcome to 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.