Arch Linux

whitetimer

Member

Registered: 2010-05-23

Posts: 207

[ SOLVED ] Now phpmyadmin does not login

Have just carried out a clean install of mariadb and now when I try to run mysql_secure_installation I receive this error message

● mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (start-post) (Result: exit-code) since Sat 2015-01-31 08:50:36 ACDT; 55s ago
  Process: 6451 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
 Main PID: 6451 (code=exited, status=1/FAILURE);         : 6452 (mysqld-post)
   CGroup: /system.slice/mysqld.service
           └─control
             ├─6452 /bin/sh /usr/bin/mysqld-post
             └─6870 sleep 1

Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Note] Plugin 'FEEDBACK' is disabled.
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Note] Recovering after a crash using mysql-bin
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Note] Starting crash recovery...
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Note] Crash recovery finished.
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [Note] Server socket created on IP: '::'.
Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Jan 31 08:50:37 Julian-Notebook systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE

Any suggestions ?

Cheers

Last edited by whitetimer (2015-01-30 22:14:58)

smirky

Member

From: Bulgaria

Registered: 2013-02-23

Posts: 277

Website

Re: [ SOLVED ] Now phpmyadmin does not login

Jan 31 08:50:37 Julian-Notebook mysqld[6451]: 150131  8:50:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

---

Personal spot  ::  https://www.smirky.net/  ::  Try not to get lost!

TE

Member

Registered: 2014-06-21

Posts: 86

Re: [ SOLVED ] Now phpmyadmin does not login

It looks like your datadir is either missing the mysql/ DB (I haven't checked MariaDB 10, but historically this is in MyISAM format - can't be InnoDB), or has file access permission issues. Compare your datadir ownership and setup to what's in the package post-install code for this:

https://projects.archlinux.org/svntogit … es/mariadb

I.e. if you brought your datadir from something other install, a quick 'chown -R mysql:mysql' on it might fix you right up... then check for datadir/mysql/user.* (frm, myd, myi) and see if they're there as expected. If you see a mysql/user.ibd (sic) that's InnoDB format.

whitetimer

Member

Registered: 2010-05-23

Posts: 207

Re: [ SOLVED ] Now phpmyadmin does not login

Fixed the problem, but now I have this error in phpmyadmin when trying to login.  ON first installation I could log in just fine, but now I get this error message

Connection for controluser as defined in your configuration failed