Saturday, 13 May 2017

How to set root password for mysql server 0

Simply follow these two steps.

open command prompt or console. change control to in where mysql.exe is located. Mostly it will located inside mysql's bin directory.

You have to execute the following command

mysqladmin -u root password 'your_root_password'

replace 'your_root_password' with your desired password.

or simply you can run this sql command in your query window.

SET PASSWORD FOR root@localhost = PASSWORD('your_root_password');


Post a Comment