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