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 vote233 views1 answer
Postgres can integer fields be negative
SQL
0 vote213 views1 answer
Do postgresql
SQL
3 votes215 views4 answers
Order by desc postgres
SQL
0 vote205 views1 answer
Events not working db
SQL
1 vote213 views1 answer
DATE_SUB postgres
SQL
0 vote214 views1 answer
Select all tables linked server sql
SQL
0 vote234 views1 answer
Add mysql database to power bi web
SQL
15 votes213 views4 answers
How to get all tables in sql
SQL
0 vote215 views1 answer
Oracle list subpartitions
SQL
21 votes221 views5 answers
Oracle all tables
SQL