Install the software:

# yum -y install mysql mysql-server php-mysql httpd php phpmyadmin

Create link from the DirectoryRoot of the webserver to PhpMyAdmin:

# cd /var/www/html
# ln -s /usr/share/phpMyAdmin

Make sure the services are started at boot time:

# chkconfig httpd on
# chkconfig --add mysqld
# chkconfig mysqld on
# service httpd start
# service mysqld start

Set the root password for mysql:

# mysqladmin -u root password root

Make additional security-related changes to mysql:

# mysql -u root -p
mysql> DROP DATABASE test; [removes the test database]
mysql> DELETE FROM mysql.user WHERE user = ''; [Removes anonymous access]

Following the above steps, the document root for Apache is /var/www/html/. Create a test PHP script (such as phpinfo.php) and place it in the document root. A useful test script sample:

<?php
   phpinfo();
?>

Test with a brower: http://hostname/phpinfo.php

Create a database:

mysql> create database testdb

Add the following to /etc/httpd/conf/httpd.conf:

<Directory "/usr/share/phpMyAdmin">
   Order allow,deny
   Allow from all
</Directory>

Set the ServerName entry to hostname:80

Add "index.php" to the DirectoryIndex entry, so the webserver also recognizes index.php as an index file.

Restart the http server:

# service httpd restart

Test with a browser: http://hostname/phpMyAdmin/



If you found this useful, here's more on the same topic(s) in our blog:

• EMC and MPIO
• Install Python version 3 on Red Hat / CentOS
• Yum
• Preventing Gnome's initial setup
• IP address service processors