我更改my.cnv，没有人可以再次连接到MySQL。 所以我决定重新安装MySQL。
我做了
sudo aptitude purge mysql-server 其次是
sudo aptitude install mysql-server
然后我得到这个日志：
root@ip-10-134-10-182:~# sudo aptitude purge mysql-server E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it? Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
那么当我这样做
sudo aptitude install mysql-server
我被困在一行。 看起来像我需要完全卸载MySQL之前继续。 怎么样。
然后我终于做到了
root@ip-10-134-10-182:~# sudo aptitude install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done The following NEW packages will be installed: libhtml-template-perl{a} mysql-server mysql-server-5.1{a} mysql-server-core-5.1{a} 0 packages upgraded, 4 newly installed, 0 to remove and 38 not upgraded. Need to get 0B/12.2MB of archives. After unpacking 29.7MB will be used. Do you want to continue? [Y/n/?] Y Writing extended state information... Done Preconfiguring packages ... Selecting previously deselected package mysql-server-core-5.1. (Reading database ... 27052 files and directories currently installed.) Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.63-0ubuntu0.10.04.1_amd64.deb) ... Selecting previously deselected package mysql-server-5.1. Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.63-0ubuntu0.10.04.1_amd64.deb) ... Selecting previously deselected package libhtml-template-perl. Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.1.63-0ubuntu0.10.04.1_all.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up mysql-server-core-5.1 (5.1.63-0ubuntu0.10.04.1) ... Setting up mysql-server-5.1 (5.1.63-0ubuntu0.10.04.1) ... 120807 6:58:36 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 120807 6:58:36 [Note] Plugin 'FEDERATED' is disabled. 120807 6:58:36 InnoDB: Initializing buffer pool, size = 8.0M 120807 6:58:36 InnoDB: Completed initialization of buffer pool 120807 6:58:36 InnoDB: Started; log sequence number 2 4115700857 /usr/sbin/mysqld: File './mysql-bin.000005' not found (Errcode: 13) 120807 6:58:36 [ERROR] Failed to open log (file './mysql-bin.000005', errno 13) 120807 6:58:36 [ERROR] Could not open log file 120807 6:58:36 [ERROR] Can't init tc log 120807 6:58:36 [ERROR] Aborting 120807 6:58:36 InnoDB: Starting shutdown... 120807 6:58:42 InnoDB: Shutdown completed; log sequence number 2 4115700857 120807 6:58:42 [Note] /usr/sbin/mysqld: Shutdown complete
之后它就停留在那里
删除mysql-server使用： sudo aptitude remove mysql-server
如果你只是想重新安装使用： sudo aptitude reinstall mysql-server
120807 6:58:36 InnoDB: Started; log sequence number 2 4115700857 /usr/sbin/mysqld: File './mysql-bin.000005' not found (Errcode: 13) 120807 6:58:36 [ERROR] Failed to open log (file './mysql-bin.000005', errno 13) 120807 6:58:36 [ERROR] Could not open log file
要知道Error 13是什么意思：
# perror 13 OS error code 13: Permission denied
所以，这听起来像上面的文件不属于mysql用户：
# chown -R mysql:mysql /path/to/data/dir
然后再试一次。