![]() ![]() ![]() Note also that XAMPP is funny about passwords - it needs to be less than 16 characters. Go to localhost/security, follow the link below the table, and it gives you an option to input the password and change to cookie authentification. If you got PHPMyAdmin as part of XAMPP (ignore this if you didn't), there's an even easier way. If it doesn't just work, you might need to restart mysql after changing root password. But uberconversion's answer won't work until PHPMyAdmin is set to use cookies. If, in Priviledges within PHPMyAdmin, the root user has no password, you probably should change that and if the config file says $cfg = true, probably best to change true to false after giving root a password.Īfter doing this, it will start using cookies and will offer a log in window when the cookie doesn't log you straight in, so from here on, uberconversion's answer should work for you when you need to switch users. (Recommended) Delete or comment out the lines that are storing your password. $cfg = 'a rAnd0m str11!11111!11!nG' Ĭhange the authentication type to cookie: $cfg = 'cookie' // DEFAULT: 'config' As the file comments say, this string is used to encrypt your password in cookie based authentication (which is what you are about to change to). (Recommended) Change the blowfish_secret to any random string. You will also see your name and password. Since you are not seeing a log-in screen, you probably have $cfg = 'config' in there, probably around line 19. if it was ever deleted or inaccessible for some crazy reason): Step 1 Open XAMPP Control Panel Step 2 Click on the Config button of the XAMPP Control panel Step 3 On the dropdown, Select phpMyAdmin (congig. ![]() Then I installed another xampp version which has PHP 5.5.x because I wanted to test a site. Initially, I had xampplite in my PC and it runs on PHP 5.3.1. There's an answer on that explains how to change this - I've included a tidied up answer based on that one here, to save time and in case something bizarre happens (e.g. XAMPP phpmyadmin : Login credentials Ask Question Asked 8 years, 8 months ago Modified 1 year, 10 months ago Viewed 1k times 0 I'm having a problem logging in to my phpmyadmin. If not, there are a couple of simple changes needed in config files. 1 It will open in notepad as shown in figure. If you got PHPMyAdmin through XAMPP, there's a really easy way to change this at the end of this answer. So, you have to open XAMPP Control Panel ->Click MySql Config->Click my.ini XAMPP control panal fig. This means it will never offer a log-in window, because it thinks it already has your details, and until you change these settings, uberconversion's answer won't work as the appropriate cookie is never used.Īfter these settings are changed to use cookies (below), you can use uberconversion's method, or, in some versions of PHPMyAmdin, there is an icon in the bar of small icons in the top left of the screen that looks like an open door with a green arrow pointing to the left (mouseover text: "Log Out"), which does the same thing slightly more conveniently. It sounds like you have the default settings, which, in most Windows packages I've seen, usually means that logging as 'root' with password '' is hard-wired into the code and ignores cookies etc. ![]()
0 Comments
Leave a Reply. |