Login into mysql using NOT root user [Answered]

[johanericka]

hi all,
noob here. sorry for stupid question
i have a curious question, is it any way to login to mysql but NOT using root account ?
i mean, can i use my own username & password ?
i can't find any "login page" in phpmyadmin

[Altrea]

Hi johanericka,

To get the login screen you need to edit the \xampp\phpMyAdmin\config.inc.php file.
Search for the "auth_type" setting and change it from "config" to "cookie"

best wishes,
Altrea

[johanericka]

Hi johanericka,

To get the login screen you need to edit the \xampp\phpMyAdmin\config.inc.php file.
Search for the "auth_type" setting and change it from "config" to "cookie"

best wishes,
Altrea

thanks for your clue
i'll try it later