====my.cnf 的配置====[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-name-resolve
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid#validate_password=off
#default-storage-engine=INNODB
#character-set-server=utf8
#collation-server=utf8_general_ci
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d=======查看日志==========
[root@instance-25cnpiiz mariadb]# more mariadb.log
190307 22:31:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190307 22:31:22 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 4984 ...
190307 22:31:22 InnoDB: The InnoDB memory heap is disabled
190307 22:31:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190307 22:31:22 InnoDB: Compressed tables use zlib 1.2.7
190307 22:31:22 InnoDB: Using Linux native AIO
190307 22:31:22 InnoDB: Initializing buffer pool, size = 128.0M
190307 22:31:22 InnoDB: Completed initialization of buffer pool
190307 22:31:22 InnoDB: highest supported file format is Barracuda.
190307 22:31:22 InnoDB: Waiting for the background threads to start
190307 22:31:23 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 8878157
190307 22:31:23 [Note] Plugin 'FEEDBACK' is disabled.
190307 22:31:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
190307 22:31:23 [Note] Server socket created on IP: '0.0.0.0'.
190307 22:31:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
190307 22:31:23 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
[root@instance-25cnpiiz mariadb]#
====运行报错====
systemctl start mariadbJob for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-name-resolve
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid#validate_password=off
#default-storage-engine=INNODB
#character-set-server=utf8
#collation-server=utf8_general_ci
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d=======查看日志==========
[root@instance-25cnpiiz mariadb]# more mariadb.log
190307 22:31:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
190307 22:31:22 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 4984 ...
190307 22:31:22 InnoDB: The InnoDB memory heap is disabled
190307 22:31:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190307 22:31:22 InnoDB: Compressed tables use zlib 1.2.7
190307 22:31:22 InnoDB: Using Linux native AIO
190307 22:31:22 InnoDB: Initializing buffer pool, size = 128.0M
190307 22:31:22 InnoDB: Completed initialization of buffer pool
190307 22:31:22 InnoDB: highest supported file format is Barracuda.
190307 22:31:22 InnoDB: Waiting for the background threads to start
190307 22:31:23 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 8878157
190307 22:31:23 [Note] Plugin 'FEEDBACK' is disabled.
190307 22:31:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
190307 22:31:23 [Note] Server socket created on IP: '0.0.0.0'.
190307 22:31:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
190307 22:31:23 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
[root@instance-25cnpiiz mariadb]#
====运行报错====
systemctl start mariadbJob for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
查看的原因如下！！！！！
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since 四 2019-03-07 23:07:02 CST; 3min 35s ago
Process: 5859 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 5858 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 5828 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 5858 (code=exited, status=0/SUCCESS)3月 07 23:07:00 instance-25cnpiiz mariadb-wait-ready[5859]: Warning: World-writable config file '/etc/my.cnf'...red
3月 07 23:07:00 instance-25cnpiiz mariadb-wait-ready[5859]: Warning: World-writable config file '/etc/my.cnf'...red
3月 07 23:07:00 instance-25cnpiiz mysqld_safe[5858]: Warning: World-writable config file '/etc/my.cnf' is ignored
3月 07 23:07:00 instance-25cnpiiz mysqld_safe[5858]: Warning: World-writable config file '/etc/my.cnf' is ignored
3月 07 23:07:00 instance-25cnpiiz mysqld_safe[5858]: 190307 23:07:00 mysqld_safe Logging to '/var/lib/mysql/...rr'.
3月 07 23:07:00 instance-25cnpiiz mysqld_safe[5858]: 190307 23:07:00 mysqld_safe Starting mysqld daemon with...ysql
3月 07 23:07:02 instance-25cnpiiz systemd[1]: mariadb.service: control process exited, code=exited status=1
3月 07 23:07:02 instance-25cnpiiz systemd[1]: Failed to start MariaDB database server.
3月 07 23:07:02 instance-25cnpiiz systemd[1]: Unit mariadb.service entered failed state.
3月 07 23:07:02 instance-25cnpiiz systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.