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 vote200 views1 answer
Raise application error in oracle
SQL
1 vote260 views1 answer
Oracle grant select on schema
SQL
6 votes208 views2 answers
Sql sequence
SQL
-1 vote188 views1 answer
Add column alter table default value
SQL
0 vote209 views1 answer
Psql show db
SQL
0 vote201 views1 answer
Kill slow queries mysql
SQL
18 votes197 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote216 views1 answer
Datagrip execute procedure
SQL
2 votes202 views1 answer
Oracle list grants on procedure
SQL
1 vote206 views2 answers
Snowflake alter column data type
SQL