跳舞的驴子

MySQL开启bin-log后，调用存储过程或者函数以及触发器时，会出现错误号为1418的错误: 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* w

解决方案： /etc/init.d/mysql stop (service mysqld stop )  /usr/bin/mysqld_safe --skip-grant-tables  另外开个SSH连接  [root@localhost ~]# mysql  mysql>use mysql  mysql>update user set password=password(