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%';
输出如下: