Open the terminal control panel and entermysql -uroot -pyour Mysql root password
Enter
Windows press win r and enter cmd and press Enter. In the control panel, enter
mysql -uroot -p your Mysql root password
Press Enter
If the login is successful as shown in the picture,
and enter
use mysql
to switch the database, as shown in the figure. Switch successful
update user set Host='%' where User=' root';
Explanation: "%" refers to all addresses.
As shown in the picture, the modification is successful
select host, user from user;
View permissions.
Recommended database tool
Navicat 15
Tool
Click here to download (installation package and free usage tutorial) extraction code: uzd8
The above is the detailed content of How to set up remote connection in MySql8. For more information, please follow other related articles on the PHP Chinese website!