Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do about MySQL error 'Variable' XXX' is a read only variable'. I hope you will get something after reading this article. Let's discuss it together.

Setting parameters Times error

Mysql > set global secure_file_priv='/database/percona'

ERROR 1238 (HY000): Variable 'secure_file_priv' is a read only variable

Reason for reporting an error:

The parameter is read-only. You need to change it in the configuration file, and then restart the database.

[mysql@localhost percona] $bin/mysqladmin-uroot-S / u01/mysql_data/mysql.sock shutdown-p

Enter password:

2017-03-13T10:38:21.340514Z mysqld_safe mysqld from pid file / u01/mysql_data/localhost.localdomain.pid ended

[1] + Done bin/mysqld_safe-- defaults-file=/u01/mysql_data/my.cnf

[mysql@localhost percona] $vim / u01/mysql_data/my.cnf

[mysqld]

Secure_file_priv='/database/percona'

[mysql@localhost percona] $bin/mysqld_safe-- defaults-file=/u01/mysql_data/my.cnf &

[1] 28543

[mysql@localhost percona] $mysqld_safe Adding'/ database/percona/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld

2017-03-13T10:46:33.142327Z mysqld_safe Logging to'/ u01Universe.

2017-03-13T10:46:33.143853Z mysqld_safe Logging to'/ u01Universe.

2017-03-13T10:46:33.166624Z mysqld_safe Starting mysqld daemon with databases from / u01/mysql_data

After reading this article, I believe you have a certain understanding of "MySQL error 'Variable' XXX' is a read only variable'". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.