MySQL to turn on remote connection access

MySQL to turn on remote connection access

Press Ctrl+r to enter cmd command

Enter the MySQL path input mysql-u root-p password

Input use MySQL Select the database to be used

Use "grant all privileges on * * to ' root ' @ '% ' of ' identified by ' database password ' with GRANT OPTION;" command to change the settings for a remote connection.

Use the flush privileges; command to refresh the permissions you just modified to make it effective

Use select Host,user from user to see if the modification was successful. Change success will show% hint

MySQL to turn on remote connection access