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

5 votes195 views2 answers
Ranking functions in sql
SQL
1 vote201 views1 answer
Sql server get users
SQL
8 votes195 views1 answer
Script to add datafile to tablespace
SQL
10 votes175 views3 answers
Sql limit results
SQL
0 vote218 views1 answer
"Hello User Name"
SQL
0 vote183 views1 answer
Grant privileges of databse to user
SQL
0 vote183 views1 answer
Sql find leading space
SQL
-1 vote185 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote182 views1 answer
How to find median of a column sql
SQL
4 votes205 views1 answer
Search column by name mysql
SQL