[mysqld]
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql. The sock
# Disabling -- - the links is it to prevent assorted security risks
-- - the links=0
Skip - name - resolve
# Settings the user and group are ignored when systemd is 2.
# If you need to run mysqld under a company's user or group,
# customize your systemd unit file for mariadb "according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
The log - error=/var/log/mariadb/mariadb. The log
Pid - file=/var/run/mariadb/mariadb. The 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
=======check log==========
[root @ the instance - 25 cnpiiz mariadb] # more mariadb. The 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 the process of 4984...
190307 22:31:22 InnoDB: The InnoDB heap memory 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.0 M
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 5.5.52 (http://www.percona.com) - MariaDB 38.3 started; The log sequence number 8878157
190307 22:31:23 [Note] the Plugin 'FEEDBACK is disabled.
190307 22:31:23 [ERROR] Can 't open the mysql. The plugin table. Both 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 the lock and privilege tables: Table' mysql. The host 'doesn' t exist
190307 22:31:23 mysqld_safe mysqld from pid file/var/run/mariadb/mariadb. The pid ended
[root @ the instance - 25 cnpiiz mariadb] #
====run error====
Systemctl start mariadb
Job for mariadb. The service failed because the control process exited with the error code. See "systemctl status mariadb. The service" and "journalctl - xe" for details.
CodePudding user response:
Systemctl status mariadb. ServiceCheck for the following reasons!!!!!!!!!!!!!!
Low mariadb. Service - mariadb database server
The Loaded: the Loaded (/usr/lib/systemd/system/mariadb. The service; Enabled. Vendor preset: disabled)
Active: failed (Result: exit - code) since four 23:07:02 2019-03-07 CST; 3 min line under 35 s
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)
The Main PID: 5858 (code=exited, status=0/SUCCESS)
On March 7 23:07:00 instance - 25 cnpiiz mariadb - wait - ready [5859] : Warning: World - writable config file './etc/my CNF '... Red
On March 7 23:07:00 instance - 25 cnpiiz mariadb - wait - ready [5859] : Warning: World - writable config file './etc/my CNF '... Red
March 7 23:07:00 instance - 25 cnpiiz mysqld_safe [5858] : Warning: World - writable config file '/etc/my CNF' is ignored
March 7 23:07:00 instance - 25 cnpiiz mysqld_safe [5858] : Warning: World - writable config file '/etc/my CNF' is ignored
On March 7 23:07:00 instance - 25 cnpiiz mysqld_safe [5858] : 190307 23:07:00 mysqld_safe Logging to '/var/lib/mysql/... Rr. '
On March 7 23:07:00 instance - 25 cnpiiz mysqld_safe [5858] : 190307 23:07:00 mysqld_safe Starting mysqld daemon with... Ysql
On March 7 23:07:02 instance - 25 cnpiiz systemd [1] : mariadb. Service: control the process exited, code=exited the status=1
March 7 23:07:02 instance - 25 cnpiiz systemd [1] : Failed to start MariaDB database server.
March 7 23:07:02 instance - 25 cnpiiz systemd [1] : Unit mariadb. The service rose failed state.
March 7 23:07:02 instance - 25 cnpiiz systemd [1] : mariadb. The service failed.
Hint: Some lines were ellipsized, use -l to show in full.
CodePudding user response:
That what, first open a screen monitoring error, then vim/etc/my CNF, to check the data path, the whole was up to the