Mysql – Change MySQL “lob_bin_trust” variable definitely

configurationloggingMySQL

I've seen this topic earlier, but it doesn't fit in my needs.

Is there anyway to set variable "log_bin_trust_function_creators" definitely in my system, except specifying it on mysql initiation (mysqld –log-bin-trust-function-creators)?

I wonder that because our MySQL runs automatically in System Start, and I don't want to change my init.d/mysqld configuration.

I think that adding some var to my.cnf would be the perfect approach, but in MySQL's log_bin Documentation, there's nothing related to it.

By the way, restarting my server in production to test this configuration isn't what I have in mind, so I count on your consideration…

Thank you in advance!

Best Answer

My.cnf Documentation is really vague, and doesn't mention what variables can or can't be defined by the file, but my problem specifically is resolved as simple as it gets.

You can specify directly in your my.cnf the following line:

log_bin_trust_function_creators=ON

I've tested it in the worst way possible (a replication problem led me to restart my server), and I'm happy it worked.

Related Solutions

Mysql – How to enable MySQL logging

Even though you used chmod 644, make sure mysql is the owner of the logs.

touch /var/log/mysql.log
chown mysql:mysql /var/log/mysql.log
touch /var/log/mysql.error.log
chown mysql:mysql /var/log/mysql.error.log

Next, restart mysqld.

Then, log into mysql and run:

mysql> show variables like '%log%';

Look at the values for general_log, general_log_file, log, log_error, etc.

Switch them on as needed and run mysqladmin flushlogs as needed.

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

No, there isn't (I just checked 1 hour ago). You can comment the bind-address in my.cnf:

Note: « 1 hour ago » is now more than 10 years ago.

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 IPs, you will then have to use a firewall.

For MySql version 8.0.13 and above, you can specify a list of comma-separated IP addresses.

bind-address = 10.0.0.1,10.0.1.1,10.0.2.1

Relevant MySql documentation.

Remember to restart your MySQL instance after changing the config file.

Best Answer

Related Solutions

Mysql – How to enable MySQL logging

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

Related Topic