Shulou(Shulou.com)05/31 Report--

Many novices are not very clear about how to enable remote access in Mysql. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

Mysql is not accessible from a remote machine by default. Remote access can be enabled through the following configuration.

1. Modify / etc/mysql/my.conf, modify bind-address, specify the actual IP address of the machine, and your my.con will look like the following

[mysqld]

#

# * Basic Settings

#

Default-character-set=utf8

Default-storage-engine=INNODB

Bind-address = 192.168.1.107

User = mysql

Pid-file = / var/run/mysqld/mysqld.pid

Socket = / var/run/mysqld/mysqld.sock

Port = 3306

Basedir = / usr

Datadir = / var/lib/mysql

Tmpdir = / tmp

Language = / usr/share/mysql/english

Skip-external-locking

two。 Log in to mysql with root and execute the following command

Grant all on sonardb.* to sonar@% identified by 123456

Grant all on sonardb.* to sonar@localhost identified by 123456

Sonardb is replaced with the name you want to access, sonar is the user name you want to use, and 123456 is replaced with your password, thus enabling remote access.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.