Login into mysql using NOT root user [Answered]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Login into mysql using NOT root user [Answered]

Postby johanericka » 24. February 2012 20:21

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
johanericka
 
Posts: 5
Joined: 24. February 2012 20:14
Operating System: Windows 7

Re: Login into mysql using NOT root user

Postby Altrea » 24. February 2012 21:26

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Login into mysql using NOT root user

Postby johanericka » 25. February 2012 09:00

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
johanericka
 
Posts: 5
Joined: 24. February 2012 20:14
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests