MySql resets user password after restarting mysql server

Question

Well, actually it is mariadb, but to start its client, I need to enter "mysql" in command line.

Anyway, after entering

mysql  --user=root

Note, that at this time "root" doesn't have a password, so I successfully login and then:

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

And it works, from now on I have to use "my_pass" to login.

But then I do:

sudo service mysql restart

And from now on, root's password is again reseted to "no password at all".

And again, to login I can't give any password.

Googling this doesn't help, because most articles are about "how to reset user password" :)

Yes, first I login as root to mysql(mariadb), then I restart the mysql/mariadb service as sudo. Is there another way? — konrad_firm
– konrad_firm, Commented Feb 24, 2016 at 12:46
@PhiterFernandes somebody suggested to do flush privileges and now I have error: "Incorrect information in file: './mysql/tables_priv.frm' " — konrad_firm
– konrad_firm, Commented Feb 24, 2016 at 12:57
Yeah the flush privileges would actually set the password and make it fixed. Forgot about that. — Phiter
– Phiter, Commented Feb 24, 2016 at 13:15

konrad_firm · Accepted Answer · 2016-02-24 13:04:56Z

1

Well, I managed to solve my problem - if anybody's interested you have to do:

flush privileges

After changing passwords.

answered Feb 24, 2016 at 13:04

konrad_firm

8672 gold badges11 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammed Thalha · Accepted Answer · 2024-02-22 09:32:45Z

0

I am using MacBook M2, I just uninstalled the MySQL server and then it works fine.

answered Feb 22, 2024 at 9:32

Mohammed Thalha

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

MySql resets user password after restarting mysql server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related