I have installed phpMyAdmin 2.6.3-pl1 on my server and it shows two databases in the dropdown list, the one created for me by the hosting company and one named "test." Both have a dash in parenstheses following, indicating that no tables exist. I have configured as follows:
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = myuser'; // MySQL user
$cfg['Servers'][$i]['password'] = 'mypass'; // MySQL password (only needed
When I select my db in the list nothing happens. When I select much of anything in the right panel, such as selecting a change of theme, I get a popup message that the connection was refused for 'localhost' and nothing happens.
This whole program is apparently designed to be used by someone with a whole heck of a lot more server expertise than I possess, and the phpmyadmin docs and FAQ's do not address either of these issues. Can anyone point me in the right direction?
Last edited by Bill H on Wed Aug 31, 2005 11:46 am, edited 1 time in total.
yes, you are supposed to be able to access your database, that does not mean you are allowed to change permissions of your user (hence requiring root level access)
Last time I set up phpMyAdmin, the behaviour you are seeing was indicative of it needing remote access rights for the user involved. Chaning those settings often only possible for your host to do because they don't give you root level access to the (entire) database.
It doesn't sound like a phpMyAdmin issue as much as a MySQL configuration issue. The username given by the host doesn't appear to have been set up in MySQL correctly for use at local loopback.
An article had told me that rather than my domain name I should put "localhost" in that string.
As soon as I replaced it with my actual domain name everything connected.
(In case anyone else has a similar problem and a search turns up this thread.)
By the way, there is some 5Mb of crap in the "languages" folder such as "croation..." and "afghanistani" that I seriously dounbt I will be needing. (The only language I use is English, and that sometimes poorly.) I assume all but the english files can be removed. ???