jump to navigation

Installing phpMyadmin2.11 on CentOs 5.5 March 12, 2011

Posted by Tournas Dimitrios in Uncategorized.

PhpMyadmin is a great tool for being able to manage your Mysql database from a GUI (web-based ) . Here is how to install it onto a fresh CentOs 5.5 server . I assume that your already have Php 5.1.6 and Mysql 5.0 installed on your box (default versions from the official repositories) . Although the  default installation of Mysql-server is without a password and remote access permitted , let’s leave it as is , of course the perimeter to the Internet (router) is restricting Incoming requests to the database . An very easy way to test your LAMP installation is to create on your web-server’s root directory an index.php  file , and access it  locally through your browser  “http://localhost/index.php” .

A script to test your database connectivity could be like this :

$dbhost = 'localhost';
$dbuser = 'rooot';
$dbpass = '';
$please = mysql_connect($dbhost,$dbuser, $dbpass);
if (!$please) {
die('Could not connect: ' . mysql_error());
echo "Connected successfully to $dbhost<br>";
print "MySQL status = ".mysql_stat()."\n";

The following picture convinced us that the connection is established .

Installing PhpMyadmin :

PhpMyadmin  comes in two releases :

  1. phpMyAdmin : Version compatible with PHP 5.2 +  and MySQL 5. Currently recommended version.
  2. phpMyAdmin : Version compatible with PHP 4+ and MySQL 3+ (only this version is compatible with Php 5.1 )
  • Go to the official web site of PhpMysql and download phpMyAdmin-
  • Download the archive on your web-server’s root directory
  • now : tar  xvfz  phpMyAdmin- (this will create a directory  phpMyAdmin-
  • Rename the directory phpMyAdmin- :
    mv  phpMyAdmin-   phpmyadmin
  • That’s it . Navigate with your browser : http://localhost/phpmyadmin


No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s