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

18 votes106 views4 answers
Foreign key mySql
SQL
5 votes113 views4 answers
Rollback to in sql
SQL
0 vote171 views1 answer
Drop view sql
SQL
12 votes145 views6 answers
Distinct in sql server
SQL
0 vote125 views1 answer
Psql show db
SQL
5 votes112 views2 answers
Oracle timestamp to date
SQL
1 vote116 views1 answer
Mysql count multiple columns in one query
SQL
6 votes122 views1 answer
Oracle pl sql source
SQL
0 vote113 views1 answer
Login failed for login due to trigger execution
SQL
3 votes109 views1 answer
Two selects in one query
SQL