mysql突然无法启动,重装后还是如此的问题,求解答
时间:2011-12-28
来源:互联网
源码安装mysql5.5,安装参数
cmake .
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/service/data/
-DMYSQL_UNIX_ADDR=/service/data/mysqld.sock
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DSYSCONFDIR=/etc
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_unicode_ci
-DWITH_DEBUG=0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
之后操作
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
bash scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/service/data/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
第一次安装后可以使用,好像是升级ubuntu系统后,关机,后来就无法使用了,启动报错
root@ubuntu:/usr/local/mysql/data/mysql# /etc/init.d/mysqld start
Starting MySQL
.. * The server quit without updating PID file (/var/lib/mysql/ubuntu.pid).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
查看进程
root@ubuntu:/usr/local/mysql/data/mysql# ps -f | grep mysql
root 19714 1928 0 00:32 pts/0 00:00:00 grep --color=auto mysql
好像杀不掉
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
查看错误日志
root@ubuntu:/usr/local/mysql/data/mysql# vi /var/log/mysql/error.log
111228 00:31:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111228 0:31:14 [ERROR] Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys'
111228 0:31:14 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
111228 0:31:14 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
^G/usr/local/mysql/bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
111228 0:31:14 [ERROR] Aborting
111228 0:31:14 [Note]
111228 00:31:14 mysqld_safe mysqld from pid file /var/lib/mysql/ubuntu.pid ended
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
网上搜了很多办法,都无法解决问题,关键是重新安装后页无法解决问题,请问各位大侠,如何是好?急死了
cmake .
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/service/data/
-DMYSQL_UNIX_ADDR=/service/data/mysqld.sock
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DSYSCONFDIR=/etc
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_unicode_ci
-DWITH_DEBUG=0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
之后操作
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
bash scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/service/data/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
第一次安装后可以使用,好像是升级ubuntu系统后,关机,后来就无法使用了,启动报错
root@ubuntu:/usr/local/mysql/data/mysql# /etc/init.d/mysqld start
Starting MySQL
.. * The server quit without updating PID file (/var/lib/mysql/ubuntu.pid).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
查看进程
root@ubuntu:/usr/local/mysql/data/mysql# ps -f | grep mysql
root 19714 1928 0 00:32 pts/0 00:00:00 grep --color=auto mysql
好像杀不掉
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
查看错误日志
root@ubuntu:/usr/local/mysql/data/mysql# vi /var/log/mysql/error.log
111228 00:31:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111228 0:31:14 [ERROR] Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys'
111228 0:31:14 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
111228 0:31:14 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
^G/usr/local/mysql/bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
111228 0:31:14 [ERROR] Aborting
111228 0:31:14 [Note]
111228 00:31:14 mysqld_safe mysqld from pid file /var/lib/mysql/ubuntu.pid ended
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
网上搜了很多办法,都无法解决问题,关键是重新安装后页无法解决问题,请问各位大侠,如何是好?急死了
作者: w618713 发布时间: 2011-12-28
重装系统
作者: popo666 发布时间: 2011-12-28
引用 1 楼 popo666 的回复:
重装系统
重装系统
大哥,这招也太狠了,好不容易搭好ROR环境。。。。
作者: w618713 发布时间: 2011-12-28
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28