Phpmyadmin password root

-- 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

11 votes140 views2 answers
Mysql disable safe mode
SQL
0 vote128 views1 answer
Sql select duplicates based on two columns
SQL
0 vote129 views1 answer
Recover deleted data from mysql database
SQL
0 vote130 views1 answer
Apache Derby: Create SQL Dump with data
SQL
2 votes140 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote121 views1 answer
Sql right characters
SQL
0 vote130 views1 answer
Find and replace query in wordpress\
SQL
0 vote213 views1 answer
Run mysql xampp shell
SQL
9 votes124 views3 answers
Show table columns mysql command line
SQL
-1 vote141 views1 answer
Capitole toulouse
SQL