Page 1 of 1

Login to My phpMyAdmin

PostPosted: 17. July 2015 02:54
by ed1024
I am not an expert at xampp, and this is my first time running it, I am setting up an environment for Wordpress development basically I will be designing Wordpress sites and then linking my local host to a forwarding service for clients to view in progress work. When design is complete I will upload the Wordpress site to client server. I went into localhost xampp splash page in browser and navigated to security I setup security for mysql superuser using http on one occation and cookie on the other, did a few tries, and xampp directory protection for .htaccess. I then tried to login to http://127.0.0.1/phpmyadmin/ i get a prompt to enter password, I do and I'm rejected with an error - "wrong username/password. Access denied". Futhermore I am not sure what to enter for the username field, can some please guide on this. Apache access.log, apache error.log, php_error_log and mysql_error.log have long entries.

My comp details are such:
Windows 8 64 bit running XAMPP v. 3.2.1.
Here is output from Xampp control panel:

9:34:32 PM [main] Initializing Control Panel
9:34:32 PM [main] Windows Version: Windows 8 64-bit
9:34:32 PM [main] XAMPP Version: 5.6.8
9:34:32 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
9:34:32 PM [main] Running with Administrator rights - good!
9:34:32 PM [main] XAMPP Installation Directory: "c:\xampp\"
9:34:32 PM [main] Checking for prerequisites
9:34:33 PM [main] All prerequisites found
9:34:33 PM [main] Initializing Modules
9:34:33 PM [Apache] XAMPP Apache Service is already running on port 80
9:34:33 PM [Apache] XAMPP Apache Service is already running on port 443
9:34:33 PM [mysql] XAMPP MySQL Service is already running on port 3306
9:34:33 PM [main] Starting Check-Timer
9:34:33 PM [main] Control Panel Ready

Re: Login to My phpMyAdmin

PostPosted: 17. July 2015 11:12
by Nobbie
ed1024 wrote:I went into localhost xampp slash page in browser and navigated to security I setup security for mysql superuser using http on one occation and cookie on the other, did a few tries, and xampp directory protection for .htaccess.


That was no good idea, as you see now, you cannot login anyhwere. There is no need for this "security" setup (i dont know, why it is still part of Xampp, as mostly users destroy their installation with that), simply uninstall Xampp and install again and then dont do any security setup, you dont need it for local development.

Xampp comes per default with "root" and no password for MySQL. If you want to apply a password for "root", DO NOT USE security setup as before, instead start phpmyadmin and change User "root" there.

Re: Login to My phpMyAdmin

PostPosted: 18. July 2015 20:33
by ed1024
Nobbie, thanks. Apache Friends should remove the security function from Xampp it looks to me, a sure way to confuse the user. I uninstalled xampp, but i'm testing serverpress - desktopserver solution, https://serverpress.com/get-desktopserver/ think it utilizes Xampp components. Lets see what works.