MySQL AB also offers their own GUI tools, available (as usual) under their dual-license model. See http://www.mysql.com/products/tools/.
Administrator is similar to phpMyAdmin, and is under rapid development.
Download and install the Administrator.
Download the RPM file and use the GUI interface to install it.
You will then need to run MySQL Administrator with this command:
The Query Browser gives you a terrific application for developing and optimizing queries.
Download and install the Query Browser.
The Migration Toolkit is extremely valuable for moving existing databases from proprietary platforms to MySQL.
This interesting application is in the alpha development stage. Keep track of it at http://forums.mysql.com/list.php?113 . It promises to bring many “Access-like” features to MySQL, including a relationships-diagraming utility.
Navicat offers terrific management tools, including backup and restore functionality, data import and transfer, scheduled tasks and a report builder.
Visit http://www.navicat.com/ and take the Feature Tour.
My personal favorite MySQL GUI administration tool is phpMyAdmin (http://www.phpmyadmin.net/home_page/).
This is a web-based application that you’ll install on your web server (or your ISP’s server – yes, you can do this).
Download and install this tool in a subfolder of your web root.
tar -zxvf phpMyAdmin-<version>.tar.gz
• Move this package to your web root (/var/www/html/ in most cases):
mv phpMyAdmin-<version> /var/www/html/
• Rename this directory to something useful, like admin:
mv phpMyAdmin-<version> admin
• Descend into this directory:
• Copy the admin/libraries/config.default.php file to admin/config.inc.php:
cp libraries/config.default.php config.inc.php
• Now edit this file and set up host name, user name, and password.
Now go to your local host’s web site.
• Is your web server running? Do you need to configure anything? Where do you do this?
• Do you get any errors?
• Is php installed? (How do you check?)
• If it is, but you still get an error, what other package will you need to install? (Hint: check installed packages in the Fedora 4 GUI.)
• If you need to, install any other necessary packages.
See the documentation at http://www.phpmyadmin.net/documentation/.
U. Washington provides some nice installation notes at http://www.washington.edu/computing/web/publishing/phpmyadmin.html.
I’m providing two template files, htaccess and htpasswd, so you can build your own password-protection files. Copy them into your admin/ folder, then rename them so that each has a dot at the beginning of its name (making it a hidden file): .htaccess and .htpasswd.
Next, generate a password file using htpasswd. Run the program from the command line, with the user you want to add:
Then you’ll need to update the path to your admin/ folder in the .htaccess file.
For further information about htpasswd, issue the command: