Experts teach you how to install MySQL and MySQLGUITools_MySQL

Experts teach you how to install MySQL and MySQLGUITools mysqlGUI

BitsCN.com

Download and select the MySQL installation package
As MySQL has been upgrading, when you read this article, you may have provided a new official version on its official website for you to download. Therefore, the following links may fail, if necessary, go to the MySQL download page to find the latest version.
In addition, during the download process, you need to register as a network user (if you do not want to register, you can also click» No thanks, just take me to the downloads! Skip the registration step and download it directly). This is a very short process. it requires you to provide a valid Email address.
MySQL 5.0 or MySQL 5.1
MySQL 5.0 download page: http://dev.mysql.com/downloads/mysql/5.0.html
MySQL 5.1 download page: http://dev.mysql.com/downloads/mysql/5.1.html
On the above page, you will see the download link provided by MySQL for different operating systems. For Windows is divided into three installation packages in different forms:
Basic installation package (Windows essenessen): the file name of the installation package is similar to mysql-essential -- 5.0.77-win32.msi. it only contains the basic file and Configuration Wizard required to install MySQL, but it does not contain optional components, such as the benchmark suite and embedded server.
Full installation package (Windows ZIP/Setup. EXE): the file name of the installation package is similar to the mysql-5.0.77-win32.zip, which contains all the files required to install MySQL with the configuration wizard and optional components, such as the benchmark suite and embedded server.
Without installer: The package is named mysql-noinstall-5.0.77-win32.zip. it contains all files except the configuration wizard in the full installation package. you must manually install and configure its configuration file (my. ini ).
The basic installation package (Windows essenessen) and full installation package (Windows ZIP/Setup.. If you need to install multiple MySQL instances on one server or are familiar with MySQL, and want to fully control the server configuration, select the installation package-free.
Install and configure MySQL
When installing MySQL on Windows, you can use the MySQL Setup Wizard and Configuration Wizard to easily complete the installation and Configuration process. The procedure is as follows:
From the MySQL5.0 or 5.1 download page, click the "Pick a mirror" link and select a recent image website (for example, an image server in Asia) download to quickly download the MySQL installation package in Windows. If the mysqlinstallation package is a. zip file, extract it first. If the installation file is either setup.exe or. msi, you can double-click the installation file to start the installation process, as shown in the following figure. Here, I downloaded the Windows Essentials (x86) installation package (mysql-essential -- 5.0.77-win32.msi) with the smallest file size)
Install
Double-click to download the obtained mysql-essential-5.0.77-win32.msi file to start installation, the following links need special attention.
1. select the installation type
There are three types of installation options: Typical installation (Typical), Complete installation (Complete), and Custom installation (Custom ).
The typical installation only includes the MySQL Server, MySQL command client, and command line utility. Command line programs and command line clients include mysqldump, myisamchk, and several other tools. Full installation includes all components in the software package, as well as embedded server libraries, baselines, and support for scripts and documents. Custom installation allows you to have full control over the software packages and paths to be installed.
Here, we select Custom installation (Custom ).

2. confirm installation (omitted)
If you select a Typical installation (Typical) or a Complete installation (Complete), click "Next" to go to the installation confirmation page. This dialog box displays the selected installation type and path. click "Install" to start installation. Here, I select Custom installation (Custom) and click "Next" to enter the Custom installation dialog box (omitted, in this step, you can also change the installation path of MySQL. The default value is "C: Program FilesMySQLMySQL Server 5.0 ". If the disk C has insufficient space, you can install it in another path (for example, "E: Program FilesMySQLMySQL Server 5.0 ").
3. Complete Installation (omitted)
After the installation is complete, the registration option and MySQL URL will appear. the advantage of registration is that you can visit the official MySQL Forum at any time, such as discovering bugs when using MySQL, then its defects can be reported on the http://bugs.mysql.com. Of course, you can also select "Skip registration (Skip Sign-Up )".
When the installation is about to end, a wizard will appear to change the registry and startup menu of the system. The following entries are created in the startup menu:
MySQL Command Line Client (MySQL Command Client): It is a shortcut of the MySQL Command Client. it can be used only by entering the root password.
MySQL Server Instance Config Wizard (MySQL Server Instance configuration Wizard): It is a shortcut of the MySQL configuration Wizard. it can be used to configure newly installed servers or reconfigure existing servers.
MySQL Document: it can be linked to the Document in the installation directory where the MySQL server is located. If you use the basic installation package, this menu is not displayed.
Configure MySQL
1. start the Configuration Wizard
Make sure that "Configure…" is selected... Now "option.

　　

2. configuration
Start configuration, select the configuration type and server type (omitted)
Two Configuration types are available: Detailed Configuration (Detailed Configuration) and Standard Configuration (Standard Configuration)
The standard configuration is suitable for new users who want to quickly start MySQL without considering server optimization. Detailed configuration is suitable for advanced users who want to control server configurations more accurately. Click "Next" to go to the server type selection page (omitted ).
There are three types of servers available:
Developer Machine: This option represents a typical desktop workstation that uses the least amount of system resources.
Server Machine (development Machine): This option indicates that the MySQL Server can run with other applications (such as Web servers, FTP and email, it uses a certain proportion of system resources.
Dedicated MySQL Server Machine (Dedicated MySQL Server Machine): This option indicates that it runs only on the MySQL Server. If no other application is running, it uses all available system resources.
Database usage (omitted)
Use the Database Usage dialog box to specify the table processor used for table creation. There are three options:
Multifunctional Database (multi-function Database): This option uses the InnoDB and MyISAM engines and distributes resources evenly between these two engines. Users who frequently use these two storage engines can select this option.
Transactional Database Only (a Database for transaction processing Only): This option uses both the InnoDB and MyISAM engines. Unlike the previous Multifunctional Database, it assigns most server resources to the InnoDB engine. This option is mainly used by InnoDB engine. users who occasionally use the MyISAM engine can select this option.
Non-Transactional Database Only (a Database for Non-transaction processing Only): This option completely disables the InnoDB engine and assigns all server resources to the MyISAM engine. You can select this option if you do not use the InnoDB engine.
Set InnoDB tablespace (omitted)
If you want to change the default location of the tablespace file in the InnoDB table, you can select a drive from the drop-down list of the drive and select a new path in the list.
Set the general number of concurrent connections (this helps prevent server resource depletion ).
Demo-support (DSS)/OLAP: This option can be selected when the server does not require a large number of concurrent connections. The average number of concurrent connections is 20, and the maximum number of connections is 100.
Online Transaction Processing (OLTP, Online Transaction Processing): This option can be selected when the server requires a large number of concurrent connections. The maximum number of connections is 500.
Manual Setting: you can manually set the maximum number of concurrent connections on the server (select or directly enter the maximum number of concurrent connections in the drop-down box.
Set networking options
On the Networking Options page, enable or disable the TCP/IP network and configure the port number to connect to the MySQL server.
Port 3306 is used by default. To change this port, you can select a new port number from the drop-down list or enter it directly.
Note: The default value can be used for most configurations. in this step, Add the listener port of the MYSQL service as the windows firewall exception, that is, the selected "Add firewall exception ...... ".

Set character set (omitted)
MySQL server supports multiple character sets:
Standard Character Set: use Latin1 (Latin1 for English and Western languages) as the server's default Character Set.
Best Support For Multilingualism (supporting multiple languages): UTF8 (utf8 can store characters in different languages as a single character set) is used as the default character set of the server.
Manual Selected Default Character Set/Collation (Default Character Set manually Selected): Select the expected Default Character Set from the drop-down list.
Set service options (omitted)
By default, the configuration wizard installs the MySQL server as a service named "MySQL". you can also select a new service name or enter a service name in the drop-down box.
Set security options
Set the root password. the original password is blank. please set a new password and keep it in mind! This is assumed to be msql.

Execute configuration
After setting the root account information, click "Execute" to Execute the Configuration on the Configuration page. if the Configuration is successful, result 5 is displayed. If the installation fails, reinstall the agent.

Cheng
　　

Install MySQL GUI Tools
Preparations
Double-click the mysql-gui-tools-noinstall-5.0-r16-win32.zip file to decompress the file to the local disk.
Start the service
Double-click MySQLSystemTrayMonitor.exe in the directory % MySQL GUI Tools %. an icon is displayed on the right of the taskbar. Click "Start Instance" to run MySQL.
Double-click MySQLAdministrator.exe in the % MySQL GUI Tools % directory, or right-click "MySQL Administrator" in the top menu"
Enter the server address. because it is a local machine, either 127.0.0.1 or localhost can be entered here. Enter the user name (root) and password, and click OK to go to the main interface of the management tool. Run the following six commands after logging in:

The default font looks uncomfortable on the UI of the Chinese version. to modify the font of the UI, click "Tools> Options" on the main menu and select "general options" on the left of the displayed dialog box ", on the right side, change "default font" to and 9, and then exit.

2. configuration
Start configuration, select the configuration type and server type (omitted)
Two Configuration types are available: Detailed Configuration (Detailed Configuration) and Standard Configuration (Standard Configuration)
The standard configuration is suitable for new users who want to quickly start MySQL without considering server optimization. Detailed configuration is suitable for advanced users who want to control server configurations more accurately. Click "Next" to go to the server type selection page (omitted ).
There are three types of servers available:
Developer Machine: This option represents a typical desktop workstation that uses the least amount of system resources.
Server Machine (development Machine): This option indicates that the MySQL Server can run with other applications (such as Web servers, FTP and email, it uses a certain proportion of system resources.
Dedicated MySQL Server Machine (Dedicated MySQL Server Machine): This option indicates that it runs only on the MySQL Server. If no other application is running, it uses all available system resources.
Database usage (omitted)
Use the Database Usage dialog box to specify the table processor used for table creation. There are three options:
Multifunctional Database (multi-function Database): This option uses the InnoDB and MyISAM engines and distributes resources evenly between these two engines. Users who frequently use these two storage engines can select this option.
Transactional Database Only (a Database for transaction processing Only): This option uses both the InnoDB and MyISAM engines. Unlike the previous Multifunctional Database, it assigns most server resources to the InnoDB engine. This option is mainly used by InnoDB engine. users who occasionally use the MyISAM engine can select this option.
Non-Transactional Database Only (a Database for Non-transaction processing Only): This option completely disables the InnoDB engine and assigns all server resources to the MyISAM engine. You can select this option if you do not use the InnoDB engine.
Set InnoDB tablespace (omitted)
If you want to change the default location of the tablespace file in the InnoDB table, you can select a drive from the drop-down list of the drive and select a new path in the list.
Set the general number of concurrent connections (this helps prevent server resource depletion ).
Demo-support (DSS)/OLAP: This option can be selected when the server does not require a large number of concurrent connections. The average number of concurrent connections is 20, and the maximum number of connections is 100.
Online Transaction Processing (OLTP, Online Transaction Processing): This option can be selected when the server requires a large number of concurrent connections. The maximum number of connections is 500.
Manual Setting: you can manually set the maximum number of concurrent connections on the server (select or directly enter the maximum number of concurrent connections in the drop-down box.
Set networking options
On the Networking Options page, enable or disable the TCP/IP network and configure the port number to connect to the MySQL server.
Port 3306 is used by default. To change this port, you can select a new port number from the drop-down list or enter it directly.
Note: The default value can be used for most configurations. in this step, Add the listener port of the MYSQL service as the windows firewall exception, that is, the selected "Add firewall exception ...... ".

Set character set (omitted)
MySQL server supports multiple character sets:
Standard Character Set: use Latin1 (Latin1 for English and Western languages) as the server's default Character Set.
Best Support For Multilingualism (supporting multiple languages): UTF8 (utf8 can store characters in different languages as a single character set) is used as the default character set of the server.
Manual Selected Default Character Set/Collation (Default Character Set manually Selected): Select the expected Default Character Set from the drop-down list.
Set service options (omitted)
By default, the configuration wizard installs the MySQL server as a service named "MySQL". you can also select a new service name or enter a service name in the drop-down box.
Set security options
Set the root password. the original password is blank. please set a new password and keep it in mind! This is assumed to be msql.

Execute configuration
After setting the root account information, click "Execute" to Execute the Configuration on the Configuration page. if the Configuration is successful, result 5 is displayed. If the installation fails, reinstall the agent.

　　

Install MySQL GUI Tools
Preparations
Double-click the mysql-gui-tools-noinstall-5.0-r16-win32.zip file to decompress the file to the local disk.
Start the service
Double-click MySQLSystemTrayMonitor.exe in the directory % MySQL GUI Tools %. an icon is displayed on the right of the taskbar. Click "Start Instance" to run MySQL.
Double-click MySQLAdministrator.exe in the % MySQL GUI Tools % directory, or right-click "MySQL Administrator" in the top menu"
Enter the server address. because it is a local machine, either 127.0.0.1 or localhost can be entered here. Enter the user name (root) and password, and click OK to go to the main interface of the management tool. Run the following six commands after logging in:

The default font looks uncomfortable on the UI of the Chinese version. to modify the font of the UI, click "Tools> Options" on the main menu and select "general options" on the left of the displayed dialog box ", on the right side, change "default font" to and 9, and then exit.

BitsCN.com