This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

can't get mariadb to start in Slackware

After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states..

140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140324 16:49:05 InnoDB: The InnoDB memory heap is disabled
140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8
140324 16:49:05 InnoDB: Using Linux native AIO
140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M
140324 16:49:05 InnoDB: Completed initialization of buffer pool
140324 16:49:05 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140324 16:49:05  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140324 16:49:05  InnoDB: Waiting for the background threads to start
140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945
140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled.
140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

Answer

 $ perror 13
OS error code  13:  Permission denied

Make sure that mysql user has necessary permissions on table files and database directories.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.