DirectAdmin - CentOS 7 - MYSQL/MariaDB is not starting
Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2024
CENTOS 7 + MARIADB:
# systemctl status mysqld ● mysqld.service - MySQL database server Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: timeout) since Wed 2016-01-27 22:57:31 CET; 3min 6s ago Process: 1265 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS) Main PID: 1265 (code=exited, status=0/SUCCESS) Jan 27 22:52:30 server.net systemd[1]: Starting MySQL database server... Jan 27 22:52:30 server.net mysqld_safe[1265]: 160127 22:52:30 mysqld_safe Logging to '/var/lib/mysql/server.net.net.err'. Jan 27 22:52:30 server.net mysqld_safe[1265]: 160127 22:52:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Jan 27 22:57:30 server.net systemd[1]: mysqld.service start-post operation timed out. Stopping. Jan 27 22:57:31 server.net mysqld_safe[1265]: 160127 22:57:31 mysqld_safe mysqld from pid file /var/lib/mysql/server.net-... ended Jan 27 22:57:31 server.nett systemd[1]: Failed to start MySQL database server. Jan 27 22:57:31 server.net systemd[1]: Unit mysqld.service entered failed state. Jan 27 22:57:31 server.net systemd[1]: mysqld.service failed. Hint: Some lines were ellipsized, use -l to show in full.
Решение - заменить MARIADB на MySQL 5.6 + сбросить пароли от root/da_admin
# cd /usr/local/directadmin/custombuild/ # vi options.conf #MySQL Settings mysql=5.6 #mariadb=10.0 # ./build update # ./build mysql # systemctl restart mysqld.service
Если возникает ошибка при установке MySQL:
Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)
Сбрасываем пароли как написано тут и повторяем процесс: