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
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:
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
/**
* 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
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.
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.
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.
