Fixed: phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin

  • Post by Mike Dixson
  • Aug 06, 2014
post-thumb

This one had me going round the houses a bit until I the wrong permissions confirmed something to me.
Firstly the /etc/phpmyadmin/config.inc.php file is crud. For some reason this file doesn’t resemble the actual config file that you should use.
The file /usr/share/phpmyadmin/config.sample.inc.php is the format that you need for a correct phpMyAdmin configuration, so copy it to /etc/phpmyadmin/config.inc.php

Next you need to edit this config file. This isn’t the hardest of the things in the world to do if you just want the basics. You just need to edit the value for $cfg['Servers'][$i]['host']

Once you’ve done that you can then login to phpMyAdmin using your mySQL credentials and get started.
It will bitch about not having the advanced features enabled. To do this follow the blog post I did at INSTALLING PHPMYADMIN ADVANCED FEATURES ON UBUNTU

Make sure you log out and back in to pick up the changes.

Enjoy,
Mike

LATEST POST
  • Post By Mike Dixson
  • Nov 17, 2020
Using MFA for Sudo Only
  • Post By Mike Dixson
  • Jul 25, 2020
Fixed: Obelisk not working in Ableton Live
  • Post By Mike Dixson
  • Jul 20, 2020
Musical Instrument Frequency Range Chart
TAG