Four options that affect mysqld security in MySQL _ MySQL

Source: Internet
Author: User
Tags ip number
This article briefly introduces four options that affect mysqld security. -- 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 article briefly introduces four options that affect mysqld security.

-- 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 mysqladmin 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 mysqld 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.