Mysql installation configuration tutorial (1): mysql installation Configuration

Mysql installation configuration tutorial (1): mysql installation Configuration

MySQL databases are cross-platform. They can run not only on Windows, but also on UNIX, Linux, Mac OS, and other operating systems.

1. Briefly describe the MySQL version:

The operating system types can be divided into Windows, UNIX, Linux, and Mac OS.

Users can be divided into Community Edition and Enterprise Edition. Community Edition is free of charge and Enterprise Edition is free of charge.

Versions can be divided into 4.1, 5.0, 5.1, 5.4, and 6.0 according to the release order.

MySQL can be divided into Alpha, Beta, Gamma, and Generally Available (GA) versions based on MySQL development.

Several versions:

Alpha: a version in the development stage. It may add features or modifications.

Beta

Gamma: a Beta version that has been released for a period of time. It is more stable than Beta.

Generally Available (GA): the most stable version, which can be applied to software development.

Example:

Mysql-essential-6.0.11-alpha-win32.msi

Essential: This version contains the necessary part of MySQL, not the uncommon part.

6: Major version number

0: Release level

11: version number under this level (version 11th under the 0 level here)

Alpha: Development version

Win32: A 32-bit Windows version.

Msi: Format of the Installation File

The following describes how to install and configure Mysql in Windows and Linux.

2. install and configure MySQL on Windows

There are two installation packages for MySQL on Windows: installation on the graphical interface and installation-free (noinstall)

There are two optional packages for graphical interface installation: Windows essenessenand Windows MSI Installer.

Windows Essentials as mentioned above, it only contains the necessary components of MySQL, not common components

Windows MSI Installer is a commonly used and infrequently used package.

I will install the essenessenpackage as an example:

1> double-click mysql-5.1.72-winx64.msi

 

2> Accept the protocol, next

3> select Custom and next

 

4> click "Change ..."

 

5> modify the MySQL installation path and click "OK"

 

6> next

 

7> click "Install"

 

 

8> next

9> next

10> keep "Configure the MySQL Server now" selected and click "Finish"

11> next

12> select "Detailed Configuration" And next

Detailed Configuration: Detailed Configuration. If the database is used as the Enterprise Server, select this option. If you want to practice it yourself, select "Standard Configuration"

Standard Configuration: Standard Configuration

13> select "Server Machine" and "next ".

The default value is "Developer Machine"

Developer Machine: development and testing class with less resource consumption

Server Machine: Server type, which occupies a large amount of resources

Dedicated MySQL Server Machine: Dedicated database Server type, which occupies all available resources

14> select "Transactional Database Only" And next

The default value is "Multifunctional Database"

Multifunctional Database: general type

Transactional Database Only: Transaction Processing type, suitable for web and other transaction processing types of application services, good support for the InnoDB Engine

Non-Transactional Database Only: Non-transaction processing type, simple, mainly used for monitoring and counting applications, good support for the MyISAM Engine

15> select the Path for storing the InnoDB tablespace data file. The default value is "Installation Path" and "next ".

16> set the number of concurrent connections. I chose the second "Online Transaction Processing (OLTP )"

Demo-support (DSS)/OLAP: supports 20 concurrent connections

Online Transaction Processing (OLTP): supports 500 concurrent connections

Manual Setting: manually specify the number of concurrent jobs. The default value is 15.

17> whether to enable TCP/IP connection. It is enabled by default.Set the MySQL port. The default value is "3306". Check the option to add the port to the firewall policy to check whether strict mode is enabled. If enabled, the database filters data more strictly, no syntax or other errors are allowed, which improves data accuracy.

 

18> Character Set settings,I Selected the third "Manual Selected Default Character Set/Collation", and Set the Character Set to "gbk" And next

Standard Character Set: the default Character Set is Latin1, applicable to English and Western European languages

Best Support For Multilingualism: the default character set is UTF8.

Manual Selected Default Character Set/Collation: manually select the Character Set, and select gbk or gb2312. The difference is that the gbk font has a large capacity, including gb2312.

19> select whether to install mysql as a windows ServiceBy default, the Service Name is selected. the default value is MySQL. Select "Launch the MySQL Server automatically" and "Include Bin Directory in Windows PATH", and next Launch the MySQL Server automatically: whether to enable Include Bin Directory in Windows PATH: add the MySQL application Directory to the PATH of the Windows system, so that you can directly access MySQL in the DOS window, instead of accessing the MySQL bin directory

 

20> set the MySQL Super User root PasswordAnd whether to Create An Anonymous user. Do not select "Create An Anonymous Account" or "next ".

21> click "Execute"

22> click "Finish" to complete the installation.

There are several common errors in the last step. For details, refer:

Solve the Problem of Cannot create windows service for mysql. error: 0 when installing MySQL5.1.

How to solve the problem of cocould not start the service MySQL error: 0 during mysql installation and reinstallation

The above is all the content of the mysql installation and configuration method. I hope it will be helpful for everyone's learning, and I hope you can support more help.