I experienced this issue when trying to install MySQL Server on Debian 10.
Here’s how I fixed it:
The issue is caused by the MySQL server apt repository not being included in your system’s software repository list. In Debian 10 for example, MariaDB, a community fork of the MySQL project, is packaged as the default MySQL variant.
So to fix this first, add the MySQL server apt repository to your system’s software repository list. Follow these steps:
Go to the download page for the MySQL APT repository at:
https://dev.mysql.com/downloads/repo/apt/
Select and download the release package for your Linux distribution. You can use:
sudo wget https://the-download-link
In my case it was:
sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
Install the downloaded release package with the following command, replacing version-specific-package-name with the name of the downloaded package (preceded by its path, if you are not running the command inside the folder where the package is):
sudo dpkg -i version-specific-package-name.deb
In my case it was:
sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
Note: dpkg is used to install, remove, and inspect .deb software packages. The -i flag indicates that we’d like to install from the specified file.
During the installation, you’ll be presented with a configuration screen where you can specify which version of MySQL you’d prefer, along with an option to install repositories for other MySQL-related tools. The defaults will add the repository information for the latest stable version of MySQL and nothing else. This is what we want, so use the down arrow to navigate to the Ok menu option and hit ENTER.
You’ll also be asked to select a repository to add. Choose ‘debian buster’ which has the package ‘mysql-server’ in it. After the adding this repository you can update the repository and use the below command to install MySQL.
sudo apt-get install mysql-server
The package will now finish adding the repository. Refresh your apt package cache to make the new software packages available:
sudo apt update
Note: If you ever need to update the configuration of these repositories, just run sudo dpkg-reconfigure mysql-apt-config, select new options, and then sudo apt-get update to refresh your package cache.
Install MySQL by the following command:
sudo apt-get install mysql-server mysql-client libmysqlclient-dev
Note: This installs the package for the MySQL server, as well as the packages for the client and for the database common files. During the installation, you are asked to supply a password for the root user for your MySQL installation.
The MySQL server is started automatically after installation. You can check the status of the MySQLserver with the following command:
sudo service mysql status
Stop the MySQL server with the following command:
sudo service mysql stop
To restart the MySQL server, use the following command:
sudo service mysql start
MySQL creates a default user called root. You can change the password to any password of your choice by logging in to MySQL console using socket authentication:
sudo mysql -u root
Then run the command below to change the password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your-preferred-password';
Reference:
A Quick Guide to Using the MySQL APT Repository
How To Install the Latest MySQL on Debian 10
That’s all.
I hope this helps
Модератор: Bizdelnick
-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Решено: Ошибка при установке mysql на дебиан
На свежеустановленную виртуальную машину в квм хозяин убунту установил дебиан 7.6
На дебиане настроил сетевое, устанавливаю mysql-client mysql-server
Сервер мне выводит ошибку при установке и при попытке войти в БД не входит. Удаление mysql и переустановка не помгла. В чем можеть быть дело?
Сама ошибка при установке (первая):
Код: Выделить всё
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed !
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: ошибка при обработке параметра mysql-server-5.5 (--configure):
подпроцесс установлен сценарий post-installation возвратил код ошибки 1При входе:
Код: Выделить всё
mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/runВсё вместе
Код: Выделить всё
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)-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
azsx » 12.08.2014 18:21
dpkg -a -D3
dpkg: ошибка: укажите требуемое действие
а вот dpkg -A -D3 зы в мане просто верхний регистр
предлагает указать имя файла для операции —record-avail
сейчас я пыаюсь понять что это за операция и что за файл надо написать
-
Bizdelnick
- Модератор
- Сообщения: 20349
- Статус: nulla salus bello
- ОС: Debian GNU/Linux
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
Bizdelnick » 12.08.2014 19:58
Сорри, имел в виду dpkg —configure -a -D3. Сам точно не помнил, а в мане немного непонятно написано.
Пишите правильно:
| в консоли вку́пе (с чем-либо) в общем вообще |
в течение (часа) новичок нюанс по умолчанию |
приемлемо проблема пробовать трафик |
-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
azsx » 13.08.2014 04:11
Сама ошибка:
Код: Выделить всё
[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Весь вывод:
Код: Выделить всё
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Запускал из под рута, в процессе система попросила установить пароль на бд пароль
-
neol
- Сообщения: 600
- ОС: Debian Stable
- Контактная информация:
-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
azsx » 13.08.2014 12:12
А если руками попытаться запустить — что скажет?
Код: Выделить всё
sudo /etc/init.d/mysql start
[sudo] password for user:
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!grep mysql /var/log/daemon.log
вывод ошибок за 13 число в топике и за 12 и 13 число на файл выгрузил http://dropmefiles.com/g1AtN
Код: Выделить всё
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 — а что это такое и как это сделать — понять не могу. Но я могу и ошибаться.
-
neol
- Сообщения: 600
- ОС: Debian Stable
- Контактная информация:
-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
azsx » 13.08.2014 17:00
с выборкой по 3306 вывод пустой (ничего нет). Вот вывод без выборки соектов с вашими параметрами но без выделения 3306
Код: Выделить всё
sudo ss -tnlp
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 128 :::111 :::* users:(("rpcbind",1584,11))
LISTEN 0 128 *:111 *:* users:(("rpcbind",1584,8))
LISTEN 0 128 *:22 *:* users:(("sshd",2457,4))
LISTEN 0 128 :::22 :::* users:(("sshd",2457,3))
LISTEN 0 128 :::44159 :::* users:(("rpc.statd",1615,10))
LISTEN 0 128 *:58405 *:* users:(("rpc.statd",1615,8))Вот команда
Код: Выделить всё
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-
azsx
- Сообщения: 3684
- ОС: calculate linux, debian, ubuntu
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
azsx » 14.08.2014 04:44
Быстрое решение проблемы по идее:
Код: Выделить всё
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
Сам днс у меня в другом файле
Код: Выделить всё
# auto lo
# iface lo inet loopback
# allow-hotplug eth0
# iface eth0 inet dhcp
auto eth0
iface eth0 inet static
address 192.168.0.50
netmask 255.255.255.0
gateway 192.168.0.1
#dns-nameservers 192.168.0.1 8.8.8.8-
Linuxman
- Сообщения: 388
- ОС: Arch Linux, OpenSUSE
Re: Решено: Ошибка при установке mysql на дебиан
Сообщение
Linuxman » 14.08.2014 10:45
azsx писал(а): ↑
14.08.2014 09:58
auto lo
iface lo inet loopbackбольшое спасибо, перезагрузка сети не помогла, но вот полная перезагрузка машины помогла.
Очень тяжело, что на https://wiki.debian.org/ru/NetworkConfiguration нет подробного описания параметров, а в man только на нерусском. Потому я поправил interfaces а вот что значат эти два параметра не понял
lo — виртуальный сетевой интерфейс.
auto lo — это автоматическое поднятие lo интерфейса при старте системы.
iface lo inet loopback — это петля, висит на 127.0.0.1 ( не знаю как на пальцах обяснить 
)
Now I know only I can stop the rain…
After working with this about 4 hours, I finally figured it out. When installing Debian, I was presented with some options regarding software to install. One of those options was to install Web server software. So, I chose to do so. That was a mistake. First, you don’t get all of the needed php modules by selected that option. Secondly, that selection does install some of what is needed for MySql, but not enough to actually work.
So, in the end, for anyone else who has this issue, this is how I fixed it.
First, run the commands:
sudo service mysql stop
sudo apt-get --purge remove "mysql*"
sudo rm -rf /etc/mysql/
Then, make sure everything is gone by running
sudo updatedb
locate mysql
You will still see a few things, but make sure that you don’t see a my.cnf file. That was the culprit in my case. If you do see it, delete it as well.
Now reinstall MySql and you shouldn’t have any issues. If you are also installing phpMyAdmin, you will still need to run one more command to get the needed extensions.
sudo apt install php-imagick php-phpseclib php-php-gettext php7.3-common
php7.3-gd php7.3-imap php7.3-json php7.3-curl php7.3-zip php7.3-xml
php7.3-mbstring php7.3-bz2 php7.3-intl php7.3-gmp
Debian GNU/Linux 8.7 (jessie)
Хочу установить пакет mysql-server, выполняю команду:# apt-get install mysql-server
В результате получаю ошибку:
E: Sub-process /usr/bin/dpkg returned an error code (1)Вот полный вывод:
root@dev:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
mysql-server-5.5
Suggested packages:
tinyca
The following NEW packages will be installed:
mysql-server mysql-server-5.5
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/1,846 kB of archives.
After this operation, 32.5 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
(Reading database ... 48232 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb ...
Aborting downgrade from (at least) 10.1 to 5.5.
If are sure you want to downgrade to 5.5, remove the file
/var/lib/mysql/debian-*.flag and try installing again.
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.5.54-0+deb8u1_all.deb ...
Unpacking mysql-server (5.5.54-0+deb8u1) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)root@dev:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
mysql-server-5.5
Suggested packages:
tinyca
The following NEW packages will be installed:
mysql-server-5.5
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/1,766 kB of archives.
After this operation, 32.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
(Reading database ... 48232 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb ...
Aborting downgrade from (at least) 10.1 to 5.5.
If are sure you want to downgrade to 5.5, remove the file
/var/lib/mysql/debian-*.flag and try installing again.
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.5_5.5.54-0+deb8u1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)root@dev:~# dpkg --configure -a
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not installed.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-serverЧто эта ошибка означает, и как ее побороть?
I have had the problem of fetching mysql-5.6 for my developers’ workstations (which run a more recent distro that no longer has the version I need). After much fighting and failing with source files I went hunting for the *.deb files, installed them manually and then marked them for holding.
I found the packages I wanted in http://repo.mysql.com/apt/ubuntu/pool/mysql-5.6/m/mysql-community/, but there are debian versions as well.
Download your required version of (you don’t need all but I like to have them)
- libmysqlclient18
- mysql-common
- mysql-community-client (depends on common)
- mysql-community-server (depends on client)
- mysql-client
- mysql-server
Install them manually using sudo dpkg -i <deb-file>. There has to be a better way of doing this, dpkg does not resolve dependencies automatically.
When you hit a dependency quandary, run sudo apt-get -f install and cross your fingers that it’ll resolve the marked dependencies (I can’t help any further but to say hunt down the package and install it manually also).
Retry installing the failed package installations.
Lastly, hold your versions with sudo apt-mark hold <package-name> ...
In my case it was easy:
sudo apt-mark hold mysql-{common,community-{client,server}}
This process has been performed in a virtualized test environment and it has worked so far