How to check xampp mysql password

Open the file C:\xampp\phpMyAdmin\config.inc.php in your favorite text editor. Search for the string:

$cfg\['Servers'\]\[$i\]['password'] = ''; and change it to like this, 
$cfg\['Servers'\]\[$i\]['password'] = 'password'; Here the ‘password’ is what we set to the root user using the SQL query.
$cfg['Servers'][$i]['AllowNoPassword'] = false; // set to false for password required
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // web cookie auth

Source: stackoverflow.com

Similar codes

2 votes210 views1 answer
Docker run postgres locally
SQL
0 vote200 views1 answer
How to check which sp is running in sql server
SQL
2 votes243 views1 answer
Remove foreign key constraints in postgres
SQL
24 votes202 views5 answers
Sql server insert into select
SQL
0 vote214 views1 answer
Postgresql isnull with max
SQL
0 vote211 views1 answer
Renommer table sql
SQL
0 vote207 views1 answer
How to reset the database value in SQL server
SQL
3 votes210 views2 answers
Monthname sql
SQL
4 votes244 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote319 views1 answer
SQL query to verify the size of the table
SQL