Linux platform mysql enable remote login

During the development process, I often encounter problems with remote access to MySQL. I need to search every time, which feels too troublesome. I record it here so that I can check it later.

First, access the local mysql (log in to the terminal using ssh and enter the following command):

mysql -uroot -p

After entering the password to log in, enter the following statement:

use mysql;
grant all privileges on *.* to 'user'@'%' identified by 'password' with grant option;

in:

user is the user name

The default for mysql is root

Password is the password you set yourself

% represents any host, you can also specify an IP address

This allows any remote host to access it.

Example:

grant all privileges on *.* to 'root'@'192.168.1.100' identified by '' with grant option;

That is, allow 192.168.1.100 to log in as the root user without a password.

Okay, that’s all, hope it helps you.