tempat untuk ngetest2

reset password root mysql

Posted by: decees on: July 7, 2009

Alternatively, on any platform, you can set the new password using the mysql client (but this approach is less secure):

  1. Stop mysqld and restart it with the –skip-grant-tables option.
  2. Connect to the mysqld server with this command: shell> mysql
  3. Issue the following statements in the mysql client. Replace the password with the password that you want to use. mysql> UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) -> WHERE User=’root’; mysql> FLUSH PRIVILEGES;

You should now be able to connect to MySQL as root using the new password.

Advertisement

Leave a Reply

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

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 )

Connecting to %s

mY TweeT

  • Check out the 12 Days of Christmas app and receive a gift from iTunes every day from 26 December to 6 January. #12days---2 months ago
  • No 2 minutes silence on itv---3 months ago
  • I love Lee Evans!---9 months ago
  • Not sure how this tweeting works yet. Don't know who sees them!! Hellooooo??---1 year ago
  • Watching rugby too. Bannatyne's bol sounded yum!---1 year ago
  • Thank you for the welcomes. Been fitting my bikerack. Now the roast beef is in the oven!---1 year ago
  • Watching f1---1 year ago

RSS spinRADIO

  • An error has occurred; the feed is probably down. Try again later.
Follow

Get every new post delivered to your Inbox.