How to access other people's mysql

How to access other people's mysql: First find the MySQL configuration file and search for "bind-address"; then add a [#] in front of [bind-address = 127.0.0.1]; finally save and restart MySQL, and then pass Remote access is enough.

Access other people's mysql method:

Find the MySQL configuration file, search for "bind-address", and find this One line:

bind-address = 127.0.0.1 Add a # in front, comment out this line, save and restart MySQL. Then you can access it remotely. Telnet can find that the port is also open.

Example of our configuration

1. Make sure that skip-networking is deleted or blocked, otherwise TCP/IP access is not supported. 2. Add the line bind-address = 65.55.55.2, replacing 65.55.55.2. After your server address

is modified, the configuration is:

[mysqld]user = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplanguage = /usr/share/mysql/Englishbind-address = 65.55.55.2# skip-networking保存并关闭配置文件重启mysql服务器:# /etc/init.d/mysql restart

If the above method does not work, we can set it in the general mysql command mode

2. Change the table method.

It may be that your account does not allow remote login, only localhost. At this time, just log in to mysql on the computer at localhost and change the "host" item in the "user" table in the "mysql" database from "localhost" to "%"

CODE:mysql -u root -p123mysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;

More related free learning recommendations: mysql tutorial(Video)

The above is the detailed content of How to access other people's mysql. For more information, please follow other related articles on the PHP Chinese website!