1

Тема: ошибка при установке mysql

Здравствуйте, подскажите пж как исправить. Гуглил нечего пока найти не могу. Устанавливаю mysql на только что установленный debian 7 сразу ошибка.

root@cubietruck:~# aptitude install mysql-server
The following NEW packages will be installed:
  libaio1{a} libdbd-mysql-perl{a} libdbi-perl{a} libmysqlclient18{a}
  mysql-client-5.5{a} mysql-common{a} mysql-server mysql-server-5.5{a}
  mysql-server-core-5.5{a} psmisc{a}
The following packages are RECOMMENDED but will NOT be installed:
  bsd-mailx heirloom-mailx libhtml-template-perl mailutils
0 packages upgraded, 10 newly installed, 0 to remove and 65 not upgraded.
Need to get 8,127 kB of archives. After unpacking 85.6 MB will be used.
Do you want to continue? [Y/n/?] Y
Get: 1 http://ftp.de.debian.org/debian/ wheezy/main libaio1 armhf 0.3.109-3 [8,8                                                                                                                               

64 B]
Get: 2 http://ftp.de.debian.org/debian/ wheezy/main mysql-common all 5.5.44-0+de                                                                                                                               

b7u1 [73.4 kB]
Get: 3 http://ftp.de.debian.org/debian/ wheezy/main libmysqlclient18 armhf 5.5.4                                                                                                                               

4-0+deb7u1 [626 kB]
Get: 4 http://ftp.de.debian.org/debian/ wheezy/main libdbi-perl armhf 1.622-1+de                                                                                                                               

b7u1 [885 kB]
Get: 5 http://ftp.de.debian.org/debian/ wheezy/main libdbd-mysql-perl armhf 4.02                                                                                                                               

1-1+b1 [120 kB]
Get: 6 http://ftp.de.debian.org/debian/ wheezy/main mysql-client-5.5 armhf 5.5.4                                                                                                                               

4-0+deb7u1 [1,456 kB]
Get: 7 http://ftp.de.debian.org/debian/ wheezy/main psmisc armhf 22.19-1+deb7u1                                                                                                                                

[129 kB]
Get: 8 http://ftp.de.debian.org/debian/ wheezy/main mysql-server-core-5.5 armhf                                                                                                                                

5.5.44-0+deb7u1 [3,137 kB]
Get: 9 http://ftp.de.debian.org/debian/ wheezy/main mysql-server-5.5 armhf 5.5.4                                                                                                                               

4-0+deb7u1 [1,619 kB]
Get: 10 http://ftp.de.debian.org/debian/ wheezy/main mysql-server all 5.5.44-0+d                                                                                                                               

eb7u1 [71.8 kB]
Fetched 8,127 kB in 7s (1,156 kB/s)
Preconfiguring packages ...
Selecting previously unselected package libaio1:armhf.
(Reading database ... 19150 files and directories currently installed.)
Unpacking libaio1:armhf (from .../libaio1_0.3.109-3_armhf.deb) ...
Selecting previously unselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_5.5.44-0+deb7u1_all.deb) ...
Selecting previously unselected package libmysqlclient18:armhf.
Unpacking libmysqlclient18:armhf (from .../libmysqlclient18_5.5.44-0+deb7u1_armh                                                                                                                               

f.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.622-1+deb7u1_armhf.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_armhf.deb) ..                                                                                                                               

.
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.44-0+deb7u1_armhf.deb)                                                                                                                               

 ...
Selecting previously unselected package psmisc.
Unpacking psmisc (from .../psmisc_22.19-1+deb7u1_armhf.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.44-0+deb7u1_                                                                                                                               

armhf.deb) ...
Processing triggers for man-db ...
Processing triggers for menu ...
Setting up mysql-common (5.5.44-0+deb7u1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 19548 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.44-0+deb7u1_armhf.deb)                                                                                                                               

 ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.44-0+deb7u1_all.deb) ...
Processing triggers for man-db ...
Setting up libaio1:armhf (0.3.109-3) ...
Setting up libmysqlclient18:armhf (5.5.44-0+deb7u1) ...
Setting up libdbi-perl (1.622-1+deb7u1) ...
Setting up libdbd-mysql-perl (4.021-1+b1) ...
Setting up mysql-client-5.5 (5.5.44-0+deb7u1) ...
Setting up psmisc (22.19-1+deb7u1) ...
Setting up mysql-server-core-5.5 (5.5.44-0+deb7u1) ...
Setting up mysql-server-5.5 (5.5.44-0+deb7u1) ...
[ ok ] Stopping MySQL database server: mysqld.
150911 18:11:07 [Warning] Using unique option prefix key_buffer instead of key_b                                                                                                                               

uffer_size is deprecated and will be removed in a future release. Please use the                                                                                                                               

 full name instead.
150911 18:11:07 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb7u1) starting as pro                                                                                                                               

cess 13995 ...
150911 18:11:08 [Warning] Using unique option prefix myisam-recover instead of m                                                                                                                               

yisam-recover-options is deprecated and will be removed in a future release. Ple                                                                                                                               

ase use the full name instead.
150911 18:11:08 [Note] Plugin 'FEDERATED' is disabled.
150911 18:11:08 InnoDB: The InnoDB memory heap is disabled
150911 18:11:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150911 18:11:08 InnoDB: Compressed tables use zlib 1.2.7
150911 18:11:08 InnoDB: Using Linux native AIO
150911 18:11:08 InnoDB: Initializing buffer pool, size = 128.0M
150911 18:11:08 InnoDB: Completed initialization of buffer pool
150911 18:11:08 InnoDB: highest supported file format is Barracuda.
150911 18:11:08  InnoDB: Waiting for the background threads to start
150911 18:11:09 InnoDB: 5.5.44 started; log sequence number 1595675
150911 18:11:09  InnoDB: Starting shutdown...
150911 18:11:10  InnoDB: Shutdown completed; log sequence number 1595675
insserv: warning: script 'firstrun' missing LSB tags and overrides
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed                                                                                                                               

!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for menu ...
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up mysql-server-5.5 (5.5.44-0+deb7u1) ...
[ ok ] Stopping MySQL database server: mysqld.
insserv: warning: script 'firstrun' missing LSB tags and overrides
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed                                                                                                                               

!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server

root@cubietruck:~#

2

Re: ошибка при установке mysql

Rubik сказал:

Устанавливаю mysql на только что установленный debian 7 сразу ошибка.

Надо обратиться к пользователям Дебиан. Похоже проблема в скрипте инициализации.

3

Re: ошибка при установке mysql

Проблема решена.

Проверяем ест ли кто то на 3306 порту

netstat -apn | grep 3306

в моем случае пусто

идем /etc/mysql/my.conf

ищем

"bind-address" и комментируем это привязка к ip

http://s020.radikal.ru/i723/1509/4a/065fd5c4a2ad.jpg