Project 6 - 1 Download and Install MySQL Administrator on Windows


Project 6 “1 Download and Install MySQL Administrator on Windows

In this project, you will download MySQL Administrator and install it on your Windows machine. 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

  1. Open a web browser and go to the MySQL AB web site for downloading MySQL Administrator: http://www.mysql.com/downloads/administrator.html.

  2. Click the Pick a mirror link under the Windows downloads section.

    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.

  3. Pick a mirror site close to your location and click the accompanying HTTP or FTP link to download the .zip file and save it to your hard disk. Once the file download is complete, you may close your browser if desired.

  4. Go to the directory where you saved the .zip file and open it using your ZIP program. When your ZIP program opens, you can either install the downloaded program from inside the ZIP program, using temporary directories, or extract it to a file, and then install from there.

  5. Double-click the Setup.exe file. After the initial preparing to install message, you will see the Welcome screen of the MySQL Administrator InstallShield Wizard.

  6. Click the Next button to proceed with the installation. The License Agreement window appears. Click the radio button to agree to the terms of the license.

  7. Click the Next button. The next window, titled Readme Information, supplies a URL (http://bugs.mysql.com) for reporting any bugs found. Make a note of this address (or mark this page in this book).

  8. Click the Next button. The Destination Window appears next. It allows you to install MySQL Administrator in another directory, if necessary.

  9. If you want to use another directory, click the Change button and browse for a more appropriate location. Otherwise, leave the default destination folder. Click the Next button to proceed to the Setup Type window.

  10. Unless you have overriding factors that prompt you to require a Custom installation, click the Typical radio button, and then click the Next button to proceed to the Ready to Install the Program window.

  11. If the information displayed is not correct, use the Back button to correct it. When the information displayed is correct, click the Install button, The InstallShield Wizard Completed window will appear when the installation is complete.

  12. Click the Finish button to close the installation wizard.

Project Summary

In this project, you installed the MySQL Administrator program on your system. Clicking the MySQL Administrator shortcut icon placed on your system s desktop will open the program and allow you to explore the various windows discussed in the preceding sections of this module. Even though there may be some unpredictable behavior or incomplete features, because the program is still in its Alpha version, the MySQL Administrator program will allow you to view information and statistics about your MySQL Server, as well as access and edit many useful settings.

Caution  

MySQL Administrator is in Alpha release. In accordance with open source principles of development, MySQL AB has released the code to users in order to further its development process. Back up your database regularly in case of a mishap and report bugs to MySQL AB to speed improvements to this program.




MySQL(c) Essential Skills
MySQL: Essential Skills
ISBN: 0072255137
EAN: 2147483647
Year: 2006
Pages: 109

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net