mysql mac terminal commands secure installation

Prevents the script from reading the default options from any option file. Print the program argument list and exit.

Other supported options include: -basedir=dir Therefore, when running the installation script, you would use the command: mysql_secure_installation -host=::1 -port=3307 To do so, you need to add the ::1 local host address and change the default port (3306) to 3307. The most commonly used mysql_secure_installation options are -host and -port.įor example, you can configure MySQL to permit IPv6 connections by clients that connect to the local server using port 3307. It will be read by all MySQL clients, and the options specified will apply to all clients. Open the file and add the wanted options to the group. If the program reads option files, the output indicates the name of the files and which option groups it recognizes. To check whether the program reads option files, use the mysql -help command. Note: MySQL can read startup options from option files (also called configuration files).

Mysql mac terminal commands secure installation