Linux mysql Add remote connection

Method/Step

• The first step

Connect the Linux system remotely to ensure that the Linux system is installed on the MySQL database. Log in to the database.

mysql -u$user -p $pwd

• Step Two

Create a user to connect remotely

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

$username represents the user name,% means that all computers can connect, or you can set an IP address to run the connection $password indicate the password

• Step Three

Execute flush privileges; command takes effect immediately

FLUSH PRIVILEGES;

• Fourth Step

Users querying the database

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

• Fifth Step

Then open vim/etc/mysql/my.cnf.
Will bind-address = 127.0.0.1
Set to Bind-address = 0.0.0.0 (device address)

Restart

/etc/init.d/mysql restart

• View the MySQL global port (default is 3306)

#查看端口号show global variables like ‘port‘;

Alicfeng
Links: http://www.jianshu.com/p/efeb209e6621
Source: Pinterest
Copyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please specify the source.

Linux mysql Add remote connection