4th Aug
How to set password to your root user in XAMPP
Post By admin | Find Under: PHP
By default XAMPP has no password to it’s ‘root’ user but we can set password for this user by the following steps:
1. Open phpmyadmin
2. Click on SQL tab
3. Copy & paste the following query:
UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE
User=’root’;
FLUSH PRIVILEGES;
4. Refresh the page & will get an error message
Modifying phpMyAdmin config file:
1. open xampp installation path / phpmyadmin / config.inc.php
2. Search for the string $cfg['Servers'][$i]['password'] = ”;
3. it will be like: $cfg['Servers'][$i]['password'] = ‘password’;
Here the ‘password’ is what we set to the ‘root’ user using the SQL
query.
4. Chnage the line:
$cfg['Servers'][$i]['auth_type'] = ‘config’;
to
$cfg['Servers'][$i]['auth_type'] = ‘http’;
5. Now all set to go. Save the config.inc.php file and restart the XAMPP server.
If you think this article is useful then you can share this post.
Leave a Reply








