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

2 votes121 views1 answer
Oracle sql drop column if exists
SQL
3 votes128 views1 answer
Oracle revoke grant
SQL
5 votes128 views5 answers
Find max number in sql
SQL
1 vote181 views4 answers
Alter schema sql
SQL
0 vote135 views1 answer
Sql row number in result set
SQL
2 votes152 views2 answers
Mysql add hours to time field
SQL
-1 vote125 views1 answer
How to switch user in mysql
SQL
1 vote135 views1 answer
What is a Database?
SQL
0 vote161 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
8 votes146 views4 answers
How to calculate the age from date of birth in python
SQL