MySQL Database learning two msql installation and configuration

2.1 Downloading and installing MySQL software

2.1.1 Database management system based on client/server (c/s)

Server: MySQL database management system

Client: Operate MySQL server

Various versions of 2.1.2 MySQL

Community Edition (Community): free, free download, no technical support.

Enterprise Edition: charge, complete technical support.

Version:

GA (General availability): A widely used version is officially respected.

RC (Release Candidate): Candidate version, closest to the official version.

Alpha: Beta version, Bean: public beta.

2.1.3 Download MySQL software

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

　　　　

2.1.4 Installation and Configuration

1. Select the detailed configuration,next and go to the Select app type interface.

3 Types of applications:

• • Developer Machine: The developer, using the minimum amount of memory.
  • Server machine: Servers, using medium-sized memory.
  • Dedicated MySQL Server machine: Dedicated server that uses the maximum memory currently available.

2. Select "Developer Machine", Next

3 Types of Use database:

• • Multifunctional database: Multi-functional databases that access both transactional and non-transactional storage engines are fast.
  • Transaction Database: Transactional databases that primarily optimize the transactional storage engine, but are also available for non-transactional storage engines.
  • Non-transaction Database: Non-transactional databases that primarily optimize the non-transactional storage engine, noting that the transactional storage engine is not available.

3. Select "Multifunctional Database", Next, enter the InnoDB data file directory Configuration interface.

The InnoDB data file is created at the first startup of the database and is created by default in the MySQL installation directory. The path can be selected according to the actual hard disk space condition.

4. Next, enter the concurrent connection configuration interface, the approximate number of connections to the server.

3 types of concurrent processing to choose from:

• • Decision Support (DSS)/OLAP: Decision supporting system, setting the number of concurrent connections is 20.
  • Online Transaction processing (OLTP): On-line transaction system, set the number of concurrent connections to 500.
  • Manual Setting: Manually set the number of concurrent connections.

5. Select "Decision Support (DSS)/olap", Next, enter the network Options Settings screen.

• • Enable TCP/IP Networking: Whether to start a TCP/IP connection.
  • Enable Strict mode: whether to use strict mode to start the service.

6. Select all, Next, to enter the character set interface.

There are 3 ways to set character sets:

• • Standard Character set: The normal character set, which defaults to Latin1.
  • Best support formultilingualism: Supports the most preferred character set for multiple languages, and the default value is UTF8.
  • Manual Selected Default Character set/collation: Sets the character set manually.

7. Next, go to the Windows Options screen.

• • Install as Windows services: will be a service for Windows.
  • Include Bin directory in Windows path: Sets whether the MySQL Bin directory is written to the PATH environment variable.

8. Next, go to the MySQL Security Options Settings screen.

• • Modify Security Setting: Modify the password for the default user root
  • Create an Anonymous account: If you are creating an anonymous user, it is recommended that you do not create an anonymous user when developing it, as this will bring security vulnerabilities to the system.

9. Next, go to the ready to execute interface, confirm and click "Execute" to start execution.

2.1.5 Manually configuring MySQL

MySQL Software Installation file directory: "program Files\mysql\mysql Server 5.6"

• • Bin folder, which holds the executable file.
  • Include folder, which holds the header file.
  • Lib folder, which holds the library file.
  • Share folder, storing character sets, languages and other information.

Database file directory for MySQL software: "Application Data\mysql\mysql Server 5.6\data"

2.2 Common operations on MySQL

2.2.1 Windows services start and close

2.2.2 Startup and shutdown through a DOS window

1. In the DOS window, view the services that Windows has started:

net start

2. Start the command:

net start MySQL

3. Close the command:

net stop MySQL

4. View the started MySQL service through Task Manager: Open Task Manager, "Mysql.exe".

2.3 MySQL Client software

2.3.1--mysql command line client software

2.3.2 connecting MySQL software through a DOS window

Mysql-h 127.0.0.1-u Root-p

If "' MySQL ' is not an internal or external command, it is not a running program or a batch file. ", you need to configure the environment variable path, add";.. \mysql\mysql Server 5.6\bin; "

2.3.3 Download Graphical Client software--mysql-workbench

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

2.3.4 MySQL common graphical management software--sqlyog

The most popular graphical MySQL client software:

Https://www.webyog.com/product/downloads

MySQL Database learning two msql installation and configuration