ERROR 1418 (HY000): 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)
The above error occurs when creating a function in MySQL, the solution is.
set global log_bin_trust_function_creators=TRUE；
Read More:
- MySQL: How to Turn on Functions
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- [Solved] java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
- [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
- mysqli_ Error() has no return value (Fixed)
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- [Solved] Pyodbc.ProgrammingError: No results. Previous SQL was not a query.
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- java.sql.SQLException: Disk full (/tmp/#sql_1eaa2_60.MAI); waiting for someone to free some space
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- Bulk Update Error: #Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the m
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- [Solved] Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as