Can't change blank root password for MariaDB
by FrederikSchack from LinuxQuestions.org on (#52T82)
Hi,
I have a new install of OpenSUSE and I'm a newbie in Linux.
It comes with a pre-installed MariaDB, which doesn't have a root password. So I can login with 'root' and no password.
I tried to set it with:
SET PASSWORD FOR 'root' = PASSWORD('password');
But get:
ERROR 1133 (28000): Can't find any matching row in user table.
When searching online, there are many possible issues and the solutions I've tried doesn't work.
Anybody who has any clues?
I have a new install of OpenSUSE and I'm a newbie in Linux.
It comes with a pre-installed MariaDB, which doesn't have a root password. So I can login with 'root' and no password.
I tried to set it with:
SET PASSWORD FOR 'root' = PASSWORD('password');
But get:
ERROR 1133 (28000): Can't find any matching row in user table.
When searching online, there are many possible issues and the solutions I've tried doesn't work.
Anybody who has any clues?