CODEWITHSUNDEEP
debianmariadbdebian-jessie
gotam
gotam

Reputation: 193

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 .

Upvotes: 0

Views: 513

Answers (2)

gotam
gotam

Reputation: 193

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');

Upvotes: 2

Mladen Ignjatovic
Mladen Ignjatovic

Reputation: 56

Try to access MariaDb in CLI without a password.

mysql -u root

If you can do that, you can then just set a password for a user.

Upvotes: 0

Related Questions