Let's go back to the defaults that were in place after you installed XAMPP - you did make backups of the files you edited?
Remove any edits you made in the
config.inc.php file.
How I can set a "root" password in MySQL? (method 1) from your FAQ link.
Forget method 2 because you are going to the use simple easy method 1.
Next go to the
Security page in
http://localhostClick on the link:
http://localhost/security/xamppsecurity.php <= [allowed only for localhost]
Next add your password for MySQL SuperUser: root
(
If you have set this already then just add the password you had already entered previous - after accepting the password you should get back this message:
The root password was successfully changed. Please restart MYSQL to enable these changes!).
Next Select phpMyAdmin authentication:
cookieNext Set a random password for the phpMyAdmin user 'pma':
NoFor security don't tick this box if you can always remember your root password.
(File: C:\xampp5\security\mysqlrootpasswd.txt)Finally click on the
Password changing) button and your done with this page.
(
You can return if you want to secure your xampp folder).
Now login to phpMyAdmin and accept cookies from now on from this page.
You are now the super user root and have access to all things phpMyAdmin.
The root user can only access phpMyAdmin from the localhost PC - the one XAMPP is installed on as set in the Privileges menu - this can be changed as outlined below for admin but best leave as it is.
If you want to create a user
admin that can access from outside the localhost PC (
remote access) then create this user by clicking on
Privileges button.
Click on
Add a new User.
Login Information:User name:
adminHost: type
% in the box.
Password: your choice of admin password here
Retype : repeat the above password
Click on
Check All under Global privileges.
Click on
Go.
Now you have a user
admin that can do all things root can but from a remote location or localhost.
Click on Log out from phpMyAdmin main page and login again with user
admin and the password you created for admin - if you can try from the remote location for testing.
When you created your database with a user and a password for that user then you should be able to login to phpMyAdmin using the database username and the password for that database user.
This database user will only be able to see and manipulate the database for that user - and any databases set for any user like information_schema.
Make sure that any database you want to have access from other than localhost (your PC) has the host set to any host - the % symbol - for that database user as defined in the Privileges tab.
Please post back when you get this far and give any issues that may arise with this as if you can follow the above then you will be able to do what you want.