MySQL

 
 
MySQL is a fast, multi-threaded, multi-user open source SQL database server.

The MySQL database is released under the GNU General Public License (GPL). MySQL can be used for free when you are not distributing any part of the MySQL system. For example: If you run a commercial web site using the MySQL Database Software as long as MySQL is not distributed.

Please read the MySQL manual for situations where a commercial license is needed.

More information about MySQL can be found at: https://www.mysql.com

MySQL online manual can be found at: https://dev.mysql.com/doc/index.html

The latest MySQL version can be downloaded from: https://dev.mysql.com/downloads/index.html







Installing MySQL Control Center 0.9.4.



Information
MySQL Control Center is a graphical client to administer MySQL and data.

Operating system used
Windows XP Home Edition Version 5.1 SP 2

Software prerequisites
MySQL 3.23 or higher

Procedure
  1. Download and unzip mysqlcc-0.9.4-win32.zip from:
    http://sourceforge.net/project/showfiles.php?group_id=66393

  2. Execute setup.exe to install MySQL Control Center on your computer.

  3. Select the destination folder "mysqlcc", e.g.: C:\Tools\mysqlcc

  4. Start MySQL server (if not started already):
    C:\..\mysql\bin>winmysqladmin

  5. Start MySQL Control Center.

    MySQL control center

  6. The SQL queries are default limited to 1000 records. You can change this as follow:

    • Right click the server and select edit.

      MySQL control center edit

    • The General tab is displayed.

      MySQL control center general tab

    • Select tab "MySQL Options" and increase the value "Automatically limit SELECT queries to".

      MySQL control center options tab