Page 1 of 1

[SOLVED] phpmyadmin problems

Posted: Wed Aug 31, 2005 9:47 am
by Bill H
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:

Code: Select all

$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?

Posted: Wed Aug 31, 2005 9:55 am
by feyd
those often require root level access to the server tree, which you very likely don't have. Sorry.


Moved to Databases. :?

Posted: Wed Aug 31, 2005 10:14 am
by Bill H
1. I don't know what that means
2. Why don't I have it? I am supposed to be able to access the db, aren't I?

Posted: Wed Aug 31, 2005 10:29 am
by feyd
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.

Posted: Wed Aug 31, 2005 10:30 am
by Chris Corbyn
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.

EDIT | Forget that :P I go with feyd's comment

Posted: Wed Aug 31, 2005 11:46 am
by Bill H
Found the problem. it was this dtring right here in the config.inc.php file:

Code: Select all

$cfg['PmaAbsoluteUri'] = 'http://www.mydomain/phpmyadminpath/';
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.)

Posted: Wed Aug 31, 2005 12:15 pm
by feyd
I remember that bastard of a setting... silly thing it was...

Posted: Wed Aug 31, 2005 1:28 pm
by Bill H
tsk, tsk, tsk, feyd

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. ???

Posted: Wed Aug 31, 2005 1:43 pm
by feyd
I don't see why not ;)