我在安装mysql apt-get install mysql-server (就像我总是这样做)之前,我已经做了apt-get update (我正在使用Debian 6),当我安装时,我发现这个问题, ,但我已经按照所有步骤,没有任何工作。
我已经尝试了apt-get install -f apt-get remove mysql-server (以及common和mysql-server-5.1 )以及apt-get purge (每个软件包),然后install ,但是没有任何东西。 。
我也试过了
dpkg-reconfigure mysql-server-5.1 apt-get install --reinstall mysql-server (all runed as Root)
仍然没有任何工作,任何想法?
130130 10:11:48 InnoDB: Shutdown completed; log sequence number 0 44233 Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.1 (--configure): subprocess installed post-installation script returned error exit status 1 configured to not write apport reports dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.1; however: Package mysql-server-5.1 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured configured to not write apport reports Errors were encountered while processing: mysql-server-5.1 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)
当我尝试
dpkg-reconfigure mysql-server-5.1 /usr/sbin/dpkg-reconfigure: mysql-server-5.1 is broken or not fully installed
/etc/init.d/mysql的情况是“开始”
'start') sanity_checks; # Start daemon log_daemon_msg "Starting MySQL database server" "mysqld" if mysqld_status check_alive nowarn; then log_progress_msg "already running" log_end_msg 0 else # Could be removed during boot test -e /var/run/mysqld || install -m 755 -o mysql -g root -d /var/run/mysqld # Start MySQL! /usr/bin/mysqld_safe > /dev/null 2>&1 & # 6s was reported in #352070 to be too few when using ndbcluster for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do sleep 1 if mysqld_status check_alive nowarn ; then break; fi log_progress_msg "." done if mysqld_status check_alive warn; then log_end_msg 0 # Now start mysqlcheck or whatever the admin wants. output=$(/etc/mysql/debian-start) [ -n "$output" ] && log_action_msg "$output" else log_end_msg 1 log_failure_msg "Please take a look at the syslog" fi fi
当我使MySQL强制重载时:
Reloading MySQL database server: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! root@americandougnuts:/etc/init.d# root@americandougnuts:/etc/init.d# Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
出于某种原因apt-get升级创build一个新的mysql bin文件,它没有正确的所有权。 这个文件位于/ var / lib / mysql。 由于mysql无法访问这个文件,mysql无法启动,升级失败。
检查/ var / lib / mysql文件的文件所有权
ls -ltra / var / lib / mysql
-rw-rw---- 1 mysql root 125 Oct 29 09:53 mysql-bin.000288 -rw-rw---- 1 mysql root 125 Oct 29 09:53 mysql-bin.000289 -rw-rw---- 1 mysql mysql 228 Oct 29 10:07 mysql-bin.index -rw-rw---- 1 root root 125 Oct 29 10:07 mysql-bin.000291 -rw-rw---- 1 root root 125 Oct 29 10:07 mysql-bin.000290
肮脏的解决方法:
而真实的; 做chown mysql:mysql / var / lib / mysql / *; DONE
在原来的terminal
当升级成功完成CRT + C在第二个terminal的while循环。
它说,为什么它不能在你分享的输出中工作:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
MySQL拒绝启动,检查/var/log MySQL日志文件以找出原因,修复它并再次运行dpkg-reconfigure 。
在一个shell中以root身份运行“mysqld”来启动mysql。 然后它应该打印到屏幕上为什么无法启动。 通常它是/etc/mysql/my.cnf中的一个过时的configuration选项。
在更正保存mysql的错误之后,重新运行dpkg-reconfigure mysql-server-5.1