Reset the MySQL password



You forgot your MySQL password. No problem, you can recover it easily. Stop the MySQL service with
# /etc/init.d/mysql stop
…and restart it without a password:
# mysqld_safe –skip-grant-tables &
You’ll get an output similar to [1] 5958. Now press Enter and type the following one after the other:
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql restart

It’s all done now and you should be able to login with the new password.

Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

3 comments:

madin said...

Founded in 1905, fake rolex uk watches have been at the forefront of innovation for over a century. The first certified chronometer, fake rolex datejust the first self-winding wristwatch and the first effective water resistant case are milestones of Rolex design. Today, the Rolex brand is instantly recognizable as a symbol of prestige, luxury, and innovation across the globe. Buying a Rolex watch means you’re purchasing a piece of horological history. Here, we have an extensive catalog of exceptional used Rolex watches for sale.

madin said...

fausses rolex cellini montres
fausses rolex cosmograph daytona montres
fausses rolex datejust montres
fausses rolex day date montres
fausses rolex explorer montres
fausses rolex gmt master ii montres
fausses rolex lady datejust montres
fausses rolex milgauss montres
fausses rolex oyster perpetual montres
fausses rolex sea dweller montres

Himah Hamih said...

Great explanation with clear solution. Thanks for sharing!

online internship
online internships
watch internship online
online internship for students
the internship online
online internship with certificate
online internship certificate
python online internship
data science online internship

Post a Comment

Popular Posts