mysql问题

root@sinpc:/home/sin/wkspace/soft/python/jobfind# sudo start mysql
start: Job failed to start

dmesg | grep mysql

[ 2633.348055] type=1400 audit(1390136681.803:37): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=15887 comm="apparmor_parser"
[ 2635.170895] init: mysql main process (15891) terminated with status 7
[ 2635.170916] init: mysql main process ended, respawning
[ 2635.385753] init: mysql post-start process (15892) terminated with status 1

$ service mysql status
mysql stop/waiting

解决：

http://waynehu16.iteye.com/blog/1557777

5.5以后的版本对字符编码方式修改的办法，才发现原来在[mysqld]下的修改已经发生了变化，正确方式如下：

[mysqld]下添加的应该为：

character-set-server=utf8

collation-server=utf8_general_ci

        保存退出

$sudo service mysql restart

        果然成功重启

$mysql

         之后出现

mysql>

         输入show variables like 'character%';

         输出如下：