I have a virtual box with 2 installed instances of MySQL.
- /etc/mysql/my.cnf - /var/lib/mysql - port = 3306
- /etc/mysql2/my.cnf - /var/lib/mysql2 - port = 3307
I can connect to both. The first instance is fine. The second is not.
MySQL doesn't ignoring some params from
my.cnf file (socket, port, pid-file, data-dir...). But if I'm trying to change something else: cache, buffers, log files it completely ignores changes after restarting.
I need to make MySQL read all params from my.cnf.
- to move
- commenting out
Could someone guide me?