Page 1 of 1

Login into mysql using NOT root user [Answered]

PostPosted: 24. February 2012 20:21
by 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

Re: Login into mysql using NOT root user

PostPosted: 24. February 2012 21:26
by 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

Re: Login into mysql using NOT root user

PostPosted: 25. February 2012 09:00
by johanericka
Altrea wrote: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 :D
i'll try it later