I have lost necessary privileges for my root user in xampp mysql.
How do I reset the privileges?
But the sites are working properly because I have other username with all permissions.
But the mysql phpMyAdmin page loads with root user as default.
Hence, I am not able to access databases from phpmyadmin.
How to reset the change the default login user name in phpMyAdmin or how to reset the permissions to the root user?
Forums
reset xamp root password
Change the root into any user name you created, and set the password of the user./* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = true;