Yeah, getting phpmyadmin working was quite a pain... and I should've taken notes.
Well, as someone mentioned, it's important to know whether you have the vhosts use flag set, because if so, portage will not finish the phpmyadmin install... you have to use webapp-config to install it for specific hosts.
Assuming you don't have the vhosts use flag set, the config file should be /etc/phpmyadmin/config.inc.php. I use cookie based authentication... think that was just easiest. You also have to set the user that will connect to the db in there... well, you should read through the comments and make sure things are set to what you need.
Hmm, I don't think you said what happened when you tried to access phpmyadmin? Do you get a 404 or a php error page or ???
Oh, and not restarting mysql after running the script to load the pmadb tripped me up at least once.
Hope this helps...
Ben
Devraj Mukherjee wrote:
Tried this as well. Will now try and use socket for connections
Devraj
Devraj Mukherjee ha scritto:
Hi everyone,
I am trying to get PHPMyAdmin running to administer my MySQL tables/databases. MySQL is up and running and I can use the command line tool to login and make changes.
However PHPMyAdmin fails to login to the database server, the login details are definately correct. What do you think the reason could be?
Also where can I check for a log that gives me some further information, MySQL logs are quite worthless for this problem.
Thanks for your help in advance.
Devraj
in config.inc.php $cfg['Servers'][$i]['connect_type'] = 'tcp'; // maybe also socket
in your /etc/mysql/my.cnf check that these values are commented: #skip-networking #bind-address = 127.0.0.1
If your MySQL server and your apache server are both on the same machine you can use sockets.
cheers francesco
-- No problem is so formidable that you can't walk away from it. ~ Charles M. Schulz
