На свежеустановленную виртуальную машину в квм хозяин убунту установил дебиан 7.6
На дебиане настроил сетевое, устанавливаю mysql-client mysql-server
Сервер мне выводит ошибку при установке и при попытке войти в БД не входит. Удаление mysql и переустановка не помгла. В чем можеть быть дело?
Сама ошибка при установке (первая):
sudo aptitude install mysql-client mysql-server
Следующие НОВЫЕ пакеты будут установлены:
libaio1{a} libdbd-mysql-perl{a} libdbi-perl{a} libhtml-template-perl{a}
libmysqlclient18{a} mysql-client mysql-client-5.5{a} mysql-common{a}
mysql-server mysql-server-5.5{a} mysql-server-core-5.5{a}
0 пакетов обновлено, 11 установлено новых, 0 пакетов отмечено для удаления, и 0 пакетов не обновлено.
Необходимо получить 0 B/9 772 kB архивов. После распаковки 97,1 MB будет занято.
Хотите продолжить? [Y/n/?] Y
Предварительная настройка пакетов ...
Выбор ранее не выбранного пакета libaio1:amd64.
(Чтение базы данных … на данный момент установлено 26830 файлов и каталогов.)
Распаковывается пакет libaio1:amd64 (из файла …/libaio1_0.3.109-3_amd64.deb) …
Выбор ранее не выбранного пакета mysql-common.
Распаковывается пакет mysql-common (из файла …/mysql-common_5.5.38-0+wheezy1_all .deb) …
Выбор ранее не выбранного пакета libmysqlclient18:amd64.
Распаковывается пакет libmysqlclient18:amd64 (из файла …/libmysqlclient18_5.5.38 -0+wheezy1_amd64.deb) …
Выбор ранее не выбранного пакета libdbi-perl.
Распаковывается пакет libdbi-perl (из файла …/libdbi-perl_1.622-1+deb7u1_amd64.d eb) …
Выбор ранее не выбранного пакета libdbd-mysql-perl.
Распаковывается пакет libdbd-mysql-perl (из файла …/libdbd-mysql-perl_4.021-1+b1 _amd64.deb) …
Выбор ранее не выбранного пакета mysql-client-5.5.
Распаковывается пакет mysql-client-5.5 (из файла …/mysql-client-5.5_5.5.38-0+whe ezy1_amd64.deb) …
Выбор ранее не выбранного пакета mysql-server-core-5.5.
Распаковывается пакет mysql-server-core-5.5 (из файла …/mysql-server-core-5.5_5. 5.38-0+wheezy1_amd64.deb) …
Обрабатываются триггеры для man-db …
Настраивается пакет mysql-common (5.5.38-0+wheezy1) …
Выбор ранее не выбранного пакета mysql-server-5.5.
(Чтение базы данных … на данный момент установлено 27176 файлов и каталогов.)
Распаковывается пакет mysql-server-5.5 (из файла …/mysql-server-5.5_5.5.38-0+whe ezy1_amd64.deb) …
Выбор ранее не выбранного пакета libhtml-template-perl.
Распаковывается пакет libhtml-template-perl (из файла …/libhtml-template-perl_2. 91-1_all.deb) …
Выбор ранее не выбранного пакета mysql-client.
Распаковывается пакет mysql-client (из файла …/mysql-client_5.5.38-0+wheezy1_all .deb) …
Выбор ранее не выбранного пакета mysql-server.
Распаковывается пакет mysql-server (из файла …/mysql-server_5.5.38-0+wheezy1_all .deb) …
Обрабатываются триггеры для man-db …
Настраивается пакет libaio1:amd64 (0.3.109-3) …
Настраивается пакет libmysqlclient18:amd64 (5.5.38-0+wheezy1) …
Настраивается пакет libdbi-perl (1.622-1+deb7u1) …
Настраивается пакет libdbd-mysql-perl (4.021-1+b1) …
Настраивается пакет mysql-client-5.5 (5.5.38-0+wheezy1) …
Настраивается пакет mysql-server-core-5.5 (5.5.38-0+wheezy1) …
Настраивается пакет mysql-server-5.5 (5.5.38-0+wheezy1) …
[ ok ] Stopping MySQL database server: mysqld.
140812 15:46:05 [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.
140812 15:46:05 [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.
140812 15:46:05 [Note] Plugin 'FEDERATED' is disabled.
140812 15:46:05 InnoDB: The InnoDB memory heap is disabled
140812 15:46:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140812 15:46:05 InnoDB: Compressed tables use zlib 1.2.7
140812 15:46:05 InnoDB: Using Linux native AIO
140812 15:46:05 InnoDB: Initializing buffer pool, size = 128.0M
140812 15:46:05 InnoDB: Completed initialization of buffer pool
140812 15:46:05 InnoDB: highest supported file format is Barracuda.
140812 15:46:06 InnoDB: Waiting for the background threads to start
140812 15:46:07 InnoDB: 5.5.38 started; log sequence number 1595675
140812 15:46:07 InnoDB: Starting shutdown...
140812 15:46:07 InnoDB: Shutdown completed; log sequence number 1595675
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed !
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: ошибка при обработке параметра mysql-server-5.5 (--configure):
подпроцесс установлен сценарий post-installation возвратил код ошибки 1
Настраивается пакет libhtml-template-perl (2.91-1) …
Настраивается пакет mysql-client (5.5.38-0+wheezy1) …
dpkg: зависимости пакетов не позволяют настроить пакет mysql-server:
mysql-server зависит от mysql-server-5.5, однако:
Пакет mysql-server-5.5 пока не настроен.
dpkg: ошибка при обработке параметра mysql-server (--configure):
проблемы зависимостей — оставляем не настроенным
При обработке следующих пакетов произошли ошибки:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Не удалось установить пакет. Попытка восстановить:
Настраивается пакет mysql-server-5.5 (5.5.38-0+wheezy1) …
[ ok ] Stopping MySQL database server: mysqld.
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed !
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: ошибка при обработке параметра mysql-server-5.5 (--configure):
подпроцесс установлен сценарий post-installation возвратил код ошибки 1
dpkg: зависимости пакетов не позволяют настроить пакет mysql-server:
mysql-server зависит от mysql-server-5.5, однако:
Пакет mysql-server-5.5 пока не настроен.
dpkg: ошибка при обработке параметра mysql-server (--configure):
проблемы зависимостей — оставляем не настроенным
При обработке следующих пакетов произошли ошибки:
mysql-server-5.5
mysql-server
user@deb-web:~$ mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run /mysqld/mysqld.sock' (2)
dpkg -a -D3
dpkg: ошибка: укажите требуемое действие
а вот dpkg -A -D3 зы в мане просто верхний регистр
предлагает указать имя файла для операции --record-avail
сейчас я пыаюсь понять что это за операция и что за файл надо написать
dpkg --configure -a -D3
Настраивается пакет mysql-server-5.5 (5.5.38-0+wheezy1) …
D000002: fork/exec /var/lib/dpkg/info/mysql-server-5.5.postinst ( configure )
[ ok ] Stopping MySQL database server: mysqld.
140813 9:07:20 [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.
140813 9:07:20 [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.
140813 9:07:20 [Note] Plugin 'FEDERATED' is disabled.
140813 9:07:20 InnoDB: The InnoDB memory heap is disabled
140813 9:07:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140813 9:07:20 InnoDB: Compressed tables use zlib 1.2.7
140813 9:07:20 InnoDB: Using Linux native AIO
140813 9:07:20 InnoDB: Initializing buffer pool, size = 128.0M
140813 9:07:20 InnoDB: Completed initialization of buffer pool
140813 9:07:20 InnoDB: highest supported file format is Barracuda.
140813 9:07:20 InnoDB: Waiting for the background threads to start
140813 9:07:21 InnoDB: 5.5.38 started; log sequence number 1595675
140813 9:07:21 InnoDB: Starting shutdown...
140813 9:07:22 InnoDB: Shutdown completed; log sequence number 1595675
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: ошибка при обработке параметра mysql-server-5.5 (--configure):
подпроцесс установлен сценарий post-installation возвратил код ошибки 1
dpkg: зависимости пакетов не позволяют настроить пакет mysql-server:
mysql-server зависит от mysql-server-5.5, однако:
Пакет mysql-server-5.5 пока не настроен.
dpkg: ошибка при обработке параметра mysql-server (--configure):
проблемы зависимостей — оставляем не настроенным
При обработке следующих пакетов произошли ошибки:
mysql-server-5.5
mysql-server
Запускал из под рута, в процессе система попросила установить пароль на бд пароль
Aug 13 08:22:26 deb-web mysqld_safe[13217]: 140813 8:22:26 [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.
Aug 13 08:22:27 deb-web mysqld_safe[13217]: 140813 8:22:27 [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.
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Aug 13 08:22:27 deb-web mysqld_safe[13217]: To do so, start the server, then issue the following commands:
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: /usr/bin/mysqladmin -u root password 'new-password'
Aug 13 08:22:27 deb-web mysqld_safe[13217]: /usr/bin/mysqladmin -u root -h deb-web password 'new-password'
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: Alternatively you can run:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: /usr/bin/mysql_secure_installation
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: which will also give you the option of removing the test
Aug 13 08:22:27 deb-web mysqld_safe[13217]: databases and anonymous user created by default. This is
Aug 13 08:22:27 deb-web mysqld_safe[13217]: strongly recommended for production servers.
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: See the manual for more instructions.
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13217]: Please report any problems at http://bugs.mysql.com/
Aug 13 08:22:27 deb-web mysqld_safe[13217]:
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 [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.
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 [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.
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Using Linux native AIO
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Completed initialization of buffer pool
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: highest supported file format is Barracuda.
Aug 13 08:22:27 deb-web mysqld_safe[13265]: 140813 8:22:27 InnoDB: Waiting for the background threads to start
Aug 13 08:22:28 deb-web mysqld_safe[13265]: 140813 8:22:28 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:22:28 deb-web mysqld_safe[13265]: 140813 8:22:28 InnoDB: Starting shutdown...
Aug 13 08:22:29 deb-web mysqld_safe[13265]: 140813 8:22:29 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 [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.
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 [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.
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Using Linux native AIO
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Completed initialization of buffer pool
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: highest supported file format is Barracuda.
Aug 13 08:22:31 deb-web mysqld_safe[13321]: 140813 8:22:31 InnoDB: Waiting for the background threads to start
Aug 13 08:22:32 deb-web mysqld_safe[13321]: 140813 8:22:32 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:22:32 deb-web mysqld_safe[13321]: 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
Aug 13 08:22:32 deb-web mysqld_safe[13321]: 140813 8:22:32 [ERROR] Aborting
Aug 13 08:22:32 deb-web mysqld_safe[13321]:
Aug 13 08:22:32 deb-web mysqld_safe[13321]: 140813 8:22:32 InnoDB: Starting shutdown...
Aug 13 08:22:33 deb-web mysqld_safe[13321]: 140813 8:22:33 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:22:33 deb-web mysqld_safe[13321]: 140813 8:22:33 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:22:33 deb-web mysqld_safe[13321]:
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 [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.
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 [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.
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Using Linux native AIO
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Completed initialization of buffer pool
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: highest supported file format is Barracuda.
Aug 13 08:22:33 deb-web mysqld_safe[13348]: 140813 8:22:33 InnoDB: Waiting for the background threads to start
Aug 13 08:22:34 deb-web mysqld_safe[13348]: 140813 8:22:34 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:22:34 deb-web mysqld_safe[13348]: 140813 8:22:34 InnoDB: Starting shutdown...
Aug 13 08:22:35 deb-web mysqld_safe[13348]: 140813 8:22:35 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 [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.
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 [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.
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Using Linux native AIO
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Completed initialization of buffer pool
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: highest supported file format is Barracuda.
Aug 13 08:22:35 deb-web mysqld_safe[13375]: 140813 8:22:35 InnoDB: Waiting for the background threads to start
Aug 13 08:22:36 deb-web mysqld_safe[13375]: 140813 8:22:36 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:22:36 deb-web mysqld_safe[13375]: ERROR: 1050 Table 'plugin' already exists
Aug 13 08:22:36 deb-web mysqld_safe[13375]: 140813 8:22:36 [ERROR] Aborting
Aug 13 08:22:36 deb-web mysqld_safe[13375]:
Aug 13 08:22:36 deb-web mysqld_safe[13375]: 140813 8:22:36 InnoDB: Starting shutdown...
Aug 13 08:22:37 deb-web mysqld_safe[13375]: 140813 8:22:37 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:22:37 deb-web mysqld_safe[13375]: 140813 8:22:37 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:22:37 deb-web mysqld_safe[13375]:
Aug 13 08:22:37 deb-web mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 [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.
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 [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.
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: Using Linux native AIO
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: Completed initialization of buffer pool
Aug 13 08:22:37 deb-web mysqld: 140813 8:22:37 InnoDB: highest supported file format is Barracuda.
Aug 13 08:22:38 deb-web mysqld: 140813 8:22:38 InnoDB: Waiting for the background threads to start
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [Note] - '127.0.0.1' resolves to '127.0.0.1';
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [Note] Server socket created on IP: '127.0.0.1'.
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 [ERROR] Aborting
Aug 13 08:22:39 deb-web mysqld:
Aug 13 08:22:39 deb-web mysqld: 140813 8:22:39 InnoDB: Starting shutdown...
Aug 13 08:22:40 deb-web mysqld: 140813 8:22:40 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:22:40 deb-web mysqld: 140813 8:22:40 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:22:40 deb-web mysqld:
Aug 13 08:22:40 deb-web mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 13 08:22:52 deb-web /etc/init.d/mysql[14023]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 08:22:52 deb-web /etc/init.d/mysql[14023]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 08:22:52 deb-web /etc/init.d/mysql[14023]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 08:22:52 deb-web /etc/init.d/mysql[14023]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 08:22:52 deb-web /etc/init.d/mysql[14023]:
Aug 13 08:29:12 deb-web mysqld_safe[15312]: 140813 8:29:12 [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.
Aug 13 08:29:13 deb-web mysqld_safe[15312]: 140813 8:29:13 [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.
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Aug 13 08:29:13 deb-web mysqld_safe[15312]: To do so, start the server, then issue the following commands:
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: /usr/bin/mysqladmin -u root password 'new-password'
Aug 13 08:29:13 deb-web mysqld_safe[15312]: /usr/bin/mysqladmin -u root -h deb-web password 'new-password'
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: Alternatively you can run:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: /usr/bin/mysql_secure_installation
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: which will also give you the option of removing the test
Aug 13 08:29:13 deb-web mysqld_safe[15312]: databases and anonymous user created by default. This is
Aug 13 08:29:13 deb-web mysqld_safe[15312]: strongly recommended for production servers.
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: See the manual for more instructions.
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15312]: Please report any problems at http://bugs.mysql.com/
Aug 13 08:29:13 deb-web mysqld_safe[15312]:
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 [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.
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 [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.
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Using Linux native AIO
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Completed initialization of buffer pool
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: highest supported file format is Barracuda.
Aug 13 08:29:13 deb-web mysqld_safe[15360]: 140813 8:29:13 InnoDB: Waiting for the background threads to start
Aug 13 08:29:14 deb-web mysqld_safe[15360]: 140813 8:29:14 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:29:14 deb-web mysqld_safe[15360]: 140813 8:29:14 InnoDB: Starting shutdown...
Aug 13 08:29:15 deb-web mysqld_safe[15360]: 140813 8:29:15 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 [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.
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 [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.
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Using Linux native AIO
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Completed initialization of buffer pool
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: highest supported file format is Barracuda.
Aug 13 08:29:15 deb-web mysqld_safe[15391]: 140813 8:29:15 InnoDB: Waiting for the background threads to start
Aug 13 08:29:16 deb-web mysqld_safe[15391]: 140813 8:29:16 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:29:16 deb-web mysqld_safe[15391]: 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
Aug 13 08:29:16 deb-web mysqld_safe[15391]: 140813 8:29:16 [ERROR] Aborting
Aug 13 08:29:16 deb-web mysqld_safe[15391]:
Aug 13 08:29:16 deb-web mysqld_safe[15391]: 140813 8:29:16 InnoDB: Starting shutdown...
Aug 13 08:29:17 deb-web mysqld_safe[15391]: 140813 8:29:17 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:29:17 deb-web mysqld_safe[15391]: 140813 8:29:17 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:29:17 deb-web mysqld_safe[15391]:
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 [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.
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 [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.
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Using Linux native AIO
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Completed initialization of buffer pool
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: highest supported file format is Barracuda.
Aug 13 08:29:17 deb-web mysqld_safe[15418]: 140813 8:29:17 InnoDB: Waiting for the background threads to start
Aug 13 08:29:18 deb-web mysqld_safe[15418]: 140813 8:29:18 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:29:18 deb-web mysqld_safe[15418]: 140813 8:29:18 InnoDB: Starting shutdown...
Aug 13 08:29:19 deb-web mysqld_safe[15418]: 140813 8:29:19 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 [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.
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 [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.
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Using Linux native AIO
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Completed initialization of buffer pool
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: highest supported file format is Barracuda.
Aug 13 08:29:19 deb-web mysqld_safe[15445]: 140813 8:29:19 InnoDB: Waiting for the background threads to start
Aug 13 08:29:20 deb-web mysqld_safe[15445]: 140813 8:29:20 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:29:20 deb-web mysqld_safe[15445]: ERROR: 1050 Table 'plugin' already exists
Aug 13 08:29:20 deb-web mysqld_safe[15445]: 140813 8:29:20 [ERROR] Aborting
Aug 13 08:29:20 deb-web mysqld_safe[15445]:
Aug 13 08:29:20 deb-web mysqld_safe[15445]: 140813 8:29:20 InnoDB: Starting shutdown...
Aug 13 08:29:21 deb-web mysqld_safe[15445]: 140813 8:29:21 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:29:21 deb-web mysqld_safe[15445]: 140813 8:29:21 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:29:21 deb-web mysqld_safe[15445]:
Aug 13 08:29:21 deb-web mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 [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.
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 [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.
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: The InnoDB memory heap is disabled
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Using Linux native AIO
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Completed initialization of buffer pool
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: highest supported file format is Barracuda.
Aug 13 08:29:21 deb-web mysqld: 140813 8:29:21 InnoDB: Waiting for the background threads to start
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [Note] - '127.0.0.1' resolves to '127.0.0.1';
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [Note] Server socket created on IP: '127.0.0.1'.
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 [ERROR] Aborting
Aug 13 08:29:22 deb-web mysqld:
Aug 13 08:29:22 deb-web mysqld: 140813 8:29:22 InnoDB: Starting shutdown...
Aug 13 08:29:23 deb-web mysqld: 140813 8:29:23 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 08:29:23 deb-web mysqld: 140813 8:29:23 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 08:29:23 deb-web mysqld:
Aug 13 08:29:23 deb-web mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 13 08:29:35 deb-web /etc/init.d/mysql[16090]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 08:29:35 deb-web /etc/init.d/mysql[16090]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 08:29:35 deb-web /etc/init.d/mysql[16090]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 08:29:35 deb-web /etc/init.d/mysql[16090]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 08:29:35 deb-web /etc/init.d/mysql[16090]:
Aug 13 09:07:17 deb-web mysqld_safe[22998]: 140813 9:07:17 [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.
Aug 13 09:07:18 deb-web mysqld_safe[22998]: 140813 9:07:18 [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.
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Aug 13 09:07:18 deb-web mysqld_safe[22998]: To do so, start the server, then issue the following commands:
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: /usr/bin/mysqladmin -u root password 'new-password'
Aug 13 09:07:18 deb-web mysqld_safe[22998]: /usr/bin/mysqladmin -u root -h deb-web password 'new-password'
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: Alternatively you can run:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: /usr/bin/mysql_secure_installation
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: which will also give you the option of removing the test
Aug 13 09:07:18 deb-web mysqld_safe[22998]: databases and anonymous user created by default. This is
Aug 13 09:07:18 deb-web mysqld_safe[22998]: strongly recommended for production servers.
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: See the manual for more instructions.
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[22998]: Please report any problems at http://bugs.mysql.com/
Aug 13 09:07:18 deb-web mysqld_safe[22998]:
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 [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.
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 [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.
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: The InnoDB memory heap is disabled
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Using Linux native AIO
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Completed initialization of buffer pool
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: highest supported file format is Barracuda.
Aug 13 09:07:18 deb-web mysqld_safe[23043]: 140813 9:07:18 InnoDB: Waiting for the background threads to start
Aug 13 09:07:19 deb-web mysqld_safe[23043]: 140813 9:07:19 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 09:07:19 deb-web mysqld_safe[23043]: 140813 9:07:19 InnoDB: Starting shutdown...
Aug 13 09:07:20 deb-web mysqld_safe[23043]: 140813 9:07:20 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 [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.
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 [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.
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: The InnoDB memory heap is disabled
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Using Linux native AIO
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Completed initialization of buffer pool
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: highest supported file format is Barracuda.
Aug 13 09:07:22 deb-web mysqld_safe[23099]: 140813 9:07:22 InnoDB: Waiting for the background threads to start
Aug 13 09:07:23 deb-web mysqld_safe[23099]: 140813 9:07:23 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 09:07:23 deb-web mysqld_safe[23099]: 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
Aug 13 09:07:23 deb-web mysqld_safe[23099]: 140813 9:07:23 [ERROR] Aborting
Aug 13 09:07:23 deb-web mysqld_safe[23099]:
Aug 13 09:07:23 deb-web mysqld_safe[23099]: 140813 9:07:23 InnoDB: Starting shutdown...
Aug 13 09:07:24 deb-web mysqld_safe[23099]: 140813 9:07:24 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 09:07:24 deb-web mysqld_safe[23099]: 140813 9:07:24 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 09:07:24 deb-web mysqld_safe[23099]:
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 [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.
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 [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.
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: The InnoDB memory heap is disabled
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Using Linux native AIO
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Completed initialization of buffer pool
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: highest supported file format is Barracuda.
Aug 13 09:07:24 deb-web mysqld_safe[23126]: 140813 9:07:24 InnoDB: Waiting for the background threads to start
Aug 13 09:07:25 deb-web mysqld_safe[23126]: 140813 9:07:25 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 09:07:25 deb-web mysqld_safe[23126]: 140813 9:07:25 InnoDB: Starting shutdown...
Aug 13 09:07:26 deb-web mysqld_safe[23126]: 140813 9:07:26 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 [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.
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 [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.
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: The InnoDB memory heap is disabled
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Using Linux native AIO
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Completed initialization of buffer pool
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: highest supported file format is Barracuda.
Aug 13 09:07:26 deb-web mysqld_safe[23153]: 140813 9:07:26 InnoDB: Waiting for the background threads to start
Aug 13 09:07:27 deb-web mysqld_safe[23153]: 140813 9:07:27 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 09:07:27 deb-web mysqld_safe[23153]: ERROR: 1050 Table 'plugin' already exists
Aug 13 09:07:27 deb-web mysqld_safe[23153]: 140813 9:07:27 [ERROR] Aborting
Aug 13 09:07:27 deb-web mysqld_safe[23153]:
Aug 13 09:07:27 deb-web mysqld_safe[23153]: 140813 9:07:27 InnoDB: Starting shutdown...
Aug 13 09:07:28 deb-web mysqld_safe[23153]: 140813 9:07:28 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 09:07:28 deb-web mysqld_safe[23153]: 140813 9:07:28 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 09:07:28 deb-web mysqld_safe[23153]:
Aug 13 09:07:28 deb-web mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 [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.
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 [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.
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: The InnoDB memory heap is disabled
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: Using Linux native AIO
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: Completed initialization of buffer pool
Aug 13 09:07:28 deb-web mysqld: 140813 9:07:28 InnoDB: highest supported file format is Barracuda.
Aug 13 09:07:29 deb-web mysqld: 140813 9:07:29 InnoDB: Waiting for the background threads to start
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [Note] - '127.0.0.1' resolves to '127.0.0.1';
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [Note] Server socket created on IP: '127.0.0.1'.
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [ERROR] Aborting
Aug 13 09:07:30 deb-web mysqld:
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 InnoDB: Starting shutdown...
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 09:07:30 deb-web mysqld: 140813 9:07:30 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 09:07:30 deb-web mysqld:
Aug 13 09:07:30 deb-web mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 13 09:07:43 deb-web /etc/init.d/mysql[23805]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 09:07:43 deb-web /etc/init.d/mysql[23805]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 09:07:43 deb-web /etc/init.d/mysql[23805]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 09:07:43 deb-web /etc/init.d/mysql[23805]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 09:07:43 deb-web /etc/init.d/mysql[23805]:
Aug 13 17:02:17 deb-web mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 [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.
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 [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.
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 [Note] Plugin 'FEDERATED' is disabled.
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: The InnoDB memory heap is disabled
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Compressed tables use zlib 1.2.7
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Using Linux native AIO
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Initializing buffer pool, size = 128.0M
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Completed initialization of buffer pool
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: highest supported file format is Barracuda.
Aug 13 17:02:17 deb-web mysqld: 140813 17:02:17 InnoDB: Waiting for the background threads to start
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 InnoDB: 5.5.38 started; log sequence number 1595675
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [Note] - '127.0.0.1' resolves to '127.0.0.1';
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [Note] Server socket created on IP: '127.0.0.1'.
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 [ERROR] Aborting
Aug 13 17:02:18 deb-web mysqld:
Aug 13 17:02:18 deb-web mysqld: 140813 17:02:18 InnoDB: Starting shutdown...
Aug 13 17:02:19 deb-web mysqld: 140813 17:02:19 InnoDB: Shutdown completed; log sequence number 1595675
Aug 13 17:02:19 deb-web mysqld: 140813 17:02:19 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 13 17:02:19 deb-web mysqld:
Aug 13 17:02:19 deb-web mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 13 17:02:31 deb-web /etc/init.d/mysql[12222]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 17:02:31 deb-web /etc/init.d/mysql[12222]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 17:02:31 deb-web /etc/init.d/mysql[12222]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 17:02:31 deb-web /etc/init.d/mysql[12222]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 17:02:31 deb-web /etc/init.d/mysql[12222]:
ps
долго читал логи. Нутром чувствую, что надо открыть порт 3306 - а что это такое и как это сделать - понять не могу. Но я могу и ошибаться.
sudo ip a
1: lo: <LOOPBACK> mtu 16436 qdisc noop state DOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP ql en 1000
link/ether 52:54:00:30:52:1a brd ff:ff:ff:ff:ff:ff
inet 192.168.0.50/24 brd 192.168.0.255 scope global eth0
inet6 fe80::5054:ff:fe30:521a/64 scope link
valid_lft forever preferred_lft forever
sudo ifup lo
[sudo] password for user:
Ignoring unknown interface lo=lo.
user@my_komp:~$ sudo service mysql start
[FAIL] Starting
Показывайте /etc/network/interfaces
Я попробовал раскоменнтировать параметр auto lo и физически перезагрузил гостя, но это не помогло - такая же ошибка в mysql
Сам днс у меня в другом файле
большое спасибо, перезагрузка сети не помогла, но вот полная перезагрузка машины помогла.
Очень тяжело, что на https://wiki.debian.org/ru/NetworkConfiguration нет подробного описания параметров, а в man только на нерусском. Потому я поправил interfaces а вот что значат эти два параметра не понял
большое спасибо, перезагрузка сети не помогла, но вот полная перезагрузка машины помогла.
Очень тяжело, что на https://wiki.debian.org/ru/NetworkConfiguration нет подробного описания параметров, а в man только на нерусском. Потому я поправил interfaces а вот что значат эти два параметра не понял
lo - виртуальный сетевой интерфейс.
auto lo - это автоматическое поднятие lo интерфейса при старте системы.
iface lo inet loopback - это петля, висит на 127.0.0.1 ( не знаю как на пальцах обяснить )