How to enable MySQL remote connection in Linux server

Preface

Learn MySQL to reorganize previous non-MK records

describe

If it is not enabled, an error message will be displayed when connecting to the database: 2003-can't connect to MYSQL

Methods/Steps

•first step

Remotely connect to the Linux system and make sure the MySQL database has been installed on the Linux system. Log in to the database.

mysql -u$user -p $pwd

•Step 2

Create a user for remote connection

GRANT ALL PRIVILEGES ON *.* TO '$username'@'%' IDENTIFIED BY '$password' WITH GRANT OPTION;

$username indicates the user name, % indicates that all computers can connect, or you can set a certain IP address to run the connection, $password indicates the password

•Step 3

Execute the flush privileges; command to take effect immediately.

FLUSH PRIVILEGES;

• Step 4

Query the database user

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

•Step 5

Then open vim /etc/mysql/my.cnf

Set bind-address = 127.0.0.1

Set to bind-address = 0.0.0.0 (device address)

Restart

/etc/init.d/mysql restart

• Check the MYsql global port (the default is 3306)
#Check the port number

show global variables like 'port';

So far, the configuration has been completed