Install mysql5.6

Project Report install MYSQL5.6 download MySql5.61. background knowledge from the official website: MySQL provides two different versions for different users: MySQLCommunityServer: Community edition, which is free of charge, however, the official website does not provide technical support. MySQLEnterpriseServer: Enterprise Edition, which is cost-effective

Project Report installation MYSQL5.6 1 download MySql5.6 1 from the official website. version and platform Background: currently, MySQL provides two different versions for different users: MySQLCommunityServer: Community edition, which is free of charge, but is not officially supported. MySQLEnterpriseServer: Enterprise Edition, which is cost-effective

Project Report installation MYSQL5.6 1 download MySql5.6 from the official website

1. versions and platforms

Background:

Currently, MySQL provides two different versions for different users:

MySQL Community Server: Community edition. This version is free of charge, but it does not provide official technical support.

MySQL Enterprise Server: Enterprise Edition, which provides cost-effective data warehouse applications, ACID transaction processing, and complete commit, rollback, crash recovery, and row-Level Lock functions. However, this version is billed and officially provides technical support such as telephone and documentation.

2. Attachment: Download the installation version

2. decompress the MySQL package

Decompress the downloaded MySQL package to the custom directory.

3. Add Environment Variables

Variable name: MYSQL_HOME

Variable value: D: \ Program Files \ mysql-5.6.11-winx64

That is, the custom extract directory of mysql.

Add % MYSQL_HOME % \ bin in Path.

4. Register windows system services

Register mysql as a windows system service

The procedure is as follows:

1) log on to the bin directory under the MySQL decompression directory from the console:

2) enter the service installation command:

Mysqld install MySQL

After the installation is successful, a message is displayed, indicating that the service is successfully installed.

Enter net start MySql to test whether the installation is successful.

Command: mysqld remove

3) possible error 1

If you have installed MySql before or for other reasons, cmd will prompt that you cannot find the service. This is because the executable file path is incorrect. Clear the registry, delete the MySql directory under Program Data, and restart your computer, will solve.

4) possible error 2

Solution: if the default configuration file is not specified, remove it and reinstall it!

Background:

What is the difference between mysqld.exe and mysql.exe?

Mysqld.exe is a MySQL Background Program (that is, a MySQL Server ). To use a client program, the program must run because the client accesses the database by connecting to the server.

Mysql.exe is a command line Client tool that comes with MySQL. It is a command line tool that interactively enters SQL statements or executes them in batch mode from files.

To put it simply, mysqld is a command used to start the mysql database, while mysql is a command used to open and execute SQL statements.

Description of the mysqld.exe command

In Windows, the mysqld.exe command line is used to install the MySQL service. Example:

1. Enter cmd in "start"-> "run"

2. Run cd to the bin directory installed in mysql.

3. install mysql service: mysqld -- install

You can specify the service name: mysqld -- install MySQL5

By default, the service runs automatically upon startup. if the service is not automatically started upon startup, enter mysqld.exe -- install-manual.

The configuration file is written as follows: mysqld -- install System Service name -- defaults-file = path of your mysql configuration file

For example, mysqld -- install MySQL5 -- defaults-file = d: \ mysql \ my. ini

4. start: net start mysql

5. Disable: net stop mysql

6. Delete the mysql service: mysqld -- remove

You can also specify the service name. Mysqld -- remove MySQL5