iteye_13604的博客

操作系统centos6.5mysql版本5.1.26问题描述:在服务器上用如下命令行登录:mysql -u username -ppassword返回结果:access denied for user 'username@localhost' (using password: YES)但是用如下方式登录又可以:mysql -u username -penterpassword: password...

创建存储过程之前首先看mysql数据库有没打开触发器事件服务, 否则无法创建触发器.查看方式:show variables like '%scheduler%'; +-----------------+-------+| Variable_name   | Value |+-----------------+-------+| event_scheduler | OFF ...