CentOS7 MariaDB 10.1 or Mysql 5.7

XIII

New member
Hi
i can't install mysql 5.7 or mariaDB 10.1
older version of mysql or mariadb installed fine but when i try install mariadb 10.1 or mysql 5.7 show this error


Code:
[root@server custombuild]# /usr/local/directadmin/directadmin o
Compiled on 'CentOS 7.0 64-Bit'Compile time: Sep 16 2018 at 18:08:25
Compiled with IPv6
Thanks
 

zEitEr

Super Moderator
Hello,

What do you see in mysql error log?

What do you see when running the command:

Code:
rpm -qa | egrep -i "^(mariadb|mysql)"
 

XIII

New member
Hello,

What do you see in mysql error log?

What do you see when running the command:

Code:
rpm -qa | egrep -i "^(mariadb|mysql)"
Hello
mysql error log dosen't exsit :(


Code:
[root@server log]# rpm -qa | egrep -i "^(mariadb|mysql)"
MariaDB-devel-10.1.36-1.el7.centos.x86_64
MariaDB-client-10.1.36-1.el7.centos.x86_64
MariaDB-compat-10.1.36-1.el7.centos.x86_64
MariaDB-common-10.1.36-1.el7.centos.x86_64
MariaDB-shared-10.1.36-1.el7.centos.x86_64
MariaDB-server-10.1.36-1.el7.centos.x86_64
Code:
[root@server log]# systemctl status mysqld.service
● mysqld.service - MariaDB database server
   Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2018-10-05 08:21:32 EDT; 11s ago
  Process: 16576 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 16561 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] &&   systemctl set-environment _WSREP_START_POSITION=$VAR ||
exit 1 (code=exited, status=0/SUCCESS)
  Process: 16559 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 16576 (code=exited, status=1/FAILURE)
   Status: "Starting Innodb crash recovery"

Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Recovering after a crash using tc.log
Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Starting crash recovery...
Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Crash recovery finished.
Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Oct 05 08:21:32 server.behzee.com mysqld[16576]: 2018-10-05  8:21:32 140570376468736 [Note] Server socket created on IP: '::'.
Oct 05 08:21:32 server.behzee.com systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Oct 05 08:21:32 server.behzee.com systemd[1]: Failed to start MariaDB database server.
Oct 05 08:21:32 server.behzee.com systemd[1]: Unit mysqld.service entered failed state.
Oct 05 08:21:32 server.behzee.com systemd[1]: mysqld.service failed.
Code:
[root@server log]# journalctl -xe
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool sOct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: The InnoDB memory heap is disabled
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Compressed tables use zlib 1.2.7
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using Linux native AIO
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Using SSE crc32 instructions
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Completed initialization of buffer pool
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Highest supported file format is Barracuda.
Oct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: The log sequence number 0 in ibdata file do not match the log sequence number 1687737 in tOct 05 08:25:17  mysqld[17139]: 2018-10-05  8:25:17 139701862910208 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB: 128 rollback segment(s) are active.
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB: Waiting for purge to start
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1687737
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701067446016 [Note] InnoDB: Dumping buffer pool(s) not yet started
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Plugin 'FEEDBACK' is disabled.
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Recovering after a crash using tc.log
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Starting crash recovery...
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Crash recovery finished.
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [Note] Server socket created on IP: '::'.
Oct 05 08:25:18  mysqld[17139]: 2018-10-05  8:25:18 139701862910208 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Oct 05 08:25:18  systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Oct 05 08:25:18  systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Oct 05 08:25:18  systemd[1]: Unit mysqld.service entered failed state.
Oct 05 08:25:18  systemd[1]: mysqld.service failed.
 

zEitEr

Super Moderator
See:

[ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

The tables are missing. Your installation might be corrupted. You might try to install MariaDB from a scratch and re-import all the data.
 
Top