Shulou(Shulou.com)06/01 Report--

Editor to share with you how to set remote connection permissions in mysql database. I hope you will gain a lot after reading this article. Let's discuss it together.

Problem phenomenon

After mysql is installed, the login of this machine is normal. Enter the correct account password remotely and connect to the Times as follows.

Cause of the problem

Remote IP does not have login permission. Root users can only log in on localhost by default, that is, they can only log in locally. Other IP login permissions need to be set.

Solution

1. Log in to the database inside the server and execute

Grant all privileges on *. * to 'root'@'%' identified by' 123456 'with grant option

This statement means that root users can log in to the database at any IP and manipulate any object in any database.

Where:

*. The first * refers to the database.

* represents all databases

The second * refers to the database object

* represents all objects in the database

'root'@'%' root is the database user that is established to be authorized

% represents the IP allowed to log in

123456 is your database password.

If you want to limit login to 1.1.1.1, change% to 1.1.1.1, and perform flush privileges; refresh permissions after execution.

two。 Then the mysql client on the remote computer can connect.

After reading this article, I believe you have a certain understanding of how to set remote connection permissions in mysql database. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.