WBITT

We Bring In Tomorrows Technology

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

Setting up PHPMyAdmin

E-mail Print PDF
User Rating: / 8
PoorBest 

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

 

You are here How To / Tutorials Setting up PHPMyAdmin