Reset MySQL password on Fedora 26

Emad R

I gave Fedora ago, instead of Centos.

And for the life of me I cannot reset the password, the reason for resetting is under Fedora 26 you dont get a blank root mysql password, you get temp password pre-created for you.

So for some reason I erased mysql-community-server package, and reinstalling it. and currently I cant get access to mysql service. cause it keeps telling me no password.

One guide previously worked and revealed the password using this command:
grep 'password' /var/log/mysqld.log |tail -1

Currently this command does not output anything, even after I reinstalled mysql and erased it.
I tried installing MariaDB same shit.
I tried:
mysqld --skip-grant-tables &
keeps telling me user root needs password

Why on Fedora they tend to change the standard.

Emad R

@emad-r said in Reset MySQL password on Fedora 26:

@emad-r

I believe I found the right answers from here.

GitHub Wnmp

So in general it says this:

user: root
password: password
That is for version 10.0.15-MariaDB, installed through Wnmp ver. 2.1.5.0 on Windows 7 x86

shareimprove this answer
answered Feb 6 '15 at 11:11

Matija Baric
8,54222925

The password is "password" now ? go figure. dont ask me how and why.

Emad R

@emad-r

I believe I found the right answers from here.

GitHub Wnmp

So in general it says this:

user: root
password: password
That is for version 10.0.15-MariaDB, installed through Wnmp ver. 2.1.5.0 on Windows 7 x86

shareimprove this answer
answered Feb 6 '15 at 11:11

Matija Baric
8,54222925

Emad R

@emad-r said in Reset MySQL password on Fedora 26:

@emad-r

I believe I found the right answers from here.

GitHub Wnmp

So in general it says this:

user: root
password: password
That is for version 10.0.15-MariaDB, installed through Wnmp ver. 2.1.5.0 on Windows 7 x86

shareimprove this answer
answered Feb 6 '15 at 11:11

Matija Baric
8,54222925

The password is "password" now ? go figure. dont ask me how and why.

Dashrender

I'll admit firstly that I don't fully understand your issue.

So you were given a temp password, but that password somehow changed to 'password'?

Emad R

@dashrender

Correct, without doing any thing. And this was the first time for 2 things:

Autogen password
password password.

back in the day, you install you get blank pass, and use mysql_secure_installation

JaredBusch

@emad-r said in Reset MySQL password on Fedora 26:

@dashrender

Correct, without doing any thing. And this was the first time for 2 things:

Autogen password

password password.

back in the day, you install you get blank pass, and use mysql_secure_installation

You still do. No idea what you did

Solved Reset MySQL password on Fedora 26