有时候修改my.cnf配置文件但是无法生效,可能原因是修改的并不是服务器读取的文件,如果不知道当前使用的配置文件路径,可以在终端输入如下命令:
liushiyi@liushiyiPC ~ $ which mysqld
/usr/sbin/mysqld
liushiyi@liushiyiPC ~ $ mysqld --verbose --help|grep -A 1 'Default options'
mysqld: One can only use the --user switch if running as root
180825 16:41:57 [Note] Plugin 'FEEDBACK' is disabled.
180825 16:41:57 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
阅读(4867) | 评论(0) | 转发(0) |