Search code examples
debianmariadbdebian-jessie

Mariadb-server 10.2. fresh install in debian 8 shows error

I have followed the link for installation .

https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&distro=Debian&distro_release=jessie--jessie&version=10.2

After adding Repo.list and keys , it started installing .But ended up with the following error message

Unable to set password for the MariaDB "root" user An error occurred while setting the password for the MariaDB administrative user. This may have happened because the account already has a password, or because of a communication problem with the MariaDB server. You should check the account's password after the package installation.

But Mariadb-10.0 , 10.1 distributions are installing properly and working fine .

Solution

  • The solution given by this link works for me https://jira.mariadb.org/browse/MDEV-14416

    It was a bug with ext3 file system. They fixed it already . The patch will be released in version 10.2.11.But for this above situation please do the following steps [I am doing fresh installation. so no databases inside].

    1. open my.cnf file , find innodb_flush_method = O_DIRECT comment it and save .
    2. rm -rf /var/lib/mysql/*
    3. mysql_install_db
    4. systemctl start mariadb.service
    5. mysql -u root [without password]

    After entering console , you can set password using the following command

    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('pass');