March 11, 2012
How to login in MySQL with a Non Root user
Question by sandbox
I have setup 2 user Uone
and Utwo
in Mysql. But when I open localhost/phpmyadmin
it logins with root user. What URL is used to login with Uone
or Utwo
user. I am running Mysql from XAMPP.
Answer by Starx
IF you had installed phpmyadmin separately, you would be asked for username and password in the startup.
Since you have a pre-installed version of phpmyadmin. You can do the following to do so.
- Find the
phpmyadmin
installation or project file - Open the file called
config.inc.php
-
Inside you will find details to change the username and password
...
$cfg['Servers'][$i]['user'] = 'Uone'; $cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type'] = 'config';