我修改了 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
此后它就停留在那里了。
答案1
要删除 mysql-server，请使用：sudo aptitude remove mysql-server
如果您只是想重新安装使用：sudo aptitude reinstall mysql-server
答案2
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
然后再试一次。