MYSQL2 What to do if there is no configuration file

1111mysql no configuration file will be configured with the default

Configuration file not used at startup

If no my.cnf file is set using the specified directory my.cnf file and the default read directory , it means that the configuration file is not loaded when MySQL starts, but instead uses the default configuration.

To modify the configuration, you can create a my.cnf file (for example:/ETC/MY.CNF) in the directory that the MySQL default reads, write the configuration that needs to be modified, and then take effect after restarting MySQL.

222 We can add a profile for him.

Create/etc/my.cnf

. Write the following configuration to a file

http://blog.csdn.net/jyongchong/article/details/77862819

Reboot is OK.

333mysql Read configuration file location

View The default directory for reading the configuration file when MySQL starts

Command

MySQL--help|grep ' my.cnf '

Output order of preference, my.cnf, $MYSQL _tcp_port, /etc/my.cnf/etc/mysql/my.cnf/ usr/local/etc/my.cnf ~/.my.cnf /etc/my.cnf,/etc/mysql/my.cnf,/usr/local/etc/ My.cnf, ~/.my.cnf

These are the MySQL default will search my.cnf directory, the order of precedence before the queue.

MYSQL2 What to do if there is no configuration file