Re: After install, how to retrieve the root temporary password

[Jean-Louis Matéo]

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

Regards
Jean-Louis Matéo