default phpmyadmin password code example

Example 1: phpmyadmin password root

-- 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;

Example 2: 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

Example 3: default password of mysql

mysql_secure_connection

Example 4: xampp mysql default username and password

if you open localhost/phpmyadmin you will find a tab called "User accounts". There you can define all your users that can access the mysql database, set their rights and even limit from where they can connect.

Tags:

Sql Example