找到MySQL配置文件默认路径

最新推荐文章于 2024-08-21 23:24:45 发布

虚心+坚持+感恩

最新推荐文章于 2024-08-21 23:24:45 发布

阅读量309

点赞数 1

分类专栏：笔记文章标签： MySQL 配置 lower_case_table_names 大小写 my.cnf

本文链接：https://blog.csdn.net/thgjkgdrf/article/details/118726577

版权

笔记专栏收录该内容

24 篇文章 0 订阅

订阅专栏

[root@shoes ~]# which mysqld
/usr/sbin/mysqld
[root@shoes ~]# /usr/sbin/mysqld --verbose --help |grep -A 1 'Default options'
2021-07-14 14:09:48 0 [Note] /usr/sbin/mysqld (mysqld 5.6.51) starting as process 51343 ...
2021-07-14 14:09:48 51343 [Note] Plugin 'FEDERATED' is disabled.
Default options are read from the following files in the given order:默认的选项是按照给定的顺序读取从以下文件
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
2021-07-14 14:09:48 51343 [Note] Binlog end
2021-07-14 14:09:48 51343 [Note] Shutting down plugin 'MyISAM'
2021-07-14 14:09:48 51343 [Note] Shutting down plugin 'CSV'
[root@shoes ~]# vim /etc/my.cnf
[root@shoes ~]#
[root@shoes ~]# systemctl restart mysqld.service
[root@shoes ~]#

我主要是往配置文件加入lower_case_table_names=1，区分大小写