Setting up PHPMyAdmin

How to setup PHP My Admin:

Download PHPMyAdmin from the home page:

cd /root/

wget http://internap.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.9.5-english.zip

cp phpMyAdmin* /var/www

cd /var/www/

unzip phpMyAdmin-2.11.9.5-english.zip

ln -s phpMyAdmin-2.11.9.5-english phpmyadmin

chown apache:apache phpMyAdmin* -R

rm -f phpMyAdmin-2.11.9.5-english.zip

Edit the create tables file , and enable the GRANT line with proper password:-

vi /var/www/phpmyadmin/scripts/create_tables_mysql_4_1_2+.sql

CREATE DATABASE IF NOT EXISTS phpmyadmin

DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

USE phpmyadmin;

Privileges

(activate this statement if necessary)

GRANT SELECT, INSERT, DELETE, UPDATE ON phpmyadmin.* TO ‘pma’@localhost identified by ‘phpsecret’;

Create PHPMyAdmin schema in MySQL server:

[root@www scripts]# mysql -u root -psecretpassword < create_tables_mysql_4_1_2+.sql

Create Apache config file for PHPMyAmdin:-

vi /etc/httpd/conf.d/phpmyadmin.conf

Alias /phpmyadmin /var/www/phpmyadmin

<Location /phpmyadmin>

Order allow,deny

Allow from all

</Location>

Create web server writable folder config in phpMyAdmin toplevel directory:

cd /var/www/phpmyadmin

mkdir /var/www/phpmyadmin/config

mkdir /var/www/imports

mkdir /var/www/exports

chown apache:apache /var/www/phpmyadmin/ -R

Now run the phpmyadmin setup script, from the browser:

http://example.com/phpmyadmin/scripts/setup.php

Once the setup starts, select secure connection.

Features-Security : Force SSL

Upload Directory: /var/www/phpmyadmin/imports

Save Directory: /var/www/phpmyadmin/exports

Configuration-Save: Save the config file.

Configuration will be saved to file config/config.inc.php in phpMyAdmin top level directory, copy it to top level one and delete directory config to use it.

[root@www phpmyadmin]# mv config/config.inc.php

[root@www phpmyadmin]# rm -fr config

Once completed. Open this URL and start using PHPMyAdmin:

https://example.com/phpmyadmin/

Each user can login using the name of his own DB user and password.

Manual steps:

[root@www phpmyadmin]# mv config.sample.inc.php config.inc.php

vi config.inc.php

$cfg[‘blowfish_secret’] = ‘secret’; YOU MUST FILL IN THIS FOR COOKIE AUTH!

Authentication type

$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;

Server parameters

$cfg[‘Servers’][$i][‘host’] = ‘localhost’;

$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;

$cfg[‘Servers’][$i][‘compress’] = false;

Select mysqli if your server has it

$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;

User for advanced features

$cfg[‘Servers’][$i][‘controluser’] = ‘pma’;

$cfg[‘Servers’][$i][‘controlpass’] = ‘phpsecret’;

Advanced phpMyAdmin features

$cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;

$cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma_bookmark’;

$cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’;

$cfg[‘Servers’][$i][‘table_info’] = ‘pma_table_info’;

$cfg[‘Servers’][$i][‘table_coords’] = ‘pma_table_coords’;

$cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma_pdf_pages’;

$cfg[‘Servers’][$i][‘column_info’] = ‘pma_column_info’;

$cfg[‘Servers’][$i][‘history’] = ‘pma_history’;

$cfg[‘Servers’][$i][‘designer_coords’] = ‘pma_designer_coords’;

That should be all !

Regards,

Kamran