Installation of database MySQL

1. mysql Overview

MySQL was originally a relational database management system developed by "MySQL AB" (rdbms-relation databases Management systems). MySQL is not only the most popular open source database, but also the fastest growing database in the industry, with more than 70,000 downloads per day, ranging from large enterprises to proprietary embedded applications.

MySQL AB was founded by two Swedes and a Dutchman: David Axmark, Allan Larsson and Michael "Monty" Widenius in Sweden.

At the beginning of 2008, Sun Microsystems acquired the MySQL AB company. In 2009, Oracle acquired Sun, which incorporated MySQL into Oracle's database product line.

2. mysql Installation

Step 1: Open the downloaded MySQL installation file Mysql-5.5.36-win32.msi, double-click Run, such as:

Step 2: Click on the "Next" button to continue, as

STEP3: Click "Tick" and click "Next" button to continue, as

Step 4: Select the installation type contains: Typical (default), custom (user-defined), complete (full) three options, we choose the "Custom" type, such as

Step 5: Previous step selected Custom installation, here will set the MySQL package and installation path, set up, click "Next" to continue to install, such as

Step 6: Click "Finish" to end the software installation and start the MySQL Configuration Wizard, as

Step 7: Select the configuration mode, "Detailed configuration (manual and precise configuration)", "Standard Configuration", we select "Detailed Configuration", Easy to familiarize with the configuration process, click "Next" to continue the configuration, such as:

Step 8: Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) ", people choose according to their own type, generally choose" Server machine ", not too little, will not be full. Here we choose "Developer Machine (Development test class, MySQL occupies very little resources)", click "Next" to continue, such as:

Step 9: Choose the general purpose of MySQL database, "Multifunctional databases (Universal multifunction, well supported InnoDB and MyISAM storage Engine)", "Transactional database Only (server type, focus on transaction processing, general) "," Non-transactional Database only (non-transactional type, simpler, mainly do some monitoring, counting, Support for the MyISAM data type is limited to non-transactional), chosen for its own use, I choose "Multifunctional Database" here, press "Next" to continue, such as:

Step 10: The InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, re-install the time to choose the same place, otherwise it may cause database corruption, of course, do a backup of the database is no problem, Not detailed here. I have no changes here, use the default location, press "Next" directly to continue, such as:

Step 10: Choose your website's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500 or so) "," Manual Setting (manually set, I lose a number) ", I choose" Decision Support (DSS)/olap) ", press" Next "to continue, such as:

Step 11: Whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, I am here to enable, put the front tick, Port number:3306, on this page, you can also select "Enable Standard mode" (Enable Strict Mode), press "Next" to continue, such as:

Step 12: This is more important, is to set the MySQL default database language encoding, the first is a western encoding, we want to set the UTF-8 encoding, press "Next" to continue, such as:

Step 13: Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin, Instead of pointing out the directory name, such as a connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue, such as:

Step 14: Select the security settings, there is a default database administrator root in sql, enter the root administrator's password and confirm the password is root, and select the remote access to the machine:
Select Create a new admin account and click "Next", as

Step 15: Confirm that the settings are correct, and if wrong, press "back" to return to the check. Press "Execute" to make the settings effective.

Step 16: Setup Complete, press "Finish" to end MySQL installation and configuration.

Start the MySQL service

MySQL services can be managed through the service Manager

Stop MySQL Service

Start the MySQL service

can also be controlled directly from the command line in a DOS window

Start the MySQL service

Stop MySQL Service

3. mysql Login

Configure the user environment variable Path:c:\program files\mysql\mysql Server 5.5\bin, otherwise, as shown, prompt: ' MySQL ' is not an internal or external command, nor is it a program or batch file that can be run.

After the configuration is complete, run again

Open the DOS window, enter Mysql-uroot-proot, click Enter to sign in, see "mysql>" instructions have been logged in successfully
-uroot indicates that the user name is root;-proot indicates that the password is root

Installation of database MySQL