Tuesday, 18 June 2013

Configure phpMyAdmin 4.2.11 on Linux.


 phpMyAdmin is a free software tool written in php, intended to handle the administration of MySQL over the web. phpMyAdmin supports a wide range of operations with MySQL. 

phpMyAdmin Installation on Linux:

(Note: First Install all the related files to run MySQL, php, Apache)

#yum install httpd*

#yum install php-mysql*
#yum install mysql-server

configure your Apache web server(if you have any problem regarding that you can look in my previous post "How to configure Apache or httpd Server")


check in the /etc/httpd/conf.d that there is php.conf file is present


start all the required services 


#service httpd start


#service mysqld start


#chkconfig httpd on


#chkconfig mysqld on


Download the latest version of  phpmyadmin Currently the stable version of phpMyAdmin is 4.2.11


After downloading it uncompressed it


#tar -xjvf php ....................... (depending upon the version u downloaded)


move this folder to your web directory in which your site is located and rename it as i have done php and open the configuration file, make changes to the settings so that you can access it via http:


#vi config.inc.php


make changes into line no. 73


73 $cfg['Servers'][$i]['auth_type']    ='http';     (enter http here in =''; line no. 73)


:wq            

(save and quite)

restart the httpd service and access it via web browser, inter in the address browser your IP/php to access.


#service httpd restart

in web browser your IP/php

If you had set any password for your mysql than use that other wise it will be blank


username: root


password: blank


If you want to know the username and password of your phpMyAdmin go to:


#vi config.inc.php


and see in line no. 74 & 75 - 


74   $cfg['Servers'][$i]['user']       ='root';              (MySQL user)


75   $cfg['Servers'][$i]['password']   ='';                 (MySQL password)


For any query please feel free to contact me my email ID is sashwatkatore@gmail.com.

No comments:

Post a Comment