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://localhost
Click 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: cookie
Next Set a random password for the phpMyAdmin user 'pma': No
For 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
Click on Add a new User
User name: admin
Host: 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.