mysql5.1 Installation Illustration Tutorial

The following is an installation diagram based on the MySQL5.1. Download detailed MySQL website: http://www.mysql.com/

or http://dev.mysql.com/downloads/mysql/

Shouxian appears to be the Welcome screen of the installation Wizard, just like any other Windows Installer!

Click "Next" directly, continue, select the type of installation

There are 3 types: typical (typical), complete (full), custom (customized). Select Custom installation, (default is typical, recommended to custom, because typical mode does not allow changing the installation path, can only be installed on the C drive. Then click "Next" Next, the Custom installation interface appears

To this step you need to select components and Change folder location, the component is the default, the location can choose change to alter

Note: The path to the installation of MySQL cannot contain Chinese! All ready, click Install to start the installation, click "Install" to start the installation

After installation, the explanation screen appears, the next step

Note that there is a configuration Wizard option (Configure the MySQL Server now), it is recommended to tick configure your MySQL immediately. Many say that after MySQL is installed, it cannot be started because MySQL is not configured. Click "Finish" to complete the installation and start configuring MySQL

Click "Next" to enter the configuration Type Selection page. Select "Detailed Configuration" (details),

Click "Next" to enter the service Type Selection page. Choose "Developer Machine" (developer), so that there is not a lot of resources to occupy the system. (The first is the development server, will only use as little memory, the second is a normal Web server, will use a medium amount of memory, the last is this server only run MySQL database, will occupy all the memory, I here is just an example, choose the development server, occupy as little memory, Users can choose other options (11) According to their needs, click Next to continue. Machine Memory election first)

After clicking "Next", go to the Database Usage Selection page. Select "Multifunctional Database".

The first is multi-purpose, the database will be optimized to a good InnoDB storage type and efficient MyISAM storage type, the second is only for transaction type, the best optimization innodb, but also support MyISAM, the last type of non-transaction processing, suitable for simple applications, Only MyISAM types that do not support transactions are supported. Generally choose the first multifunctional.

Click "Next" to go to the Select InnoDB data storage Location page; The default is good, no need to change

Do not change the settings, directly in the installation path installation directory, and then click "Next", select the number of simultaneous connections MySQL

(The first is the maximum number of 20 connections concurrent, the second is the maximum number of 500 concurrent connections, the last one is custom, you can choose according to your own needs)

Select "Manual Setting", set to 100 (according to your own needs, as appropriate), click "Next", configure MySQL port in TCP/IP communication environment

Select the default port of 3306. Click "Next" and select the character settings in MySQL.

(You can also select Enable Strict mode so that MySQL does not allow small syntax errors.) If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. )

Note that the choices here will affect whether you can use Chinese in MySQL. We choose to have more GBK supported characters. Click "Next" to set Windows service options

Note that the choice here is critical. "Install as Windows Service" must be checked, which is to run MySQL as the Windows services. The "service name" is the default "MySQL" or your preferred service name (the default "MySQL" is recommended). The following "Launch the MySQL Server automatically" must be checked, so that when Windows starts, MySQL will automatically start the service, or you will have to manually start MySQL. Many people say that after installing MySQL it is not possible to start, connect, or have a 10061 error, which is why. Click "Next" to set the root login password

This step is whether to set up MySQL as a service for Windows, generally choose to set up a service, so that you can start and close the MySQL database through the service later. Recommended: The following check boxes are also checked, so that in cmd mode, you do not have to execute commands (18) in the bin directory of MySQL.

"Modify Security Settings" is to set the root account password, enter the password you set. Create an Anonymous accounts is an anonymous account that causes unauthorized users to access your database illegally, with security implications and not recommended. Click "Next", the MySQL Configuration wizard will configure MySQL according to all the settings above you so that MySQL runs as you want

Click "Execute" to start the configuration, when "service started successfully", stating that your configuration is complete, the MySQL service started successfully

Click "Finish" to complete the entire MySQL configuration, the rest is to use the MySQL client to connect to the MySQL server, and then used.

Setup finished, press "Finish" to end the installation and configuration of MySQL--here is a more common error, is not "Start service", generally appear in the previous installation of MySQL server, the solution, first to ensure that the previously installed MySQL server completely uninstalled , if not, check whether the previous password has been modified, according to the above, if not, the MySQL installation directory of the Data folder backup, and then delete, after the installation is complete, will install the generated Data folder to remove, the backup Data folder back, Restart the MySQL service again, in which case you might need to check the database and fix it once to prevent data errors.

Problems that may occur:

If in 16th step, you appear the interface is like below,

Figure 22

There are three places where you can enter a password, it is possible that you installed it on the original basis. You enter the original root password in the first text box, and the next two text boxes enter the root's new password, click on Basic (23).

Figure 23

We recommend several solutions to you:

1) point retry, retry;

2) Run the settings again, see the "Remove original settings" option, select Remove, and then reset.

3) re-install.

Reload Note: It is best to delete all the original files, if necessary, you can clear the registry, if you do not have other MySQL-related programs on the machine. And be sure to remember not to keep the original My.ini file. Also, delete the file under the original installation path and delete the Ibdata1 file below the data directory.

mysql5.1 Installation Illustration Tutorial