I want to customize the function today, but the mysql console reports an error
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
It means I don’t have the function function enabled
show variables like '%func%';
Here I have turned on the function function as on
setting parameters to turn on the function function
set global log_bin_trust_function_creators=1;
Read More:
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- How to Solve Mysql8 load data error
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- How to Solve mysql [Err] 1067-Invalid default value for
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- How to Check the most CPU consuming 50 queries in MYSQL
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- How to Solve MYSQL into outfile Error13
- How to Solve MYSQL Error: No module named MySQLdb
- MYSQL: How to Use ifnull()
- How to Solve c3p0 connect mysql8.0 Error
- How to Solve MYSQL ERROR: relation “table_name” does not exist
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- How to Fix MySQL error 1005: can’t create table (errno: 150)