Hi i have installed phpmyadmin on my centos machine and when i try to hit phpmyadmin through my browser i get this error : First of all, you have to define an index on the foreign key column in the referring table (so foo_bar.foo_id, in your case). Phpmyadmin is just a program for accessing databases, i think your question is where are mysql databases stored?
Forbidden you don't have permission to. If you want to use phpmyadmin to set up relations, you have to do 2 things. I changed the root password to test and now i cannot login in phpmyadmin page in xampp.
Ham it works now i just refreshed the browser serveral times although i tried the same 3 hours ago but nothing happened on phpmyadmin homepage but it reacted now also it works. Maybe your problem is that you're using the usual 'root' username, and your password could be correct. In my case, the user was phpmyadmin, and my password was correct. Run services.msc from 'run command' and check mysql service.
Use lowercase 'phpmyadmin' in the url. If not resolved, check whether mysql service is started in your machine. I looked for help here and here which basically says changed config.inc.php file in xampp\\phpmyadmin.