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 vote352 views1 answer
What is default mysql database password in linux
SQL
1 vote347 views3 answers
How to truncate foreign key constraint table
SQL
0 vote352 views1 answer
Mysql count number of occurrences in a column
SQL
3 votes359 views2 answers
Mysql config user password
SQL
1 vote401 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
4 votes343 views1 answer
Oracle user tables
SQL
14 votes361 views3 answers
Sql trim from string
SQL
0 vote341 views1 answer
Mysql installer no packages found
SQL
3 votes396 views2 answers
How to delete git repo locally
SQL
42 votes463 views6 answers
Rename table sql server
SQL