phpmyadmin reset root password 1

phpmyadmin reset root password

-- DEFAULT: Username:root , Password: –  (none)
mysql> SET PASSWORD FOR root@localhost=PASSWORD('mypassword');
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost 
	IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

Here is what the above code is Doing:
1. SET PASSWORD FOR root@localhost=PASSWORD(‘mypassword’);
This command sets the password for the root user.
2. GRANT ALL PRIVILEGES ON *.* TO root@localhost
IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
This command grants all privileges to the root user.

Similar Posts