[SOLVED] phpmyadmin problems

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

[SOLVED] phpmyadmin problems

Post 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?
Last edited by Bill H on Wed Aug 31, 2005 11:46 am, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

those often require root level access to the server tree, which you very likely don't have. Sorry.


Moved to Databases. :?
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Post 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.)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I remember that bastard of a setting... silly thing it was...
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Post 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. ???
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I don't see why not ;)
Post Reply