Move my.cnf to Different Mount Point on MySQL Server

Question

I am working on a RHEL 6.6 server which runs MySQL version 5.7.17 which I had installed by the following command:

yum install mysql-server

My client want me to move the my.cnf from it's default location /etc/my.cnf to /app/mysql/my.cnf. If I move, the mysql server fails.

I cannot find any way to do this.

If anyone know the way, please help me.

Please read this part of the manual https://dev.mysql.com/doc/refman/5.7/en/option-files.html You can export MYSQL_HOME — Eduardo Santana, Sep 03 '18 at 14:44

airhuff · Answer 1 · 2017-02-26T06:08:09.440

3

Pass --defaults-file=/app/mysql/my.cnf when mysql is launched.

Another option is to create a symbolic link to /etc/my.cnf:

ln -s /app/mysql/my.cnf /etc/my.cnf

edited Feb 26 '17 at 06:08

answered Feb 26 '17 at 05:50

airhuff

I use "service mysqld start" to start the server. It does not accept that paramener. In which command should I use this parameter? – Sultan Feb 26 '17 at 05:57
See my second option. That might be a better way of doing things anyway. – airhuff Feb 26 '17 at 06:08
I am sorry but as per client, symlink will not do. – Sultan Feb 26 '17 at 08:11

1 Answers1