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

1 vote316 views1 answer
Print year of a date sql
SQL
-1 vote315 views1 answer
Pl sql drop trigger
SQL
0 vote291 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote298 views1 answer
Create query in where clasue
SQL
0 vote285 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote300 views1 answer
QUERY JPQL
SQL
9 votes284 views4 answers
How to remove duplicate in sql
SQL
4 votes279 views1 answer
Mysql insert from local csv
SQL
0 vote311 views1 answer
Rails sql query converstion
SQL
0 vote307 views1 answer
Postgresql delete type
SQL