为什么服务器上的 my.cnf 文件不完整或条目很少？
我已通过 ssh 访问客户端服务器 (plesk) 以查看/编辑 my.cnf 和 php.ini 文件 如果我使用 vi 查看它们，文件似乎几乎没有条目？请参阅屏幕截图。
不确定这是否是访问问题或文件是正确的文件任何帮助将不胜感激
<
img src =“https://i.sstatic.net/8w3EI.png”alt =“在此处输入图像描述”>
I have accessed a clients server (plesk) via ssh to view/edit the my.cnf and php.ini files
if i view them using vi the file seem to be virtualy empty of entries ? see screenshot.
Not sure whether this is an access issue or the files are the right files any help would be appreciated
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
正如 Rup 在他的评论中已经提到的，my.cnf 文件仅包含这几行。完全没问题，mysql 服务器也可以在没有任何配置文件的情况下启动 - 在这种情况下，它使用默认值加上命令行上的任何内容。
要查看 mysqld 读取的配置文件以及它使用的默认值，只需运行：
它将生成包含以下内容的报告：
mysqld Ver 5.0.51a-24-log for debian-linux-gnu on x86_64 ((Debian)) Default options are read from the following files in the given order: /etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf The following groups are read: mysql_cluster mysqld server mysqld-5.0 Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ----------------------------- help TRUE ... wait_timeout 3600 To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --verbose --help'.As Rup already mentioned in his comment, the my.cnf file contains only these few lines. It is completely fine, mysql server is able to start also without any config file - in that case it uses the defaults plus whatever is on the commandline.
To see what config files mysqld reads and what defaults it uses, just run:
and it will produce report containing for example this:
mysqld Ver 5.0.51a-24-log for debian-linux-gnu on x86_64 ((Debian)) Default options are read from the following files in the given order: /etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf The following groups are read: mysql_cluster mysqld server mysqld-5.0 Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ----------------------------- help TRUE ... wait_timeout 3600 To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --verbose --help'.