Can't Open phpMyAdmin?

Question

Level 1

122 points

Can't Open phpMyAdmin?

I'm having a problem getting started with phpMyAdmin to open on apache, I have phpMyAdmin -2.6.4-pl1 in my /Library/WebServer/Documents and my I can get php/mysql scripts to work, but I can't seem to get phpMyAdmin to open.
need some help. fvs

Posted on Oct 4, 2005 4:31 AM

Reply

Answer 1

Bill Scott

Level 6

11,465 points

Oct 4, 2005 5:47 AM in response to FVS

Could you post the error you get?

Reply

Answer 2

FVS Author

Level 1

122 points

Oct 4, 2005 6:02 AM in response to Bill Scott

Hi Bill, Thanks for quick reply.

Not Found

The requested URL /phpmyadmin.php was not found on this server.

Apache/1.3.33 Server at frank-sorannos-computer.local Port 80

Bill even if I use localhost/phpmyadmin/ or localhost/phpmyadmin-2.6.4-pl1

it still wont open? Thanks if you can help. fvs

Reply

Answer 3

Bill Scott

Level 6

11,465 points

Oct 4, 2005 6:23 AM in response to FVS

You need to specify the url like this:

http://your.own.website/path/to/phpmyadmin/

Reply

Answer 4

Oct 4, 2005 8:31 AM in response to FVS

Hi Frank,
The URL Bill posted is like yours except that you are supposed to include the trailing slash. It's possible to configure apache to deal with its absence in some cases but the URL specification stipulates that a trailing slash is required to specify a directory.

Assuming that phpMyAdmin is like the corresponding webapp for PostgreSQL, the initial page is an index.php. Once Apache understands that you are specifying a directory, it's still necessary to configure Apache to know what files inside the directory to treat as index files. This is accomplished via the DirectoryIndex directive. Mine looks like:

<IfModule mod_dir.c>
DirectoryIndex index.html index.php
</IfModule>

Finally, I strongly recommend that you configure some sort of access control for the app as it provides access to your database.
--
Gary
~~~~
I used to work in a fire hydrant factory.
You couldn't park anywhere near the place.
-- Steven Wright

Reply

Answer 5

FVS Author

Level 1

122 points

Oct 4, 2005 8:59 AM in response to Bill Scott

Bill I tried it, Is this what you ment?
Not Found

The requested URL /Library/WebServer/Documents/phpmyadmin-2.6.4-pl1/ was not found on this server.

I'm lost. fvs

Reply

Answer 6

FVS Author

Level 1

122 points

Oct 4, 2005 10:12 AM in response to Bill Scott

Hi Bill,
Maybe this will help, See if this looks right? Also, Whats the difference

$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')

$cfg['PmaAbsoluteUri'] = 'http://www.localhost/Library/WebServer/Documents/phpMyAdmin-2.6.4-pl1/';

/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;

/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/
$cfg['blowfish_secret'] = '';

/**
* Server(s)

*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

Reply

Answer 7

AlanNYC

Level 4

1,575 points

Oct 4, 2005 2:10 PM in response to FVS

phpMyAdmin is great, but did you know about "MySQL Administrator" and "MySQL QueryBrowser"? They might be more your speed.

<http://dev.mysql.com/downloads/administrator/index.html>
<http://dev.mysql.com/downloads/query-browser/1.1.html>

These are Mac apps (also available for Windows & Linux) that provide GUI to MySQL administration and querying. You launch them just like you would Microsoft Word. You can use them to access DBs remotely or locally, so if you install them on your work computer, for example, you can use them to access your home computer.

You won't have to worry about phpMyAdmin's or Apache's configuration files, and you won't be introducing new security holes to your systems (avoidable with phpMyAdmin, but not straight forward to mere mortals). Of course, phpMyAdmin provides remote access to your databases from any computer with a web browser -- Administrator and Query-Browser won't do that.

Reply

Answer 8

Oct 4, 2005 2:18 PM in response to FVS

Hi Frank,
If I may be so presumptuous, no, I think Bill meant

http://localhost/phpmyadmin-2.6.4-pl1/

You might try:

http://localhost/phpmyadmin-2.6.4-pl1/index.php

By the way, what is that hideous mess in your last post?
--
Gary
~~~~
NEVER swerve to hit a lawyer riding a bicycle -- it might be your bicycle.

Reply

Answer 9

FVS Author

Level 1

122 points

Oct 4, 2005 3:05 PM in response to Gary Kerbaugh

It worked with http://localhost/phpmyadmin-2.6.4-pl1/ But still can't see mysql databases? Just a bunch of ????? as icons.
Safari cant open the page http://www.localhost/Library/WebServer/Documents/phpMyAdmin-2.6.4-pl1/Documentat ion.html because it cant find the server www.localhost.
What next?
and that mess was
phpMyAdmin Configuration File, Which i thought might be the problem
Thanks Guy's and Thank you for help. fvs

Reply

Answer 10

FVS Author

Level 1

122 points

Oct 4, 2005 3:30 PM in response to AlanNYC

Thanks AllenNYC,
I did go there and it's on my desktop now all I have to do is learn how to use it. Is there a tutorial on MYSQL Administrator and MYSQL Query
Browser? Thanks alot for that tip. fvs
PS Thanks Mac Guy's.

Reply

Answer 11

AlanNYC

Level 4

1,575 points

Oct 4, 2005 8:47 PM in response to FVS

I would check the MySQL.com site.

Like phpMyAdmin, they both require just a little bit of familiarity with MySQL in general. If it all sounds Greek to you, you might want to Google for "MySQL tutorial" or something to get you going. There's also a great "Dummies" book on MySQL & PHP.

Reply