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 vote131 views1 answer
Mysql check string don't have number
SQL
1 vote137 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
15 votes169 views6 answers
Drop foreign key mysql
SQL
1 vote141 views1 answer
Mysql decimal allow negative values?
SQL
2 votes124 views1 answer
Oracle sql drop column if exists
SQL
1 vote272 views3 answers
Create table from existing table in sql
SQL
4 votes140 views2 answers
Oracle unlock user
SQL
2 votes124 views1 answer
Oracle create directory
SQL
0 vote125 views1 answer
Call function sql oracle
SQL
4 votes153 views1 answer
Postgresql create table with index
SQL