MySQL Job无法启动 [英] MySQL Job failed to start

问题描述

我在Kubuntu 12.04上，并且通过apt-get(mysql ver:5.5.35)安装mysql之后，我正在尝试启动mysql服务，但出现此错误:

I'm on Kubuntu 12.04, and after installing mysql via an apt-get (mysql ver: 5.5.35), i'm trying to start mysql service, but I got this error:

sudo服务mysql启动

sudo service mysql start

开始:作业无法开始

所以我用谷歌搜索了这个问题，它说我必须去/var/log/mysql/error.log

So I googled this problem, it says i have to go to the /var/log/mysql/error.log

但是我的error.log文件为空:(

But my error.log file is empty :(

然后我检查了权限 :

drwxr-s --- 2个mysql adm 4096 Apr 7 11:21 mysql

drwxr-s--- 2 mysql adm 4096 Apr 7 11:21 mysql

-rw-r ----- 1 mysql adm 0 Apr 7 11:21 error.log

-rw-r----- 1 mysql adm 0 Apr 7 11:21 error.log

所以我不知道该怎么办...为什么出现此错误?为什么错误文件为空?

So I don't know what to do... Why this error ? Why is the error file empty ?

推荐答案

为安全起见，首先备份/var/lib/mysql/目录.

First make a backup of your /var/lib/mysql/ directory just to be safe.

sudo mkdir /home/<your username>/mysql/
cd /var/lib/mysql/
sudo cp * /home/<your username>/mysql/ -R

下一步清除MySQL(这将删除php5-mysql和phpmyadmin以及许多其他库，因此准备在此之后重新安装一些项目.

Next purge MySQL (this will remove php5-mysql and phpmyadmin as well as a number of other libraries so be prepared to re-install some items after this.

sudo apt-get purge mysql-server-5.1 mysql-common

删除文件夹/etc/mysql/及其内容

Remove the folder /etc/mysql/ and it's contents

sudo rm /etc/mysql/ -R

接下来检查您的旧数据库文件是否仍在/var/lib/mysql/中，如果不存在，则将它们复制回文件夹中，然后重新命名为root:root

Next check that your old database files are still in /var/lib/mysql/ if they are not then copy them back in to the folder then chown root:root

(仅当文件不再存在时才运行这些文件)

(only run these if the files are no longer there)

sudo mkdir /var/lib/mysql/
sudo chown root:root /var/lib/mysql/ -R
cd ~/mysql/
sudo cp * /var/lib/mysql/ -R

下一步安装mysql服务器

Next install mysql server

sudo apt-get install mysql-server

最后重新安装所有缺少的软件包，例如phpmyadmin和php5-mysql.

Finally re-install any missing packages like phpmyadmin and php5-mysql.

这篇关于MySQL Job无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！