Eu estou desinstalando, instalando o Mysql do jeito certo?

Question

Eu mudei meu.cnv e ninguém pode se conectar ao mysql novamente. Então eu decidi reinstalar o mysql.

eu fiz

sudo aptitude purge mysql-server

seguido por

sudo aptitude install mysql-server

então eu peguei este log:

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?

Então, quando eu faço

sudo aptitude install mysql-server

Estou preso em uma linha. Parece que eu preciso desinstalar completamente o mysql antes de continuar. Como.

Então eu finalmente faço

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

E depois disso, fica preso lá.

    

Answer 1

Para remover o uso do servidor mysql: sudo aptitude remove mysql-server

se você quiser apenas reinstalar o uso: sudo aptitude reinstall mysql-server

    

Answer 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

Para saber o que Error 13 significa:

# perror 13
OS error code  13:  Permission denied

Então, parece que o arquivo acima não é de propriedade de mysql user:

# chown -R mysql:mysql /path/to/data/dir

e tente novamente.