Не получается установить MySQL

[slava3432]

Народ, помогите пожалуйта, решил поставить сервер в КС на Ubuntu, только начал с ней знакомство и при попытки создать mySql базу он выдает ошибку. Помогите пожалуйста

Код: [Выделить]

root@v082kat6nkekvm27i:~# sudo apt-get install mysql-server mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.4) ...
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
2020-09-26T19:14:50.239030Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
* mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: exit-code) since Sat 2020-09-26 22:14:52 MSK; 15ms ago
    Process: 5403 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


[Aleksandru]

Измените название темы на более информативное, иначе тема будет закрыта:

Правила форума
2. На форуме ЗАПРЕЩЕНО
2.6. Создавать темы с неинформативным названием, например «Помогите», «Пара вопросов», «Настройка Интернета» и т. п.

--Aleksandru

[kac]

1. /var/log/mysql/error.log что туту?
2.

Код: [Выделить]

mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.Попробуй sudo apt-get install -f
Возможно что то не доставило.

[slava3432]

1. /var/log/mysql/error.log что туту?
2.

Код: [Выделить]

mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.Попробуй sudo apt-get install -f
Возможно что то не доставило.

Код: [Выделить]

2020-09-26T16:32:14.429549Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) initializing of server in progress as process 2845
2020-09-26T16:32:14.446980Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-26T16:32:14.531592Z 1 [Warning] [MY-012637] [InnoDB] 1048576 bytes should have been written. Only 692224 bytes written. Retrying for the remaining bytes.
2020-09-26T16:32:14.531792Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2020-09-26T16:32:14.531951Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibdata1 failed at offset 1048576, 1048576 bytes should have been written, only 692224 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2020-09-26T16:32:14.532076Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
2020-09-26T16:32:14.532308Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibdata1'. Probably out of disk space
2020-09-26T16:32:14.532452Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2020-09-26T16:32:15.024466Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:32:15.024706Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-26T16:32:15.024886Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:32:15.025709Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:32:15.655583Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 2865
2020-09-26T16:32:15.721543Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:32:15.721738Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:32:15.721884Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:32:15.727260Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:33:10.885282Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3120
2020-09-26T16:33:10.943173Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:33:10.943386Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:33:10.943531Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:33:10.954708Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:48:45.576647Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3375
2020-09-26T16:48:45.639754Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:48:45.640008Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:48:45.640150Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:48:45.649007Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:05:17.636930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3559
2020-09-26T17:05:17.735834Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:05:17.736132Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:05:17.736257Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:05:17.743304Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:46:47.981306Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3815
2020-09-26T17:46:48.020278Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:46:48.020521Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:46:48.020642Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:46:48.027316Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:47:12.892517Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3995
2020-09-26T17:47:12.939403Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:47:12.939654Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:47:12.939807Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:47:12.949035Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:47:55.172334Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4179
2020-09-26T17:47:55.225897Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:47:55.226231Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:47:55.226391Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:47:55.234828Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:07:28.351509Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4727
2020-09-26T19:07:28.406453Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:07:28.406719Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:07:28.406839Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:07:28.413808Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:08:51.606667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4964
2020-09-26T19:08:51.664911Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:08:51.665203Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:08:51.665336Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:08:51.671520Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:08:57.265157Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 5143
2020-09-26T19:08:57.298777Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:08:57.299021Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:08:57.299155Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:08:57.305653Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:14:50.200513Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 5346
2020-09-26T19:14:50.238626Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:14:50.238826Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:14:50.238948Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:14:50.245136Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).


[AlexDem]

Народ, помогите пожалуйта, решил поставить сервер в КС на Ubuntu, только начал с ней знакомство и при попытки создать mySql базу он выдает ошибку. Помогите пожалуйста

Если не получится поставить, то ставь MariaDB, тоже отличный MySQL сервер, я как раз на нем работаю.

[kac]

Код: [Выделить]

Failed to find valid data directory.
Data Dictionary initialization failed
Явно установка некорректна.
Пробуйте переустановить. Или доставить нужные пакеты.
Пользователь добавил сообщение 26 Сентября 2020, 23:03:00:

Если не получится поставить, то ставь MariaDB, тоже отличный MySQL

+
Тоже вариант.

[jura12]

Error number 28 means 'No space left on device'

места нет. квоты мешают.

[dm999]

MariaDB это теперь вроде как то же, что и MySQL

[AlexDem]

MariaDB это теперь вроде как то же, что и MySQL

не теперь, а оно же всегда так и было