Unable to reset mysql password in Fedora 16
I have just installed mysql on a fedora 16 box and its asking me for a password. When i press the enter key it says access denied.
When googling this issue..persons said i could try
End mysql process and starting it with
-mysqld_safe --skip-grant-tables &
Then going into mysql with
mysql -u root
4. use mysql database
5. use the following query
update user set password=PASSWORD('new password') where user=root
6 Now flush the privileges and quit
7. stop mysql
8. Now restart mysql in normal mode
I was actually able to create a password in safe mode....however after i flushed the privileges and restarted mysql...the password i created doesnt work...could it be the my.cnf file?