Phpmyadmin 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

Phpmyadmin first login

// in config.sample.inc.php change this to true
$cfg['Servers'][$i]['AllowNoPassword'] = false;
// in config.sample.inc.php add this 
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123';
// refresh

Similar codes

0 vote287 views1 answer
QUERY JPQL
SQL
0 vote287 views3 answers
Database restoring error
SQL
0 vote271 views4 answers
Mysql select bottom 10 rows
SQL
0 vote295 views1 answer
Sql show table name in result
SQL
0 vote275 views1 answer
Find invalid datetime field
SQL
0 vote304 views1 answer
How to check database engine in mysql
SQL
1 vote305 views1 answer
Dropping a constraint in ms sql
SQL
0 vote303 views1 answer
How to map sql column to custom names
SQL
1 vote293 views1 answer
Mysql select from outside
SQL
0 vote290 views1 answer
Mysql last 6 months
SQL