mysql 启动不了了(已解决)
Tofloor
poster avatar
打击越
deepin
2017-03-03 22:46
Author
本帖最后由 imever 于 2017-3-3 18:32 编辑

我的mysql是用apt-get 安装的 mysql-server-5.6 mysql-server-core-5.6
几个月没有起mysql服务了,以前正常的。今天运行的时候报错了,启动不了。信息如下:
  1. rhett@rhett-pc:~$ sudo systemctl status mysql.service
  2. ● mysql.service - MySQL Community Server
  3.    Loaded: loaded (/etc/systemd/system/mysql.service; disabled; vendor preset: enabled)
  4.    Active: failed (Result: start-limit-hit) since Fri 2017-03-03 14:16:31 CST; 12min ago
  5.   Process: 7682 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=203/EXEC)

  6. Mar 03 14:16:31 rhett-pc systemd[1]: Failed to start MySQL Community Server.
  7. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Unit entered failed state.
  8. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Failed with result 'exit-code'.
  9. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
  10. Mar 03 14:16:31 rhett-pc systemd[1]: Stopped MySQL Community Server.
  11. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Start request repeated too quickly.
  12. Mar 03 14:16:31 rhett-pc systemd[1]: Failed to start MySQL Community Server.
  13. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Unit entered failed state.
  14. Mar 03 14:16:31 rhett-pc systemd[1]: mysql.service: Failed with result 'start-limit-hit'.
Copy the Code
我看了下,/usr/share/mysql/mysql-systemd-start 这个文件没有了,应该是mysql升级后出现的,因为我进入以前快照的目录里面,是有这个文件的。

求大神指点下怎么弄



应该是更新安装的时候,把我的 /etc/apparmor.d/usr.sbin.mysqld 里面的内容更新掉了?
我的数据目录是软链接到/var/lib/mysql的,需要在把原始目录的读写权限加进去。重新加权限进去就好了。
Reply Favorite View the author
All Replies
avatar
8***8@qq.com
deepin
2017-03-04 01:48
#1
重新安装,之前升级有过一次故障把mysql给卸载了
Reply View the author
avatar
打击越
deepin
2017-03-04 02:01
#2
https://bbs.deepin.org/post/135489
重新安装,之前升级有过一次故障把mysql给卸载了

卸载重新几次mysql-server 5.6 和5.7后,已经无法安装了。怪了

  1. Installing new version of config file /etc/mysql/mysql.conf.d/mysqld_safe_syslog.cnf ...
  2. update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
  3. Renaming removed key_buffer and myisam-recover options (if present)
  4. dpkg: error processing package mysql-server-5.7 (--configure):
  5. subprocess installed post-installation script returned error exit status 1
  6. dpkg: dependency problems prevent configuration of mysql-server:
  7. mysql-server depends on mysql-server-5.7; however:
  8.   Package mysql-server-5.7 is not configured yet.

  9. dpkg: error processing package mysql-server (--configure):
  10. dependency problems - leaving unconfigured
  11. Processing triggers for libc-bin (2.24-5) ...
  12. Errors were encountered while processing:
  13. virtualbox-ext-pack
  14. mysql-server-5.7
  15. mysql-server
  16. E: Sub-process /usr/bin/dpkg returned an error code (1)
Copy the Code
Reply View the author
avatar
8***8@qq.com
deepin
2017-03-04 03:19
#3
cd /var/lib/dpkg
sudo mv info info.bak #即备份一个info
sudo mkdir info #新建一个新的info目录
然后采用以下命令重装那些出错的软件包
sudo apt-get –reinstall install 软件包名
开始我是想在一条命令中同时安装几个软件包,结果还是出现E: Sub-process /usr/bin/dpkg returned an error code (1) 。于是把新的info删掉,一个个地来安装,每装好一个软件包,就把info删掉,再新建一个,这样就没有提示E: Sub-process /usr/bin/dpkg returned an error code (1) 了。
最后用原来的info.bak 替换新的info
sudo -rf info
sudo mv info.bak info
Reply View the author