MySQL Forums
Forum List  »  Install & Repo

Re: After install, how to retrieve the root temporary password
Posted by: Jean-Louis Matéo
Date: July 26, 2017 03:16AM

Hi everybody,

finally I found what was wrong.

1) The first time, i installed MySQL Server but didn't know that the password was readable inside /var/log/mysqld.log

2) I tried to enter mysql with:
shell> mysql -uroot
Prompt asked me a password. I thought it was blank--> Access denied

3) Second time i removed & re-installed MySQL Server

4) I did the same as my Step 2 and got the same message

5) Now, I know that the password is readable inside /var/log/mysqld.log (I read the doc)

6) Problem: Inside /var/log/mysqld.log I did not see any temporary password !!! Why ?
The problem is at step 3:
When MySQL server and all its files are removed from the system, /var/lib/mysql is not !
So, the next installation takes the previous environment & after restarting MySQL, mysql.log is re-created but without the temporary password.

Solution: Remove /var/lib/mysql before re-installing mysql

Now it works fine for me

Jean-Louis Matéo

Options: ReplyQuote

Written By
Re: After install, how to retrieve the root temporary password
July 26, 2017 03:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.