mysql在ubuntu下奇怪的启动错误

为什么80%的码农都做不了架构师？>>>   

日志内容如下:

141119 14:33:28 mysqld_safe mysqld from pid file /usr/local/mysql/var/mot.pid ended
141119 14:33:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141119 14:33:29 [Note] Event Scheduler: Loaded 0 events
141119 14:33:29 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
141119 14:33:32 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

141119 14:33:32 [Note] Event Scheduler: Purging the queue. 0 events
141119 14:33:32 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

141119 14:33:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/mot.pid ended
141119 14:33:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141119 14:33:33 [Note] Event Scheduler: Loaded 0 events
141119 14:33:33 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

启动报错提示为:

manager or server PID file could not be found!

解决办法 把/etc/my.cnf里的mysqld的user临时换成root 然后/etc/init.d/mysql restart解决了

原来是 mysql 这个ubuntu的账户有问题 导致没办法运行mysql 具体原因还要查

转载于:https://my.oschina.net/imot/blog/346323