Results 1 to 1 of 1
Thread: Installing phpMyAdmin manually
08-05-2011, 03:37 PM #1
- Join Date
- Aug 2011
Installing phpMyAdmin manually
This guide will help you install phpMyAdmin into your server and discuss some of the more popular ways of configuring it to operate.
The first step is to download phpMyAdmin. The current version as of the time of this writing can be found at:
Download phpMyAdmin from SourceForge.net
You can download the newest version from this page:
phpMyAdmin - Download
When you download the file, place it into it’s own directory on your server. I personally prefer a folder called ‘myadmin’ inside my website’s root directory. Go ahead and untar/gunzip the file:
# tar zxvf phpMyAdmin-*.gz
Move the contents of your unzipped folder to the current so ‘myadmin’ is the root folder:
# mv phpMyAdmin-*/* .
Create the config file and set the ownership to your apache webserver. Please note that you will want to change the user & group below to match what your Apache runs as.
# touch config.inc.php ; chown apache:apache config.inc.php
Next you will want to create a temporary folder to store uploads of databases. Again you will want to replace the user & group with that of your Apache server.
# mkdir tmp ; chown apache:apache tmp
Next create a mySQL username, password, and database for phpMyAdmin to use for advanced features.
Using your favorite editor, open the file config.inc.php. You will want to add the following as contents, modifying it as stated below:
//You’ll want to replace your blowfish_secret with a random sequence of letters and numbers.
$cfg['blowfish_secret'] = ’441b523f1c6c00.312729902′;
//This is the address to your mysql server. In most cases this should be left alone.
$cfg['Servers']['host'] = ‘localhost’;
//This is the extension that phpmyadmin will use to communicate with your mysql server.
$cfg['Servers']['extension'] = ‘mysql’;
//This is the absolute path to your mysql.sock file
$cfg['Servers']['socket'] = ‘/var/lib/mysql/mysql.sock’;
//You will want to leave this at socket unless you are connecting to a remote mysql server
$cfg['Servers']['connect_type'] = ‘socket’;
$cfg['Servers']['compress'] = true;
//This is your root mysql username
$cfg['Servers']['controluser'] = ‘phpmyadmin’;
//This is your root mysql password
$cfg['Servers']['controlpass'] = ‘myadmin4ogr’;
$cfg['Servers']['auth_type'] = ‘cookie’;
//This is the mySQL database that you have set aside for phpMyAdmin to use
$cfg['Servers']['pmadb'] = ‘phpmyadmin’;
//You’ll want to leave the rest of these options alone as they are related to the phpMyAdmin database.
$cfg['Servers']['bookmarktable'] = ‘pma_bookmark’;
$cfg['Servers']['relation'] = ‘pma_relation’;
$cfg['Servers']['table_info'] = ‘pma_table_info’;
$cfg['Servers']['table_coords'] = ‘pma_table_coords’;
$cfg['Servers']['pdf_pages'] = ‘pma_pdf_pages’;
$cfg['Servers']['column_info'] = ‘pma_column_info’;
$cfg['Servers']['history'] = ‘pma_history’;
$cfg['UploadDir'] = ‘tmp’;
$cfg['SaveDir'] = ‘tmp’;
$cfg['GD2Available'] = ‘auto’;
Once you are done modifying this, merely save the config file and pull up your phpMyAdmin site and log in!