Home / It - Notizen / Linux / Mariadb (MySQL)

Mariadb (MySQL)


Artixlinux:

After installation run
 sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Errors like
InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch)

may result from the left over directory /var/lib/mysql after a deinstallation. Maybe even after an update of mariadb.

Run: sudo mysql_secure_installation

Run: sudo service mysql start

Errors like
* MySQL datadir `' is empty or invalid
or

* checkpath: mkdir: No such file or directory
* Directory for pidfile does not exist and cannot be created


/etc/mysql/my.cnf
must contain
  1. user        = mysql
    port        = 3306
    socket     = /run/mysqld/mysqld.sock
    datadir    = /var/lib/mysql
    pid-file    = /var/run/mysqld/mysqld.pid





     RSS of this page

    Written by:   Version:   Edited By:   Modified