Download Phpmyadmin for Mac Os X Updated

Download Phpmyadmin for Mac Os X

phpMyAdmin Installation

Posted

on 24 October 2003 04:fifty PM

Update: phpMyAdmin is at present available pre-installed on all Genesis Class servers. To access, use the "phpMyAdmin" link in your CNC. If you have non already upgraded to Genesis Class, yous can detect a (free) upgrade pick under "Server Info" in your CNC:
http://www.FutureQuest.net/GoToCNC/

The following instructions are provided for those who wish to manually install phpMyAdmin on their FutureQuest accounts. Note that the instructions below may not be updated as ofttimes now that phpMyAdmin is pre-installed (see above).

!!! Security Bulletin !!!

FutureQuest strongly recommends password protecting ALL phpMyAdmin installations.

!!! Security Message !!!

All right, so you want to install phpMyAdmin.

First, go to http://www.phpMyAdmin.net and download phpMyAdmin.

(Annotation: The following instructions were written for phpMyAdmin version 3.v.i, which requires PHP5 and MySQL5. PHP5 is currently the default PHP at FutureQuest. MySQL5 is the default on all new packages and available by request on legacy accounts. Check the Server Info section of your CNC (Command'Northward'Control) console for your account's configuration. If you are installing a unlike version of phpMyAdmin, at that place may exist some slight changes to the instructions beneath.)

TIP: Before first this installation, make sure you take the post-obit data on mitt: proper name of the MySQL 'host' server, your username for MySQL access, and your MySQL password. Yous can detect the data for the host name and username by visiting the MySQL Business relationship Manager in your CNC (Control'N'Control) panel. If you have forgotten your MySQL countersign, you will also be able to reset it through your MySQL Account Manager. Note that doing so will change the MySQL countersign for all of your MySQL databases.

Delight besides brand certain that you take cookies enabled in your browser.

Next, unzip/untar all the files and directories. According to the directions included with phpMyAdmin (Documentation.html):
"Warning for Mac users: if you are on a Mac Bone version before Os X, StuffIt unstuffs with Mac formats. So you'll take to resave equally in BBEdit to Unix fashion ALL phpMyAdmin scripts earlier uploading them to your server, every bit PHP seems not to similar Mac-style terminate of lines character ("\r")."

Once yous have uploaded the files to the server, you will demand to configure phpMyAdmin with your specific settings. There are two ways to practise so. I is to utilize the wizard-way setup script that is included with phpMyAdmin, which will provide a graphical interface for inputting the settings (but seemed to exist a little buggy at the original fourth dimension of this writing). The other way is to create a config.inc.php file yourself, which in truth is not any more difficult and allows for some advanced features.

For the purposes of this tutorial, we will exist using the 2nd option of creating the config.inc.php file just nosotros are just going to be working with the minimum requirements. For more advanced users or those who wish to have the avant-garde features, please consult the documentation included with phpMyAdmin. Boosted back up in this expanse may also exist able to be found in the FutureQuest Community Forums:
http://www.FutureQuest.net/Forums/

To become started, yous'll demand to create a file named config.inc.php directly within your phpMyAdmin directory. (There may be a config.sample.inc.php file in there already and, if you wish, you can create a copy of it and name it config.inc.php to utilize it as a template.)

Notation: phpMyAdmin first loads libraries/config.default.php and and then overrides those values with anything constitute in config.inc.php. If the default value is okay for a particular setting, at that place is no demand to include it in config.inc.php. You'll need a few directives in your config.inc.php file though to get going and a elementary configuration may wait like this:

                          <?php $i=0; $i++; $cfg['PmaAbsoluteUri'] = 'http://example.com/pma/';  $cfg['Servers'][$i]['host'] = 'MySQL.case.com';  $cfg['Servers'][$i]['auth_type'] = 'cookie';  $cfg['blowfish_secret'] = 'Fred did 154 jumping jacks Tuesday morning!';   $cfg['Servers'][$i]['user'] = '';  $cfg['Servers'][$i]['password'] = '';  ?>

Your settings need to be entered in between the ' ' marks after the equal signs. A description of the settings follows, likewise every bit the specific changes you need to make to the above sample configuration to take information technology work on your FutureQuest hosting package:

$cfg['PmaAbsoluteUri'] = 'http://case.com/pma/'; -- supercede instance.com with your domain proper name and pma with the name of the directory that contains your phpMyAdmin files

$cfg['Servers'][$i]['host'] = 'MySQL.instance.com'; -- replace example.com with your domain name

$cfg['Servers'][$i]['auth_type'] = ''; -- dictates the hallmark method used when connecting to your phpMyAdmin installation - run across below

The options for authentication are:

cookie (recommended method)

http

config

signon

cookie and http authentication methods - These methods are considered more secure than the config method, as your username and password are not stored on the server in your configuration file.

The 'http' option uses the Apache http authentication method. The 'cookie' method uses cookies and has the reward that you tin "Log Out" at the cease of your session, deleting the cookie. The above sample config.inc.php file is based on the cookie authention style.

config method - This method requires storing your MySQL username and password in the file on the server. Therefore, if y'all cull to utilize the config option, yous will demand to be sure to password protect the directory that your phpMyAdmin files reside in as otherwise anyone who would notice the directory to your phpMyadmin installation would then be able to access your databases. This is EXTREMELY of import. Do not skip the countersign protection step if you choose the config method. For information on how to password protect directories, visit the Countersign Protection Tutorial.

$cfg['blowfish_secret'] = ''; -- used with the cookie method only. If you lot specified cookie in the auth_type higher up, type in a random phrase up to 46 characters long for this setting. This passphrase is just used internally to encrypt the password - you volition not be prompted for information technology later.

$cfg['Servers'][$i]['user'] = ''; -- MySQL username if yous are using config method - otherwise leave blank

$cfg['Servers'][$i]['password'] = ''; -- MySQL password only if y'all are using config method - otherwise leave blank

Make sure you lot don't have any blank lines at the end of the file and save information technology as config.inc.php.

Now, open your web browser and visit
http://www.example.com/pma/index.php
(supersede example.com with your domain name and pma with any directory your phpMyAdmin is in). You should see a welcome folio and, after logging in with your MySQL username and password if you used the cookie method in a higher place, you lot will be able to start working with your databases!

Of import Note: For security reasons, phpMyAdmin now recommends that all installations protect access to the ./libraries and ./setup/lib subfolders in your phpMyAdmin directory. The easiest way to do this is probably just to password protect your entire phpMyAdmin directory. For information on how to countersign protect directories, visit the Password Protection Tutorial.

!!! Remember !!! If you used the config authentication method, y'all will desire to immediately countersign protect your phpAdmin directory to secure it and forestall general admission.

FutureQuest strongly recommends password protecting ALL phpMyAdmin installations, even if using the cookie or http hallmark options, as extra protection confronting unauthorized admission.