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 vote195 views1 answer
Sqlalchemy _in array sqlite
SQL
3 votes141 views1 answer
Oracle list privileges
SQL
0 vote152 views2 answers
Sql trigger difference between for and after
SQL
1 vote158 views1 answer
How to see all table partition in oracle
SQL
0 vote164 views1 answer
Sql query to return field name of a table
SQL
0 vote137 views1 answer
Postgresql stored procedure update table values
SQL
6 votes139 views3 answers
Update with inner join postgres
SQL
1 vote100 views1 answer
Database run
SQL
0 vote147 views1 answer
Pagination with row_number
SQL
0 vote138 views1 answer
How to find username and password in oracle 18c
SQL