How to Reset Password for root in MySQL

How to Reset Password for root in MySQL

- Go to mysql command prompt (or run in command prompt and go to mysql/bin)
- Type SET PASSWORD FOR root@localhost=PASSWORD(”);
- Type Flush Previleg;
- Done!

Advertisement

This entry was posted on Monday, February 28th, 2011 at 08:00 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Follow

Get every new post delivered to your Inbox.