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 vote120 views1 answer
Mysql record group by created date count
SQL
0 vote100 views1 answer
Oracle sysdba connect as another user
SQL
-1 vote131 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote118 views1 answer
Sql server check whether column has same equal values
SQL
1 vote110 views2 answers
T sql get foreign key
SQL
7 votes129 views2 answers
Get database size mysql
SQL
57 votes292 views5 answers
How to create a new user in postgresql
SQL
0 vote130 views1 answer
Mysql select where field is a value
SQL
2 votes121 views1 answer
Add 2 hours to current time in MySQL
SQL
6 votes130 views2 answers
Mysql interval 1 day
SQL