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;

Source: stackoverflow.com

Similar codes

0 vote349 views1 answer
Psql attribute cannot login
SQL
6 votes345 views2 answers
Drop foreign key
SQL
0 vote367 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote328 views1 answer
Replace \n sql
SQL
0 vote331 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote328 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote318 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
2 votes401 views2 answers
MySql FULL OUTER JOIN
SQL
11 votes368 views2 answers
How to import mysql database command line
SQL
0 vote335 views1 answer
Oracle INTERVAL DAY to second to number
SQL