change mysql password

  • Click Start from the toolbar
  • Click “Run”
  • Type “cmd” and press “Enter”
  • Browse to your xampp directory
  • Change the directory to xampp\mysql\bin. (Ex: I have installed it on my E:\ so browse to the directory E:\xampp\mysql\bin)
  • Type “mysqladmin -u root password NEWPASSWORD”

Your password for the mysql will be changed.
change mysql password to null

  • Click Start from the toolbar
  • Click “Run”
  • Type “cmd” and press “Enter”
  • Browse to your xampp directory
  • Change the directory to xampp\mysql\bin. (Ex: I have installed it on my E:\ so browse to the directory E:\xampp\mysql\bin)
  • Type “mysql -u root -p PASSWORD”. The prompt will change to mysql>
  • Type “use mysql”. “The database will be changed to mysql”
  • Type “update user set password=PASSWORD(“””) where User=’root’;
  • Type “flush privileges;”
  • Type “quit”

Your password for the mysql will be set to null.

Advertisements
change mysql password

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s