 
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.
|
