Friday, November 26, 2010
Wednesday, November 17, 2010
Installation of mysql, required php libraries and phpmyadmin at centOS
Here are the steps which I have followed:
/*************************************************commands***************************/
yum install mysql-server mysql
To start mysql server type the following command:
chkconfig mysqld on
/etc/init.d/mysqld start
Type the following command to setup a password for root user:
mysqladmin -u root password NEWPASSWORD
Test mysql connectivity
Type the following command to connect to MySQL server:
$ mysql -u root -p
/************************************************* end commands***************************/
/************** required commands for phpmyadmin**************************/
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt
cd /tmp
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
yum install php-mysql php-mbstring php-mcrypt phpmyadmin
/************** required commands**************************/
/**** changess to access phpmyadmin from not just localhost***/
Run command "mysql_secure_installation"
vi /etc/httpd/conf.d/phpmyadmin.conf
Comment as:
#
# Web application to manage MySQL
#
#<Directory "/usr/share/phpmyadmin">
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#</Directory>
Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin
Edit phpmyadmin config
vi /usr/share/phpmyadmin/config.inc.php
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
Then we create the system startup links for Apache and start it:
chkconfig --levels 235 httpd on
/etc/init.d/httpd start
/**** end changess to access phpmyadmin from not just localhost***/
Enjoy Programming!!!
/*************************************************commands***************************/
yum install mysql-server mysql
To start mysql server type the following command:
chkconfig mysqld on
/etc/init.d/mysqld start
Type the following command to setup a password for root user:
mysqladmin -u root password NEWPASSWORD
Test mysql connectivity
Type the following command to connect to MySQL server:
$ mysql -u root -p
/************************************************* end commands***************************/
/************** required commands for phpmyadmin**************************/
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt
cd /tmp
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
rpm -ivh rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
yum install php-mysql php-mbstring php-mcrypt phpmyadmin
/************** required commands**************************/
/**** changess to access phpmyadmin from not just localhost***/
Run command "mysql_secure_installation"
vi /etc/httpd/conf.d/phpmyadmin.conf
Comment as:
#
# Web application to manage MySQL
#
#<Directory "/usr/share/phpmyadmin">
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#</Directory>
Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin
Edit phpmyadmin config
vi /usr/share/phpmyadmin/config.inc.php
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
Then we create the system startup links for Apache and start it:
chkconfig --levels 235 httpd on
/etc/init.d/httpd start
/**** end changess to access phpmyadmin from not just localhost***/
Enjoy Programming!!!
Subscribe to:
Posts (Atom)