MySQL configuration diagram (post)

MySQL configuration diagram (post)

Installation and configuration diagram of mysql5.1

1. Install mysql5.1

Open the downloaded installation file and the following page is displayed:

Start the MySQL Installation Wizard and click "Next" to continue

Select the installation type, which has three options: "typical (default)", "complete (complete)", and "Custom (custom)". Select "Custom ", there are more options to familiarize yourself with the installation process.

Click "MySQL Server" and select "this feature, and all subfeatures, will be
Installed on local hard drive. ", that is," This part and its sub-parts are all installed on the local hard disk ". Click "change..." to manually specify the installation directory.

Fill in the installation directory, such as "F: MySQL", and do not place it in the same partition as the operating system. This prevents data from being cleared during system backup and restoration. Press "OK" to continue.

Confirm the previous settings. If there is an error, press "back" to return the redo. Click "Install" to start installation.

Installing. Please wait until the following interface appears.

Click "Next" to continue. The following page is displayed.

Now that the software has been installed, the above interface appears. Here is a good function. The MySQL Configuration Wizard does not need to be the same as before,
Manually configure my. ini in a mess, tick the one before "configure the MySQL server now", and click "finish ".
Install the software and start the MySQL Configuration Wizard.

Ii. Configure MySQL Server

Click "finsh". The following page is displayed. The MySQL Server Configuration Wizard starts.

Click "Next" to display the following interface,

Select the configuration method, "detailed configuration (manual precise configuration)", "standard configuration (standard configuration )",
Select "detailed configuration" to familiarize yourself with the configuration process.

Select the server type, "Developer machine (development and testing class, MySQL occupies a small amount of resources)", "server machine (Server
Server type, MySQL occupies a lot of resources) "," dedicated MySQL server machine (dedicated database server, MySQL
All available resources are used.) ", you have selected your own type. Generally, select" server machine ", which is neither too small nor full.

Select the general purpose of the MySQL database, "multifunctional database (general multi-function type, good)", "transactional
Database only (server type, focus on transaction processing, General) "," Non-transactional database only (non-transaction
Model, relatively simple, mainly used for monitoring and recording. The support for MyISAM data types is limited to non-transactional.
I have selected the application. Here I select "transactional database only" and press "Next" to continue.

Configure InnoDB tablespace to select a bucket for the InnoDB database file.
Location: select the same location during reinstallation. Otherwise, the database may be damaged. Of course, it is okay to back up the database.
. I have not modified it here. Use the default position and press "Next" to continue.

Select the average MySQL access volume of your website and the number of connections at the same time, "demo-support (DSS)/OLAP (about 20 )",
"Online transaction processing (OLTP) (about 500)" and "manual setting (manually set, and input a number by yourself )",
Here I select "online transaction processing (OLTP)", and my server should be enough. Press "Next" to continue.

Whether to enable TCP/IP connection and set the port. If it is not enabled, you can only access the MySQL database on your own machine.
Port Number: 3306. on this page, you can also select enable strict
Mode), so that MySQL will not allow small syntax errors. If you are a newbie, I suggest you cancel the standard mode to reduce the trouble
Annoying. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database. There is also a "add firewall exception..." setting for the firewall ......" Select to add the listening port of the MySQL service as the Windows Firewall exception to avoid firewall blocking. Press "Next" to continue.

Note: If you want to use the data of the original database, it is best to determine the encoding used by the original database. If the encoding set here is different from the encoding of the original database data, garbled characters may occur during use.

This is very important. It is to set the default MySQL database language encoding. The first is the Spanish encoding, and the second is the multi-byte encoding.
General utf8 encoding is not our general encoding. Here we select the third encoding, and then select or enter "GBK" in character set ",
Of course, you can also use "gb2312", the difference is that the GBK font size is large, including all the Chinese characters of gb2312, and added traditional Chinese characters,
And other messy words-when using MySQL, Run "set names GBK;" (run
Just one line at a time. You can replace GBK with other values, depending on the settings here.) Then you can use Chinese characters (or other texts) normally,
Otherwise, Chinese characters cannot be displayed normally. Press "Next" to continue.

Select whether to install MYSQL as a Windows service, you can also specify the service name (service ID name), whether
Add the bin directory to the Windows path (after adding the directory, you can directly use the file in the bin without specifying the directory name, such
Next, you can click mysql.exe-uusername -ppassword##, and then click the complete address of mysql.exe, which is very convenient .)
All are checked, and the service name remains unchanged. Press "Next" to continue.

This step asks if you want to change the default root user (Super Management) password (which is blank by default), "New Root Password" if you want
Modify the password. Enter the new password here. (If the password is reinstalled and has been set, changing the password may cause an error. leave it blank,
Remove the check box before "modify Security Settings" and change the password after installation and configuration.) and "Confirm (re-enter )"
To prevent errors. "Enable root access from remotemachines (whether to allow root users on other machines)
Login, if you want to be secure, do not hook it up. If you want to be convenient, just hook it up )". Create an anonymous account (create
An anonymous user can connect to the database and cannot perform operations on data, including queries) ". Generally, no check is required. After the settings are complete, press
"Next" to continue.

Confirm that the settings are correct. If any error occurs, press "back" to return for the check. Press execute to make the settings take effect.

 

After the configuration is complete, press "finish" to end MySQL installation and configuration. A common error is that MySQL cannot be started.
Service, usually appeared on the server where MySQL was previously installed. To solve this problem, first ensure that the previously installed MySQL server is completely
If not, check whether the previous password has been modified according to the previous steps. If not,
Back up the data folder in the MySQL installation directory and delete it. After installation is complete, delete the generated data folder.
And then restart the MySQL service. In this case, you may need to check the database and then repair it.
Repeat once to prevent data errors.

 

Iii. Description

The content involved in this article can be found in MySQL Reference Manual Chapter 2 "Install MySQL. MySQL reference manual address

Http://dev.mysql.com/doc/refman/5.1/zh/index.html. For MySQL: http://dev.mysql.com/downloads/mysql/5.1.html.

Installation and configuration diagram of mysql5.1

1. Install mysql5.1

Open the downloaded installation file and the following page is displayed:

Start the MySQL Installation Wizard and click "Next" to continue

Select the installation type, which has three options: "typical (default)", "complete (complete)", and "Custom (custom)". Select "Custom ", there are more options to familiarize yourself with the installation process.

Click "MySQL Server" and select "this feature, and all subfeatures, will be
Installed on local hard drive. ", that is," This part and its sub-parts are all installed on the local hard disk ". Click "change..." to manually specify the installation directory.

Fill in the installation directory, such as "F: MySQL", and do not place it in the same partition as the operating system. This prevents data from being cleared during system backup and restoration. Press "OK" to continue.

Confirm the previous settings. If there is an error, press "back" to return the redo. Click "Install" to start installation.

Installing. Please wait until the following interface appears.

Click "Next" to continue. The following page is displayed.

Now that the software has been installed, the above interface appears. Here is a good function. The MySQL Configuration Wizard does not need to be the same as before,
Manually configure my. ini in a mess, tick the one before "configure the MySQL server now", and click "finish ".
Install the software and start the MySQL Configuration Wizard.

Ii. Configure MySQL Server

Click "finsh". The following page is displayed. The MySQL Server Configuration Wizard starts.

Click "Next" to display the following interface,

Select the configuration method, "detailed configuration (manual precise configuration)", "standard configuration (standard configuration )",
Select "detailed configuration" to familiarize yourself with the configuration process.

Select the server type, "Developer machine (development and testing class, MySQL occupies a small amount of resources)", "server machine (Server
Server type, MySQL occupies a lot of resources) "," dedicated MySQL server machine (dedicated database server, MySQL
All available resources are used.) ", you have selected your own type. Generally, select" server machine ", which is neither too small nor full.

Select the general purpose of the MySQL database, "multifunctional database (general multi-function type, good)", "transactional
Database only (server type, focus on transaction processing, General) "," Non-transactional database only (non-transaction
Model, relatively simple, mainly used for monitoring and recording. The support for MyISAM data types is limited to non-transactional.
I have selected the application. Here I select "transactional database only" and press "Next" to continue.

Configure InnoDB tablespace to select a bucket for the InnoDB database file.
Location: select the same location during reinstallation. Otherwise, the database may be damaged. Of course, it is okay to back up the database.
. I have not modified it here. Use the default position and press "Next" to continue.

Select the average MySQL access volume of your website and the number of connections at the same time, "demo-support (DSS)/OLAP (about 20 )",
"Online transaction processing (OLTP) (about 500)" and "manual setting (manually set, and input a number by yourself )",
Here I select "online transaction processing (OLTP)", and my server should be enough. Press "Next" to continue.

Whether to enable TCP/IP connection and set the port. If it is not enabled, you can only access the MySQL database on your own machine.
Port Number: 3306. on this page, you can also select enable strict
Mode), so that MySQL will not allow small syntax errors. If you are a newbie, I suggest you cancel the standard mode to reduce the trouble
Annoying. However, if you are familiar with MySQL, try to use the standard mode because it can reduce the possibility of harmful data entering the database. There is also a "add firewall exception..." setting for the firewall ......" Select to add the listening port of the MySQL service as the Windows Firewall exception to avoid firewall blocking. Press "Next" to continue.

Note: If you want to use the data of the original database, it is best to determine the encoding used by the original database. If the encoding set here is different from the encoding of the original database data, garbled characters may occur during use.

This is very important. It is to set the default MySQL database language encoding. The first is the Spanish encoding, and the second is the multi-byte encoding.
General utf8 encoding is not our general encoding. Here we select the third encoding, and then select or enter "GBK" in character set ",
Of course, you can also use "gb2312", the difference is that the GBK font size is large, including all the Chinese characters of gb2312, and added traditional Chinese characters,
And other messy words-when using MySQL, Run "set names GBK;" (run
Just one line at a time. You can replace GBK with other values, depending on the settings here.) Then you can use Chinese characters (or other texts) normally,
Otherwise, Chinese characters cannot be displayed normally. Press "Next" to continue.

Select whether to install MYSQL as a Windows service, you can also specify the service name (service ID name), whether
Add the bin directory to the Windows path (after adding the directory, you can directly use the file in the bin without specifying the directory name, such
Next, you can click mysql.exe-uusername -ppassword##, and then click the complete address of mysql.exe, which is very convenient .)
All are checked, and the service name remains unchanged. Press "Next" to continue.

This step asks if you want to change the default root user (Super Management) password (which is blank by default), "New Root Password" if you want
Modify the password. Enter the new password here. (If the password is reinstalled and has been set, changing the password may cause an error. leave it blank,
Remove the check box before "modify Security Settings" and change the password after installation and configuration.) and "Confirm (re-enter )"
To prevent errors. "Enable root access from remotemachines (whether to allow root users on other machines)
Login, if you want to be secure, do not hook it up. If you want to be convenient, just hook it up )". Create an anonymous account (create
An anonymous user can connect to the database and cannot perform operations on data, including queries) ". Generally, no check is required. After the settings are complete, press
"Next" to continue.

Confirm that the settings are correct. If any error occurs, press "back" to return for the check. Press execute to make the settings take effect.

 

After the configuration is complete, press "finish" to end MySQL installation and configuration. A common error is that MySQL cannot be started.
Service, usually appeared on the server where MySQL was previously installed. To solve this problem, first ensure that the previously installed MySQL server is completely
If not, check whether the previous password has been modified according to the previous steps. If not,
Back up the data folder in the MySQL installation directory and delete it. After installation is complete, delete the generated data folder.
And then restart the MySQL service. In this case, you may need to check the database and then repair it.
Repeat once to prevent data errors.

 

Iii. Description

The content involved in this article can be found in MySQL Reference Manual Chapter 2 "Install MySQL. MySQL reference manual address

Http://dev.mysql.com/doc/refman/5.1/zh/index.html. For MySQL: http://dev.mysql.com/downloads/mysql/5.1.html.