mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Поиск в google ничего по этому поводу не говорит =(
Здравствуйте,
напишите, пожалуйста, как можно детальнее, как Вы делаете установку, чтобы мы могли Вам помочь.
Приєднуйтесь до нас на Facebook або vKontakte та отримуйте наші ексклюзивні пропозиції, а також будьте в курсі важливих подій і новин світу веб-хостингів!
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
mysql-server
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/10.8 kB of archives.
After this operation, 110 kB of additional disk space will be used.
Selecting previously unselected package mysql-server.
(Reading database ... 19160 files and directories currently installed.)
Preparing to unpack .../mysql-server_5.7.22-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.22-0ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
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 Mon 2018-04-30 12:09:29 UTC; 7ms ago
Process: 9064 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Control process exited, code=exited status=1
Apr 30 12:09:29 zzz166 systemd[1]: Failed to start MySQL Community Server.
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Unit entered failed state.
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
как следствие не запустить сервер не подключиться не получается
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
journalctl -xe
Hint: You are currently not seeing messages from other users and the system.
Users in the 'systemd-journal' group can see all messages. Pass -q to
turn off this notice.
No journal files were opened due to insufficient permissions.
yurii@zzz166:/$ sudo journalctl -xe
Apr 30 12:10:58 zzz166 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Apr 30 12:10:58 zzz166 systemd[1]: Failed to reset devices.list on /system.slice/mysql.service: Operation not permitted
Apr 30 12:10:58 zzz166 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Apr 30 12:10:58 zzz166 mysql-systemd-start[9148]: MySQL system database not found in /var/lib/mysql. Please run mysqld --initialize.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Control process exited, code=exited status=1
Apr 30 12:10:58 zzz166 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Unit entered failed state.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 30 12:10:59 zzz166 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Apr 30 12:10:59 zzz166 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Apr 30 12:10:59 zzz166 systemd[1]: mysql.service: Start request repeated too quickly.
Apr 30 12:10:59 zzz166 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Apr 30 12:11:38 zzz166 sudo[9155]: yurii : TTY=pts/1 ; PWD=/ ; USER=root ; COMMAND=/bin/journalctl -xe
Apr 30 12:11:38 zzz166 sudo[9155]: pam_unix(sudo:session): session opened for user root by yurii(uid=0)
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
mysql-server
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/10.8 kB of archives.
After this operation, 110 kB of additional disk space will be used.
Selecting previously unselected package mysql-server.
(Reading database ... 19160 files and directories currently installed.)
Preparing to unpack .../mysql-server_5.7.22-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.22-0ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
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 Mon 2018-04-30 12:09:29 UTC; 7ms ago
Process: 9064 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Control process exited, code=exited status=1
Apr 30 12:09:29 zzz166 systemd[1]: Failed to start MySQL Community Server.
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Unit entered failed state.
Apr 30 12:09:29 zzz166 systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
как следствие не запустить сервер не подключиться не получается
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
journalctl -xe
Hint: You are currently not seeing messages from other users and the system.
Users in the 'systemd-journal' group can see all messages. Pass -q to
turn off this notice.
No journal files were opened due to insufficient permissions.
yurii@zzz166:/$ sudo journalctl -xe
Apr 30 12:10:58 zzz166 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Apr 30 12:10:58 zzz166 systemd[1]: Failed to reset devices.list on /system.slice/mysql.service: Operation not permitted
Apr 30 12:10:58 zzz166 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Apr 30 12:10:58 zzz166 mysql-systemd-start[9148]: MySQL system database not found in /var/lib/mysql. Please run mysqld --initialize.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Control process exited, code=exited status=1
Apr 30 12:10:58 zzz166 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Unit entered failed state.
Apr 30 12:10:58 zzz166 systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 30 12:10:59 zzz166 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Apr 30 12:10:59 zzz166 systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Apr 30 12:10:59 zzz166 systemd[1]: mysql.service: Start request repeated too quickly.
Apr 30 12:10:59 zzz166 systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Apr 30 12:11:38 zzz166 sudo[9155]: yurii : TTY=pts/1 ; PWD=/ ; USER=root ; COMMAND=/bin/journalctl -xe
Apr 30 12:11:38 zzz166 sudo[9155]: pam_unix(sudo:session): session opened for user root by yurii(uid=0)
Попробуйте обновить версию Ubuntu до 18.04. Также, рекомендуется устанавливать mysql с официального репозитория MySQL.
Установите параметр innodb_use_native_aio = 0 в соответствующей секции вашего конфигурационного файла /etc/mysql/