Problem z instalacj

antii7 · Post autor: **antii7** » 03 listopada 2015, 12:54

Witam,
chciałem zainstalować bazę mysql i mam z tym problem. Po zainstalowaniu mysql nie chce wystartować.
Przy instalowaniu pojawiają się następujące komunikaty:

Kod: Zaznacz cały

root@debian1:~# apt-get install mysql-server mysql-common mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-server-5.5
Suggested packages:
  libterm-readkey-perl tinyca
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client mysql-client-5.5 mysql-common
  mysql-server mysql-server-5.5
0 upgraded, 7 newly installed, 0 to remove and 476 not upgraded.
Need to get 4,567 kB/4,650 kB of archives.
After this operation, 74.4 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 [URL]http://security.debian.org/[/URL] wheezy/updates/main mysql-common all 5.5.46-0+deb7u1 [84.8 kB]
Get:2 [URL]http://security.debian.org/[/URL] wheezy/updates/main libmysqlclient18 amd64 5.5.46-0+deb7u1 [691 kB]
Get:3 [URL]http://security.debian.org/[/URL] wheezy/updates/main mysql-client-5.5 amd64 5.5.46-0+deb7u1 [1,739 kB]
Get:4 [URL]http://security.debian.org/[/URL] wheezy/updates/main mysql-server-5.5 amd64 5.5.46-0+deb7u1 [1,843 kB]
Get:5 [URL]http://security.debian.org/[/URL] wheezy/updates/main mysql-client all 5.5.46-0+deb7u1 [82.9 kB]
Get:6 [URL]http://ftp.pl.debian.org/debian/[/URL] wheezy/main libdbd-mysql-perl amd64 4.021-1+b1 [126 kB]
Fetched 4,567 kB in 5s (882 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 148896 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.46-0+deb7u1_all.deb) ...
Selecting previously unselected package libmysqlclient18:amd64.
Unpacking libmysqlclient18:amd64 (from .../libmysqlclient18_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.46-0+deb7u1_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.46-0+deb7u1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 148992 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.5.46-0+deb7u1_all.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.46-0+deb7u1_all.deb) ...
Processing triggers for man-db ...
Setting up libmysqlclient18:amd64 (5.5.46-0+deb7u1) ...
Setting up libdbd-mysql-perl (4.021-1+b1) ...
Setting up mysql-client-5.5 (5.5.46-0+deb7u1) ...
Setting up mysql-server-5.5 (5.5.46-0+deb7u1) ...
[ ok ] Stopping MySQL database server: mysqld.
151103 12:49:41 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
151103 12:49:41 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 11556 ...
151103 12:49:41 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151103 12:49:41 [Note] Plugin 'FEDERATED' is disabled.
151103 12:49:41 InnoDB: The InnoDB memory heap is disabled
151103 12:49:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151103 12:49:41 InnoDB: Compressed tables use zlib 1.2.7
151103 12:49:41 InnoDB: Using Linux native AIO
151103 12:49:41 InnoDB: Initializing buffer pool, size = 128.0M
151103 12:49:41 InnoDB: Completed initialization of buffer pool
151103 12:49:41 InnoDB: highest supported file format is Barracuda.
151103 12:49:41  InnoDB: Waiting for the background threads to start
151103 12:49:42 InnoDB: 5.5.46 started; log sequence number 1595675
151103 12:49:42  InnoDB: Starting shutdown...
151103 12:49:43  InnoDB: Shutdown completed; log sequence number 1595675
[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
Setting up mysql-client (5.5.46-0+deb7u1) ...
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
E: Sub-process /usr/bin/dpkg returned an error code (1)

Nie umiem sobie z tym poradzić, proszę o pomoc.
Pozdrawiam

Post autor: **marcin1982** » 03 listopada 2015, 16:37

Używaj tagów CODE.

and 476 not upgraded.

Masz niezaktualizowany system. Najpierw aktualizacja:

Kod: Zaznacz cały

apt-get update && apt-get dist-upgrade

antii7 · Post autor: **antii7** » 04 listopada 2015, 08:51

Zaktualizowałem system, usunąłem całkowicie mysql i zainstalowałem ponownie.
Dalej jest problem z wystartowaniem mysql.

Kod: Zaznacz cały

root@debian1:~# apt-get install libmysqlclient-dev mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  xulrunner-10.0
Use 'apt-get autoremove' to remove it.
The following extra packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common
Suggested packages:
  libterm-readkey-perl
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient-dev libmysqlclient18 mysql-client mysql-client-5.5 mysql-common
0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Need to get 3,679 kB of archives.
After this operation, 47.2 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://ftp.pl.debian.org/debian/ wheezy/main libdbd-mysql-perl amd64 4.021-1+b1 [126 kB]
Get:2 http://security.debian.org/ wheezy/updates/main mysql-common all 5.5.46-0+deb7u1 [84.8 kB]
Get:3 http://security.debian.org/ wheezy/updates/main libmysqlclient18 amd64 5.5.46-0+deb7u1 [691 kB]
Get:4 http://security.debian.org/ wheezy/updates/main libmysqlclient-dev amd64 5.5.46-0+deb7u1 [956 kB]
Get:5 http://security.debian.org/ wheezy/updates/main mysql-client-5.5 amd64 5.5.46-0+deb7u1 [1,739 kB]
Get:6 http://security.debian.org/ wheezy/updates/main mysql-client all 5.5.46-0+deb7u1 [82.9 kB]
Fetched 3,679 kB in 7s (491 kB/s)
Selecting previously unselected package mysql-common.
(Reading database ... 148748 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.46-0+deb7u1_all.deb) ...
Selecting previously unselected package libmysqlclient18:amd64.
Unpacking libmysqlclient18:amd64 (from .../libmysqlclient18_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
Selecting previously unselected package libmysqlclient-dev.
Unpacking libmysqlclient-dev (from .../libmysqlclient-dev_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.5.46-0+deb7u1_all.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.46-0+deb7u1) ...
Setting up libmysqlclient18:amd64 (5.5.46-0+deb7u1) ...
Setting up libdbd-mysql-perl (4.021-1+b1) ...
Setting up libmysqlclient-dev (5.5.46-0+deb7u1) ...
Setting up mysql-client-5.5 (5.5.46-0+deb7u1) ...
Setting up mysql-client (5.5.46-0+deb7u1) ...
root@debian1:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  xulrunner-10.0
Use 'apt-get autoremove' to remove it.
The following extra packages will be installed:
  mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 5,371 kB of archives.
After this operation, 52.9 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://security.debian.org/ wheezy/updates/main mysql-server-core-5.5 amd64 5.5.46-0+deb7u1 [3,445 kB]
Get:2 http://security.debian.org/ wheezy/updates/main mysql-server-5.5 amd64 5.5.46-0+deb7u1 [1,843 kB]
Get:3 http://security.debian.org/ wheezy/updates/main mysql-server all 5.5.46-0+deb7u1 [83.0 kB]
Fetched 5,371 kB in 4s (1,135 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-server-core-5.5.
(Reading database ... 148922 files and directories currently installed.)
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package mysql-server-5.5.
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.46-0+deb7u1_amd64.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.46-0+deb7u1_all.deb) ...
Processing triggers for man-db ...
Setting up mysql-server-core-5.5 (5.5.46-0+deb7u1) ...
Setting up mysql-server-5.5 (5.5.46-0+deb7u1) ...
[ ok ] Stopping MySQL database server: mysqld.
151104  8:42:01 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
151104  8:42:01 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 23232 ...
151104  8:42:01 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151104  8:42:01 [Note] Plugin 'FEDERATED' is disabled.
151104  8:42:01 InnoDB: The InnoDB memory heap is disabled
151104  8:42:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151104  8:42:01 InnoDB: Compressed tables use zlib 1.2.7
151104  8:42:01 InnoDB: Using Linux native AIO
151104  8:42:01 InnoDB: Initializing buffer pool, size = 128.0M
151104  8:42:01 InnoDB: Completed initialization of buffer pool
151104  8:42:01 InnoDB: highest supported file format is Barracuda.
151104  8:42:01  InnoDB: Waiting for the background threads to start
151104  8:42:02 InnoDB: 5.5.46 started; log sequence number 1595675
151104  8:42:02  InnoDB: Starting shutdown...
151104  8:42:03  InnoDB: Shutdown completed; log sequence number 1595675
[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
E: Sub-process /usr/bin/dpkg returned an error code (1)

giaur · Post autor: **giaur** » 04 listopada 2015, 09:23

Używasz systemd czy starego init? Swego czasu był problem, że bez systemd mysql nie startował, bo był błąd w skrypcie startowym. A i dobrze by było zajrzeć do logów mysql zobaczyć czy jest jakieś info czemu nie startuje.

antii7 · Post autor: **antii7** » 04 listopada 2015, 12:59

Mam debiana 7.0 więc pewnie używam starego init.
Sprawdziłem logi, logi mysql są czyste, są jedynie wpisy w logach systemowych, przedstawiam je poniżej:

Kod: Zaznacz cały

Nov  4 12:33:39 debian1 mysqld_safe[32444]: 151104 12:33:39 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:39 debian1 mysqld_safe[32444]: 151104 12:33:39 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32464 ...
Nov  4 12:33:40 debian1 mysqld_safe[32444]: 151104 12:33:40 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:40 debian1 mysqld_safe[32444]: 151104 12:33:40 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32477 ...
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov  4 12:33:40 debian1 mysqld_safe[32444]: To do so, start the server, then issue the following commands:
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: /usr/bin/mysqladmin -u root password 'new-password'
Nov  4 12:33:40 debian1 mysqld_safe[32444]: /usr/bin/mysqladmin -u root -h debian1 password 'new-password'
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: Alternatively you can run:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: /usr/bin/mysql_secure_installation
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: which will also give you the option of removing the test
Nov  4 12:33:40 debian1 mysqld_safe[32444]: databases and anonymous user created by default.  This is
Nov  4 12:33:40 debian1 mysqld_safe[32444]: strongly recommended for production servers.
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: See the manual for more instructions.
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32444]: Please report any problems at http://bugs.mysql.com/
Nov  4 12:33:40 debian1 mysqld_safe[32444]:
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32494 ...
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 [Note] Plugin 'FEDERATED' is disabled.
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: The InnoDB memory heap is disabled
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: Compressed tables use zlib 1.2.7
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: Using Linux native AIO
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: Initializing buffer pool, size = 128.0M
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: Completed initialization of buffer pool
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40 InnoDB: highest supported file format is Barracuda.
Nov  4 12:33:40 debian1 mysqld_safe[32495]: 151104 12:33:40  InnoDB: Waiting for the background threads to start
Nov  4 12:33:41 debian1 mysqld_safe[32495]: 151104 12:33:41 InnoDB: 5.5.46 started; log sequence number 1595675
Nov  4 12:33:41 debian1 mysqld_safe[32495]: 151104 12:33:41  InnoDB: Starting shutdown...
Nov  4 12:33:42 debian1 mysqld_safe[32495]: 151104 12:33:42  InnoDB: Shutdown completed; log sequence number 1595675
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32531 ...
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 [Note] Plugin 'FEDERATED' is disabled.
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: The InnoDB memory heap is disabled
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: Compressed tables use zlib 1.2.7
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: Using Linux native AIO
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: Initializing buffer pool, size = 128.0M
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: Completed initialization of buffer pool
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42 InnoDB: highest supported file format is Barracuda.
Nov  4 12:33:42 debian1 mysqld_safe[32532]: 151104 12:33:42  InnoDB: Waiting for the background threads to start
Nov  4 12:33:43 debian1 mysqld_safe[32532]: 151104 12:33:43 InnoDB: 5.5.46 started; log sequence number 1595675
Nov  4 12:33:43 debian1 mysqld_safe[32532]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov  4 12:33:43 debian1 mysqld_safe[32532]: 151104 12:33:43 [ERROR] Aborting
Nov  4 12:33:43 debian1 mysqld_safe[32532]:
Nov  4 12:33:43 debian1 mysqld_safe[32532]: 151104 12:33:43  InnoDB: Starting shutdown...
Nov  4 12:33:44 debian1 mysqld_safe[32532]: 151104 12:33:44  InnoDB: Shutdown completed; log sequence number 1595675
Nov  4 12:33:44 debian1 mysqld_safe[32532]: 151104 12:33:44 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  4 12:33:44 debian1 mysqld_safe[32532]:
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32564 ...
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 [Note] Plugin 'FEDERATED' is disabled.
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: The InnoDB memory heap is disabled
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: Compressed tables use zlib 1.2.7
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: Using Linux native AIO
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: Initializing buffer pool, size = 128.0M
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: Completed initialization of buffer pool
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44 InnoDB: highest supported file format is Barracuda.
Nov  4 12:33:44 debian1 mysqld_safe[32565]: 151104 12:33:44  InnoDB: Waiting for the background threads to start
Nov  4 12:33:45 debian1 mysqld_safe[32565]: 151104 12:33:45 InnoDB: 5.5.46 started; log sequence number 1595675
Nov  4 12:33:45 debian1 mysqld_safe[32565]: 151104 12:33:45  InnoDB: Starting shutdown...
Nov  4 12:33:46 debian1 mysqld_safe[32565]: 151104 12:33:46  InnoDB: Shutdown completed; log sequence number 1595675
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 32597 ...
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 [Note] Plugin 'FEDERATED' is disabled.
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: The InnoDB memory heap is disabled
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: Compressed tables use zlib 1.2.7
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: Using Linux native AIO
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: Initializing buffer pool, size = 128.0M
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: Completed initialization of buffer pool
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46 InnoDB: highest supported file format is Barracuda.
Nov  4 12:33:46 debian1 mysqld_safe[32598]: 151104 12:33:46  InnoDB: Waiting for the background threads to start
Nov  4 12:33:47 debian1 mysqld_safe[32598]: 151104 12:33:47 InnoDB: 5.5.46 started; log sequence number 1595675
Nov  4 12:33:47 debian1 mysqld_safe[32598]: ERROR: 1050  Table 'plugin' already exists
Nov  4 12:33:47 debian1 mysqld_safe[32598]: 151104 12:33:47 [ERROR] Aborting
Nov  4 12:33:47 debian1 mysqld_safe[32598]:
Nov  4 12:33:47 debian1 mysqld_safe[32598]: 151104 12:33:47  InnoDB: Starting shutdown...
Nov  4 12:33:48 debian1 mysqld_safe[32598]: 151104 12:33:48  InnoDB: Shutdown completed; log sequence number 1595675
Nov  4 12:33:48 debian1 mysqld_safe[32598]: 151104 12:33:48 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  4 12:33:48 debian1 mysqld_safe[32598]:
Nov  4 12:33:49 debian1 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 549 ...
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 [Note] Plugin 'FEDERATED' is disabled.
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: The InnoDB memory heap is disabled
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: Compressed tables use zlib 1.2.7
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: Using Linux native AIO
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: Initializing buffer pool, size = 128.0M
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: Completed initialization of buffer pool
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49 InnoDB: highest supported file format is Barracuda.
Nov  4 12:33:49 debian1 mysqld: 151104 12:33:49  InnoDB: Waiting for the background threads to start
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 InnoDB: 5.5.46 started; log sequence number 1595675
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [Note] Server socket created on IP: '127.0.0.1'.
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50 [ERROR] Aborting
Nov  4 12:33:50 debian1 mysqld:
Nov  4 12:33:50 debian1 mysqld: 151104 12:33:50  InnoDB: Starting shutdown...
Nov  4 12:33:51 debian1 mysqld: 151104 12:33:51  InnoDB: Shutdown completed; log sequence number 1595675
Nov  4 12:33:51 debian1 mysqld: 151104 12:33:51 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  4 12:33:51 debian1 mysqld:
Nov  4 12:33:51 debian1 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  4 12:34:03 debian1 /etc/init.d/mysql[826]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  4 12:34:03 debian1 /etc/init.d/mysql[826]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  4 12:34:03 debian1 /etc/init.d/mysql[826]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  4 12:34:03 debian1 /etc/init.d/mysql[826]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  4 12:34:03 debian1 /etc/init.d/mysql[826]:
root@debian1:~#

Dodane:

Gdy chce uruchomic deamona mysql to w syslogu są takie komunikaty:

Kod: Zaznacz cały

Nov  4 13:35:10 debian1 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [Warning] Ignoring user change to 'mysql' because the user was set to 'mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306' earlier on the command line
Nov  4 13:35:10 debian1 mysqld:
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1) starting as process 25881 ...
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [ERROR] Fatal error: Can't change to run as user 'mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306' ;  Please check that the user exists!
Nov  4 13:35:10 debian1 mysqld:
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [ERROR] Aborting
Nov  4 13:35:10 debian1 mysqld:
Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  4 13:35:10 debian1 mysqld:
Nov  4 13:35:10 debian1 mysqld_safe: mysqld from pid file /var/lib/mysql/debian1.pid ended
Nov  4 13:35:23 debian1 /etc/init.d/mysql[26137]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  4 13:35:23 debian1 /etc/init.d/mysql[26137]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  4 13:35:23 debian1 /etc/init.d/mysql[26137]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  4 13:35:23 debian1 /etc/init.d/mysql[26137]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  4 13:35:23 debian1 /etc/init.d/mysql[26137]:
root@debian1:~#

Sprawdziłem i nie ma pliku /var/run/mysqld/mysqld.sock

mariaczi · Post autor: **mariaczi** » 04 listopada 2015, 14:00

antii7 pisze:

Kod: Zaznacz cały

Nov  4 13:35:10 debian1 mysqld: 151104 13:35:10 [ERROR] Fatal error: Can't change to run as user 'mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306' ;  Please check that the user exists!

Sprawdziłem i nie ma pliku /var/run/mysqld/mysqld.sock

Pliku od socketu nie ma bo serwis nie wstał. Sprawdziłeś to co podpowiada log? Uprawnienia do katalogów gdzie mysql zagląda?

[Edycja: Policyjny numer postu

]

Post autor: **pawkrol** » 04 listopada 2015, 14:02

Usera masz?

Kod: Zaznacz cały

# getent passwd
.
.
mysql:x:108:113:MySQL Server,,,:/nonexistent:/bin/false
.
.

Kod: Zaznacz cały

# getent group
.
.
.mysql:x:113:
.
.

antii7 · Post autor: **antii7** » 04 listopada 2015, 14:27

Polecenie getent passwd pokazało mi:

Kod: Zaznacz cały

mysql:x:118:124:MySQL Server,,,:/nonexistent:/bin/false

getent group:

Kod: Zaznacz cały

mysql:x:124:

giaur · Post autor: **giaur** » 04 listopada 2015, 14:39

Pokaż co jest w pliku /var/log/mysql/error.log

antii7 · Post autor: **antii7** » 04 listopada 2015, 14:53

Nie ma takiego pliku, katalog jest pusty

Problem z instalacj

Problem z instalacją mysql