Menu
01101110 01100101 01110100 01110111 01101111 01110010 01101011 01100001 01100100 01101101 01101001 01101110 01110100 01101111 01101111 01101100 01110011 00001101 00001010

Background

Manage Engine

Our readers provide the funding for our platform, and we may receive a commission when you make a purchase using the links on our site.

Using phpMyAdmin to Administer MySQL on Red Hat 8.0

/ May 11, 2018 — Database

One excellent MySQL administration tool is phpMyAdmin. The installation is straightforward, just extract and follow Documentation.txt. One gotcha is that it requires an Apache server with php support, and MySQL, of course. It is fairly easy to install Apache and MySQL, but getting everything installed in the right order to run a PHP web site is a little tricky. Here is the correct order of RPMs:

gd-1.8.4-9.i386.rpm
MySQL-3.23.54a-1.i386.rpm
MySQL-client-3.23.54a-1.i386.rpm
MySQL-shared-3.23.54a-1.i386.rpm
httpd-2.0.40-8.i386.rpm
php-4.2.2-8.0.5.i386.rpm
php-mysql-4.2.2-8.0.5.i386.rpm

We used the MySQL RPMs direct from MySQL AB. The rest of the RPMs came right off of the Red Hat 8.0 CDs. Be warned that there have been a lot of PHP, Apache, and even some MySQL security issues lately. It is a good idea to subscribe to your favorite security lists and monitor the PHP, Apache, and MySQL AB websites often. Here is a graphic of phpMyAdmin running. The documentation warns you, but make doubly sure that you secure the directory you run phpMyAdmin in, especially if it is on a public server. In addition to securing the directory, it is a good idea to disable access via the filesystem when you aren’t using it.

Information

About