Mysql Installation Configuration detailed tutorial (a) _mysql

MySQL database has cross-platform, not only can run on Windows, but also can run on operating systems such as Unix,linux and Mac OS

1. First simple version of MySQL:

Depending on the type of operating system, it can be divided into Windows, UNIX, Linux, and Mac OS Edition

Depending on the user community can be divided into: the Community version (Community Edition) and the Enterprise (Enterprise), the community version is completely free, the Enterprise version is charged

According to the order of release can be divided into: 4.1, 5.0, 5.1, 5.4, 6.0 and other versions

According to the development of MySQL is divided into: Alpha, Beta, gamma and generally Available (GA) and other versions

Several version descriptions:

Alpha: Version in development phase may add functionality or modify

Beta: Development is basically complete, in beta version, but not fully tested

Gamma: A beta release over a period of time, more stable than beta

Generally Available (GA): The most stable version that can be applied to software development

Cases:

Mysql-essential-6.0.11-alpha-win32.msi

Essential: This version contains the necessary parts of MySQL, does not contain the infrequently used parts

6: Major Version number

0: Release level

11: The version number below this level (here is the 11th version under Level 0)

Alpha: In the development phase version

Win32: Version running on 32-bit Windows

MSI: Format of installation files

The following is a description of MySQL's installation configuration under common system windows and Linux

2. Install and configure MySQL on Windows

MySQL installs packages on Windows in two ways: graphical interface installation and installation-free (Noinstall)

There are also two optional packages for graphical interface installation: Windows Essentials and Windows MSI Installer

Windows Essentials mentioned above, contains only the necessary parts of MySQL, does not contain the infrequently used parts

Windows MSI Installer is a commonly used and infrequently included package

I use the essentials package as an example to install:

1> Double click Mysql-5.1.72-winx64.msi

2> accept the agreement, next

3> Select "Custom", Next

4> Click "Change ..."

5> Modify MySQL installation path, point "OK"

6> Next

7> Point "Install"

8> Next

9> Next

10> remains selected "Configure the MySQL Server now" unchanged, dot "Finish"

11> Next

12> Select "Detailed Configuration", Next

Detailed Configuration: Detailed configuration, if the database as a business Server, then choose this option, if you practice, you can choose "Standard Configuration"

Standard Configuration: Standard configuration

13> Select "Server Machine", Next

Default is "Developer Machine"

Developer Machine: Developing test classes with less cost sources

Server Machine: Servers type, accounting for more resources

Dedicated MySQL Server Machine: A dedicated database server type that accounts for all available resources

14> Select "Transactional Database only", Next

Default is "Multifunctional Database"

Multifunctional Database: Common type

Transactional Database only: transaction processing, applicable to the Web and other transaction types of application services, the InnoDB engine support better

Non-transactional Database only: Non-transactional processing, simpler, mainly for monitoring, counting applications, the MyISAM engine support better

15> Select the path to store the InnoDB tablespace data file by default, installation path (installation path), next

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

Decision Support (DSS)/olap: Supports 20 concurrent connections

Online Transaction Processing (OLTP): can support 500 concurrent connections

Manual Setting: Manually specify the number of concurrent, default 15

17> Whether TCP/IP connections are enabled, default enabled , set MySQL port, default to "3306", check the port to add to the firewall policy, whether to open strict mode, if opened, the database to filter the data more stringent, not allowed to have any grammatical errors, Improve the accuracy of the data

18> Character Set setting, I selected the third "Manual Selected Default Character set/collation", select the character set as "GBK", Next

Standard Character Set: Default character set is Latin1, applicable to English and Western European languages

Best Support for Multilingualism: Default character set is UTF8

Manual Selected Default Character set/collation: Manually select the character set, choose GBK or gb2312, the difference: GBK font size, including the gb2312

19> Choose whether to install MySQL as a Windows service , default check, service Name set services name, default is: MySQL, check "Launch the MySQL Server automatically" and " Include Bin directory in Windows PATH, next Launch the MySQL Server automatically: Do you want to set up startup include Bin directory in Windows Path: Add the MySQL application directory to the Windows system path so that you can access MySQL directly in the DOS window without having access to MySQL's Bin directory

20> Set the password for the MySQL superuser root and whether to create an anonymous user, do not check "create a Anonymous account", Next

21> dot "Execute"

22> Point "Finish" Complete installation

There are a few common mistakes in the last step, as detailed in the following:

Cannot create Windows service for mysql.error:0 when troubleshooting MySQL5.1 installation

Workaround for MySQL install reinstall when could not start the service MySQL error:0 problem

The above is the MySQL installation configuration method of the whole content, I hope to help you learn, but also hope that we support cloud habitat community.