terça-feira, 19 de julho de 2016

MariaDB - Problemas ao instalar no Centos 7 via YUM



Me deparei com este erro, bem estranho, pois foi logo após instalar o pacote.


# yum -y install mariadb-server

# systemctl start mariadb
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.



# journalctl -xn
160719 15:26:17 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
160719 15:26:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160719 15:26:17 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
160719 15:26:17 [ERROR] Aborting



Bati cabeça até verificar que era um problema de permissões.

# chown -R mysql:mysql /var/lib/mysql

Aí sim, tente :

# systemctl start mariadb


E acesse :

 # mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.47-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>



Dica simples de permissões.