Linux – thesql (mariadb) ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

linuxmariadbMySQLpasswords

I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked for the password. When I try to login without a password (or a blank password), I get the Access denied for user 'root'@'localhost' error.
I tried uninstalling the package completely by

sudo apt-get remove mariadb-server
sudo apt-get purge mariadb-server

When I reinstalled, I still didn't get asked for the root password.

I tried the mysqld --skip-grant-tables approach from
mysql how to fix Access denied for user 'root'@'localhost' .
I can modify the password for the root user in the mysql database – at least the hash value changes – but I still cannot login with the new password after a restart of the mysql-server. I still get the same error.

The user debian-sys-maint does not exist. So, I cannot use it to fix anything.

Any ideas what else I could try?

Best Answer

You need to reset the password. so for that

sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
exit;

Related Solutions

Thesql how to fix Access denied for user ‘root’@’localhost’

Follow the steps below.

Start the MySQL server instance or daemon with the --skip-grant-tables option (security setting).
```
$ mysqld --skip-grant-tables
```

Execute these statements.

$ mysql -u root mysql
$mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';
$mysql> FLUSH PRIVILEGES;

If you face the unknown field Password error above use:

update user set authentication_string=password('my_password') where user='root';

Finally, restart the instance/daemon without the --skip-grant-tables option.
```
$ /etc/init.d/mysql restart
```

You should now be able to connect with your new password.

$ mysql -u root -p

Enter password: my_password

Fix for MySQL “Unable to lock ibdata1” error

sudo mv /usr/local/mysql/data/ibdata1 /usr/local/mysql/data/ibdata1.bak
sudo mv /usr/local/mysql/data/ib_logfile0 /usr/local/mysql/data/ib_logfile0.bak
sudo mv /usr/local/mysql/data/ib_logfile1 /usr/local/mysql/data/ib_logfile1.bak
sudo cp -a /usr/local/mysql/data/ibdata1.bak /usr/local/mysql/data/ibdata1
sudo cp -a /usr/local/mysql/data/ib_logfile0.bak /usr/local/mysql/data/ib_logfile0
sudo cp -a /usr/local/mysql/data/ib_logfile1.bak /usr/local/mysql/data/ib_logfile1
sudo /etc/init.d/mysql restart

Fresh Installation of MySql: Access denied for user ‘root’@’localhost’ (using password: YES) (MacOS)

Just type this in the terminal:

sudo -i

You'd be taken to the root terminal and then access the databases with the command

mysql -u root

That's it now do whatever you want to do.

Best Answer

Related Solutions

Thesql how to fix Access denied for user ‘root’@’localhost’

Fix for MySQL “Unable to lock ibdata1” error

Fresh Installation of MySql: Access denied for user ‘root’@’localhost’ (using password: YES) (MacOS)

Related Question