MySQL 报错'Variable 'XXX' is a read only variable'

谁践踏了优雅 2024-04-18 01:23 97阅读 0赞

设置参数时报错  
mysql> set global secure\_file\_priv='/database/percona';  
ERROR 1238 (HY000): Variable 'secure\_file\_priv' is a read only variable  
  
报错原因：  
参数为只读参数，需要在配置文件中更改该参数，之后重启数据库  
  
\[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 '/u01/mysql\_data/mysqld\_error.log'.  
2017-03-13T10:46:33.143853Z mysqld\_safe Logging to '/u01/mysql\_data/mysqld\_error.log'.  
2017-03-13T10:46:33.166624Z mysqld\_safe Starting mysqld daemon with databases from /u01/mysql\_data

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2135259/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2135259/