Description of the correct solution to MySQL port problems

The following articles mainly describe the correct solution for MySQL porting problems in actual operations. If you encounter the same problem in actual operations, but you do not know how to solve it, so the following articles must be good teachers and friends for you. I hope you will have some gains.

An error occurred while importing the MySQL file.

 
 


  
  
ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled

 
 

I checked it a little and used

 
 


  
  
MySQL> set global log_bin_trust_function_creators = 1;

 
 

Command to solve the problem

The above content is an introduction to the MySQL porting problem. I hope you will get some benefits.