Arch Linux

d_fajardo

Member

Registered: 2017-07-28

Posts: 1,689

[Solved] Help in setting up mysql

I am trying to install LAMP. I've installed Apache successfully but when I try to start mysqld.service I get this error:

Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

systemctl status mariadb.service gives me this output:

● mariadb.service - MariaDB 10.1.37 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2018-11-29 23:12:43 GMT; 12s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 5877 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 5817 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_P>
  Process: 5816 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 5877 (code=exited, status=1/FAILURE)
   Status: "Starting Innodb crash recovery"

Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [Note] Recovering after a crash using mysql-bin
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [Note] Starting crash recovery...
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [Note] Crash recovery finished.
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504334592 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.g>
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [Note] Server socket created on IP: '::'.
Nov 29 23:12:43 TUF-Z270 mysqld[5877]: 2018-11-29 23:12:43 139637504356288 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Nov 29 23:12:43 TUF-Z270 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 29 23:12:43 TUF-Z270 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 29 23:12:43 TUF-Z270 systemd[1]: Failed to start MariaDB 10.1.37 database server.

It looks like it's crashing.
Any solution?

Last edited by d_fajardo (2018-12-03 06:18:15)

Trilby

Inspector Parrot

Registered: 2011-11-29

Posts: 30,531

Website

Re: [Solved] Help in setting up mysql

https://wiki.archlinux.org/index.php/My … figuration

---

"UNIX is simple and coherent" - Dennis Ritchie; "GNU's Not Unix" - Richard Stallman

d_fajardo

Member

Registered: 2017-07-28

Posts: 1,689

Re: [Solved] Help in setting up mysql

Thanks Trilby. I'll look into that.

d_fajardo

Member

Registered: 2017-07-28

Posts: 1,689

Re: [Solved] Help in setting up mysql

All sorted out thanks.