Geek Answers Handbook

Why is the my.cnf file on the server incomplete or has very few entries?

I got access to the client server (plesk) via ssh to view / edit my.cnf and php.ini files; if I view them with vi, does the file seem virtual without records? see screenshot.

Not sure if this is an access problem or the files are the correct files, any help would be appreciated

thank

enter image description here

+5
source share
1 answer

Rup , my.cnf . , mysql - - , . , mysqld , :

mysqld --verbose --help

, , , :

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'.
+6

More articles:


All Articles