系统默认安装的mariadb启动问题

服务器基础
1

由于还是 mysql，
所以
sudo systemctl enable mysql
sudo systemctl start mysql
但启动出错
出现
Job for mysql.service failed. See “systemctl status mysql.service” and “journalctl -xn” for details.

运行 systemctl status mysql.service，结果如下：
mysql.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled)
Active: failed (Result: exit-code) since 二 2015-07-14 21:46:03 CST; 11min ago
Process: 9044 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade default (code=exited, status=1/FAILURE)
Process: 9032 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install default (code=exited, status=0/SUCCESS)
Main PID: 4406 (code=exited, status=1/FAILURE)

2

运行下述命令看看呢

3

– Logs begin at 六 2015-04-18 19:29:22 CST, end at 三 2015-07-15 19:18:43 CST. –
7 月 14 21:25:11 linux-openSUSE su[6958]: pam_unix(su:session): session closed for user root
7 月 14 22:07:42 linux-openSUSE su[2763]: pam_unix(su:session): session closed for user root
7 月 14 22:12:48 linux-openSUSE org.a11y.Bus[1170]: g_dbus_connection_real_closed: Remote peer vanished
– Reboot –
7 月 15 19:18:31 linux-openSUSE org.a11y.Bus[1158]: Activating service name='org.a11y.atspi.Registry’
7 月 15 19:18:31 linux-openSUSE org.a11y.Bus[1158]: Successfully activated service 'org.a11y.atspi.Regis
7 月 15 19:18:31 linux-openSUSE org.a11y.atspi.Registry[1221]: SpiRegistry daemon is running with well-k
7 月 15 19:18:31 linux-openSUSE org.a11y.atspi.Registry[1221]: Xlib: extension “XEVIE” missing on displ
7 月 15 19:18:43 linux-openSUSE pulseaudio[1417]: [pulseaudio] source.c: Default and alternate sample ra
7 月 15 19:18:43 linux-openSUSE pulseaudio[1417]: [pulseaudio] bluez5-util.c: GetManagedObjects() failed
7 月 15 19:18:43 linux-openSUSE pulseaudio[1462]: [pulseaudio] pid.c: Daemon already running.

这个是结果，看不出什么结果

4

应该在你启动 mariadb 失败之后运行该命令才能看到相关的日志吧，你现在看到的日志已经是下午 7 点，和 mariadb 没有任何关系了啊

5

我是安装完后立即启动它，但总是失败

不过，今天我启动它，突然好了，然后我 mysql_secure_installation 成功

现在 mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.0.20-MariaDB openSUSE package

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB (none)]>