Project 6 - 2 Download and Install MySQL Administrator on Linux

Project 6 “2 Download and Install MySQL Administrator on Linux

In this project, you will download MySQL Administrator and then install it on a machine running the Linux OS. The functions that allow you to monitor your system s health will be useful in choosing whether to change your database settings and to check things like peak usage. The user administration function gives you a quick overview of your database s users and their privilege settings, which makes administration more convenient and less time-consuming . You can also use MySQL Administrator to start and stop the MySQL server. Many MySQL Administrator functions will become clear only as your grasp of and experience with MySQL grows over time. Some options are so specialized you may never need them, but should the need arise, MySQL Administrator gives you quick and easy access to them without having to look up the command-line syntax.

Step by Step

Open a browser and go to http://www.mysql.com/downloads/administrator.html. Scroll down to Linux downloads and click the Pick a mirror link.

Choose the closest mirror site and click the HTTP or FTP link. Download the taz.gz file to /usr/local/src. Once the file download is complete, you may close your browser if desired.

Note	The MySQL Administrator program is in the Alpha stage, and as such, there is only one version available, but if there are multiple versions to choose from, select the one marked (Recommended) or failing that, the newest version.

Open a command-line window and change directory to /usr/local/src. The file you downloaded should be named something like mysq-administrator-1. x . xx -linux.tar.gz. tar.
Change directory to /usr/opt (where the FAQ.txt on MySQL Administrator suggests installing the program) and untar and install the file, using the following command (replace the instances of the letter x in the version identifier with the corresponding numbers in the file you downloaded).
```
 tar -xzvf /usr/local/src/mysql-administrator-1.  x  .  xx  -linux.tar.gz.tar 
```

Start the program by running the following command.

 /opt/mysql-administrator/bin/mysql-administrator

Fill in the Username, Password, and Hostname fields in the MySQL Administrator window that pops up, and then click the Connect button to open the GUI and connect it to your server.

Project Summary

Even though there may be some unpredictable behavior or incomplete features because the program is still in its Alpha version, MySQL Administrator will allow you to view information and statistics about your MySQL Server, as well as access and edit many useful settings; however, MySQL does not recommend using it in a production environment at this time.