Guide install phpmyAdmin on Centos 6

Guide install Phpmyadmin on Centos 6
Hello everybody Today we learn how we can install phpmyadmin and mysql php5 and Apache on System Centos linux.. before we open phpmyadmin we need install Apache and php5 and after mysql phpmyadmin.. we start!!
step1 install Apache for install we need inside to root and Beginner with to install

Code:


su -
sudo yum install httpd mod_ssl
sudo /etc/init.d/httpd start


if you see Error like that

Code:


Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name,
using 127.0.0.1 for ServerName


open httpd.conf

Code:


sudo nano /etc/httpd/conf/httpd.conf


and set your ServerName ip and port like that

Code:


ServerName 10.0.0.1:80


and after you did that save and write reload

Code:


sudo /etc/init.d/httpd reload
sudo /sbin/chkconfig httpd on


after you install Apache you can inside to your ip and see the Apache its work

Step2
install php5

Code:


sudo yum install php-common php-gd php-mcrypt php-pear php-pecl-memcache php-mhash php-mysql php-xml
sudo /etc/init.d/httpd reload


step3 install mysql

Code:


sudo yum install mysql-server
sudo service mysqld start
sudo /usr/bin/mysql_secure_installation
sudo chkconfig mysqld on


if you not have in iptables the port 3306 and you dont know how you can open that then you need inside to iptables and copy

Code:


nano /etc/sysconfig/iptables
-I INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
service iptables restart


After you inside this port you can back to iptables and see you have there mysql its look like this

then you can continue with mysql

Code:


/usr/bin/mysql -u root -p
mysql -p -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass');
FLUSH PRIVILEGES;
exit


then after you need restart and reload your mysql

Code:


sudo service mysqld reload
sudo service mysqld restart


Now you need set your password with root then this look like that

then after you can see userhost with password also you need remaining in mysql with commands on mysql

Code:


SELECT User, Host, Password FROM mysql.user;


also you can create new name in database

Code:


CREATE DATABASE KISHORIT;
SHOW DATABASES;
DROP DATABASE mIRCx;


when you create new database and you want remove you used with the drop database

step4
install phpmyadmin
now we can install phpmyadmin

Code:


yum list phpmyadmin
yum install phpmyadmin


after you install phpmyadmin you have question if install that or not like this


and after install you can see all php its complete you need start httpd

Code:


services httpd start


if you see problem like this and you can`t inside to your phpmyadmin

Code:


iptables -L
iptables -I INPUT 4 -m state --state NEW -p tcp --dport 80 -j ACCEPT
service iptables save
service httpd graceful


after you doing commands you can see you select more options to iptables you can look new state http

then after you can try inside your phpmyadmin

more something Important if you have in your home some computer and you try inside to phpmyadmin from other computer and you see problem like this

then inside to phpmyadmin.conf

Code:


nano /etc/httpd/conf.d/phpMyAdmin.conf


if you see i select more ip under 127.0.0.1 then this mean if you used with some computer you can set some ip....
Good luck
Guide By mIRCx IRC
www.mIRCx.co.il
mIRCx the old Community