加载中…MySQL @ MAC OSX笔记(2)
(2013-03-23 01:28:13)
标签：
macmysqlit |
分类： 爱学习 |
刚装完mysql还在配呢，重启时就出错：ERROR! The server quit without updating
PID file (/usr/local/mysql/data/XXXXXX.pid).
找了篇文章看怎么解决的：http://icesquare.com/wordpress/mysql-starting-mysql-error-the-server-quit-without-updating-pid-file/
具体如下：
输入命令# ps aux | grep mysql | grep -v grep
列举如下：
_mysql
1382
0.0 0.9
2724904 36512
?? S
10:50PM 0:08.92
/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/data
--plugin-dir=/usr/local/mysql/lib/plugin --user=mysql
--log-error=/usr/local/mysql/data/XXXXXX.local.err
--pid-file=/usr/local/mysql/data/XXXXXX.local.pid
root
1284
0.0 0.0
2433436 168
?? S
10:50PM 0:00.03 /bin/sh
/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data
--pid-file=/usr/local/mysql/data/XXXXXX.local.pid
找出对应进程杀死：# kill 1382
确认：# ps aux | grep mysql | grep -v grep
重启mysql sever：sh-3.2#
/usr/local/mysql/support-files/mysql.server start
搞定！
mySQL常用命令：http://java-er.com/blog/mysql-ml/
喜欢
0
赠金笔
后一篇：WEKA @ MAC OSX安装