Four options that affect mysqld security in MySQL

This article briefly describes the four options that affect mysqld security.

--secure

The IP numbers returned by the gethostbyname () system call are checked to ensure they are parsed back to the original hostname. This makes it harder for some outsiders to get access rights by imitating other hosts. This option also adds some smart host name checks.

--skip-grant-tables

This option causes the server to not use the permissions system at all. This gives everyone the power to fully access all the databases! (by executing mysqladmin reload, you can tell a running server to start using the authorization table again.) )

--skip-name-resolve

The host name is not parsed. All the column values in the authorization table's host must be IP digits 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.