How to access MySql through IP address

1. Log in to mysql:

 mysql -u root -h 127.0.0.1 -p

2. Switch database

 use mysql

3. Authorization

grant all privileges on *.* to 'root'@'127.0.0.1'identified by 'password';

Replace 127.0.0.1 with the public network IP address.

4. Check my.ini

4.1 Check if there is skip-networking

After skip-networking is enabled, MySQL cannot be accessed remotely.

For security reasons, if you want to access MySQL from a specific IP address, you can add bind-address=IP to the configuration file, provided that skip-networking is disabled.

Add under port=3306

bind-address=192.168.1.100 or bind-address=0.0.0.0

Other questions: Try mysql -u root -p -h 192.168.1.100 on the server to see if you can log in successfully. If you can log in, but cannot log in through the client machine, it means there is a problem with the firewall or security dog, so just turn it off.

Summarize

The above is the method of accessing MySql through the IP address introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!