Unable to reset mysql password in Fedora 16

ghandizzle8 · 01-11-2013, 11:44 PM

Good Day,

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
Code:
update user set password=PASSWORD('new password') where user=root
6 Now flush the privileges and quit
Code:
flush privileges
quit
7. stop mysql
8. Now restart mysql in normal mode
Code:
/etc/init.d/mysqld start

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?

Regards,
Brian Hall

tallship · 01-12-2013, 02:47 AM

Do this:

Code:

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -uroot
mysql> use mysql;
mysql> update user set password=PASSWORD("your-new-pwd") where User='root';
mysql> flush privileges;
mysql> exit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start
# mysql -uroot -p

and enter: your-new-pwd