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)

Сбрасываем пароли как написано тут и повторяем процесс: