Since I run a Web server not connected to the outside world, I have
never bothered with a root password for MariaDB itself. I use the root account only on the latest reinstall. The only database I have is for
my family tree program. Suddenly, I can't access the database. I know
that they have been tightening up on passwords, and the password I
normally gave users is no longer good enough. But now it seems that I
need a password for the root user. I have looked at several HOWTO
articles on the Web, but they all throw up error messages.
Can anybody give me some guidance, please? Running Mageia 8.
On Sat, 17 Apr 2021 15:50:19 -0400, Doug Laidlaw
<laidlaws@hotkey.net.au> wrote:
Since I run a Web server not connected to the outside world, I have
never bothered with a root password for MariaDB itself. I use the root
account only on the latest reinstall. The only database I have is for
my family tree program. Suddenly, I can't access the database. I know
that they have been tightening up on passwords, and the password I
normally gave users is no longer good enough. But now it seems that I
need a password for the root user. I have looked at several HOWTO
articles on the Web, but they all throw up error messages.
Can anybody give me some guidance, please? Running Mageia 8.
As root run "systemctl start mysqld.service" and "mysql_secure_installation".
Just press enter at each of the prompts except the one to set a new
password
for root. Note this is the mysql/mariadb root account, not the linux
root account
that the password is being set for.
Regards, Dave Hodgins
On 18/4/21 6:07 am, David W. Hodgins wrote:
As root run "systemctl start mysqld.service" andThanks, Dave. That worked like a charm, as they say, and it was much
"if".
Just press enter at each of the prompts except the one to set a new
password
for root. Note this is the mysql/mariadb root account, not the linux
root account
that the password is being set for.
Regards, Dave Hodgins
more straightforward than the online solutions. At least one of those
seemed to be out of date.
On Sun, 18 Apr 2021 09:09:18 +1000, Doug Laidlaw wrote:
On 18/4/21 6:07 am, David W. Hodgins wrote:
As root run "systemctl start mysqld.service" andThanks, Dave. That worked like a charm, as they say, and it was much
"if".
Just press enter at each of the prompts except the one to set a new
password
for root. Note this is the mysql/mariadb root account, not the linux
root account
that the password is being set for.
Regards, Dave Hodgins
more straightforward than the online solutions. At least one of those
seemed to be out of date.
Be aware that those "online solution" are for resetting a forgotten
password. Also those instructions depend on what version of mariadb
you running,
I have not tested if mysql_secure_installation will let you
change password if you have forgotten current password.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 89:42:15 |
Calls: | 6,496 |
Calls today: | 7 |
Files: | 12,100 |
Messages: | 5,277,448 |