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

This article mainly introduces "how to allow external ip to access mysql database under linux". In daily operation, I believe that many people have doubts about how to allow external ip to access mysql database under linux. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the question of "how to allow external ip to access mysql database under linux". Next, please follow the editor to study!

1: configuration file for settin

/ etc/mysql/my.cnf

Find bind-address = 127.0.0.1 and comment it out; / / the purpose is to make it no longer only allowed for local access

Restart mysql:/etc/init.d/mysql restart; www.2cto.com

2: enter the mysql database

Mysql-u root-p

Mysql > grand all privileges on *. * to root@'%' identifies by 'xxxx'

The first * represents the database name; the second * represents the table name of the database; if it is like *. * above, it means that all tables under the database are allowed to be accessed; www.2cto.com

'%': allows access to the ip address of mysql; of course, you can also configure it to be specific to the ip name;% means that all ip can be accessed

Followed by 'xxxx' is the password of the root user

At this point, the study on "how to allow external ip to access the mysql database under linux" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.