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 vote192 views1 answer
Sql server convert date to weekday
SQL
0 vote219 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes206 views2 answers
Mysql remove only_full_group_by permanently
SQL
33 votes190 views2 answers
Postgres how to add field created at
SQL
0 vote181 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote200 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote207 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote181 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
3 votes194 views2 answers
Sqlite print all column names
SQL
3 votes199 views2 answers
Install mysql powershell
SQL