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

What are the options that affect mysqld security? I believe many inexperienced people don't know what to do about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Several options that affect mysqld security (transfer)

The IP numbers returned by the gethostbyname () system call are checked to make sure they resolve back to the original hostname. This makes it more difficult for some outsiders to gain access by imitating other hosts. This option also adds some smart hostname checks.

-- skip-grant-tables

This option causes the server to not use the permission system at all. This gives everyone full access to all databases! By executing mysqladmin reload, you can tell a running server to start using authorization tables again.)

-- skip-name-resolve

The hostname is not resolved. The column values of all Host in the authorization table must be IP numbers or localhost.

-- skip-networking

TCP/IP connections are not allowed on the network. All connections to mysqld must be made via Unix sockets. This option is not appropriate for systems that use MIT-pthreads because the MIT-pthreads package does not support Unix sockets.

After reading the above, have you mastered what are the options that affect mysqld security? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.