MariaDB没有盯着看

Question

Redirecting to /bin/systemctl status  -l mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2016-12-13 13:41:00 PKT; 10min ago
  Process: 8193 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 8192 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 8164 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 8192 (code=exited, status=0/SUCCESS)

Dec 13 13:40:57 ns*.ip-19***** systemd[1]: Starting MariaDB database server...
Dec 13 13:40:57 ns*.ip-19***** mysqld_safe[8192]: 161213 13:40:57 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Dec 13 13:40:57 ns*.ip-19***** mysqld_safe[8192]: 161213 13:40:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Dec 13 13:41:00 ns*.ip-19***** mysqld_safe[8192]: 161213 13:41:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Dec 13 13:41:00 ns*.ip-19***** systemd[1]: mariadb.service: control process exited, code=exited status=1
Dec 13 13:41:00 ns*.ip-19***** systemd[1]: Failed to start MariaDB database server.
Dec 13 13:41:00 ns*.ip-19***** systemd[1]: Unit mariadb.service entered failed state.
Dec 13 13:41:00 ns*.ip-19***** systemd[1]: mariadb.service failed.

plesk help repair mysql

161213 14:01:16[注意]/usr/libexec/mysqld：关闭完成

161213 14:01:16 mysqld_safe mysqld从pid文件/var/run/mariadb/mariadb.pid结束

Answer 1

在my.cnf中有safe-show-database。我删除了safe-show-database并再次启动MariaDB服务，它可以工作了。

原因

此选项不推荐使用，并且不会执行任何操作，因为有一个SHOW DATABASES特权可用于控制每个帐户对数据库名称的访问。请参见第6.2.1节“MySQL提供的特权”。--safe-show-database在MySQL 5.5.3中被删除。