Four different options that affect MySQL database mysqld Security

This article mainly describes four options that affect MySQL database mysqld security. If you are interested in these four options, you can use the following article to better understand it. The following is a description of its specific content.

This article briefly introduces four options that affect the security of MySQL (the best combination with PHP) d.

 
 

  
  
secure  
 
 

The IP number returned by the gethostbyname () system call is checked to ensure that they are resolved back to the original host name. This makes it harder for some outsiders to obtain access permissions by imitating other hosts. This option also adds some clever host name checks.

 
 

  
  
skip-grant-tables  
 
 

This option causes the server to not use the permission system at all. This gives everyone the right to fully access all databases! (By executing the MySQL database admin reload, you can tell a running server to start using the authorization table again .)

 
 

  
  
skip-name-resolve  
 
 

The host name is not resolved. The column values of all hosts in the authorization table must be IP numbers or localhosts.

 
 

  
  
skip-networking  
 
 

TCP/IP connections are not allowed on the network. All connections to MySQL (the best combination with PHP) d must be made through Unix sockets. This option is not suitable for systems that use MIT-pthreads, because the MIT-pthreads package does not support Unix sockets.

The above content is an introduction to the four options that affect MySQL database mysqld security.

The above content describes the four options that affect mysqld security in the MySQL database. I hope it will help you in this regard.