Configuration update doesn't take effect with mysql service restart
I am relatively new to MariaDB. I was trying to configure Mariadb 10.0.25 for a remote client access and replication. For this, I added server-id=1 and bind-address=10.0.0.5 within [mysqld] section in /etc/mysql/my.cnf, then restarted the mysql service (sudo service mysql restart). But it seems the configuration update is not reflected even after restart. The changes take effect only if the machine is rebooted! I wonder how to solve this problem.
I also checked the values of the global variables to see if they are changed using commands like show global variables like 'server_id';. It works with server_id, but bind_address doesn't seem to work despite it is said to be a system global variable. Did I miss something here?
Thank you very much in advance for your answer/solutions.
Answer Answered by Ian Gilfillan in this comment.
bind-address is not actually a variable (UPDATE: it is a variable from MariaDB 10.3.3), but rather a server option (it shouldn't be listed in the server variables page), so you cannot view it with SHOW VARIABLES.
It would be useful to make it visible as a variable, and this has been requested - see MDEV-10346.
That said, changes take effect after a server restart - that's when they are read in. I can't see how they could only be read upon reboot, and not restart, unless there are some scripts causing havoc, set to read configs in different locations perhaps.
