Wednesday, April 10, 2013

Changing MySQL root password

  1. Launch a command-prompt. 
  2. Navigate to the bin folder of your MySQL installation.
    (e.g. C:\Program Files\MySQL\MySQL Server 5.6\bin)
  3. Start the MySQL command-line interface via
    mysql -u root -p 
  4. You will be prompted to type your existing root password.
  5. After a successful login you should see a prompt saying 'mysql>'. 
  6. Enter following command to change password
    SET PASSWORD FOR root@localhost=PASSWORD('new_passw_goes_here');
  7. Volia!

No comments:

Post a Comment