MySQL Learning notes MySQL installation details

Objective

Although NoSQL is fast growing now, MySQL is still very popular, and thousands of companies are still using lamp OR lnmp to develop, so MySQL learning is still necessary.

Installation Environment: Windows 7, requires support for. NET FRAMEWORK 4.0

MySQL version: 5.6.10.1

Installation

1. Double-click the setup installation file to start the installation, and the first three steps are "next".

2. The fourth step appears as shown in the interface.

This step I was to choose Custom installation type, relatively free, and then specify the installation directory and storage data directory.

3. The next few steps can be directly "next" until the configured interface, as shown in.

Server type configuration, for development testing, select development machine. Then specify the port for the local database service connection, which defaults to 3306. You can also change to another, but be sure not to be occupied by other programs.

4. The next step is to create a root user, equivalent to Oracle SYS, and then set the database service name, and the other steps are next.

5. After the installation is complete, you can add the MySQL bin directory to the system PATH environment variable and finally test whether the installation was successful. You can win+r into the Run dialog to enter CMD and open the command prompt interface.

C:\users\lenovo>mysql-h localhost-u root-penter Password: *******welcome to the MySQL monitor.  Commands End With;  or \g.your MySQL connection ID is 4Server version:5.5.28-log mysql Community Server (GPL) Copyright (c) +, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Green Edition installation and configuration

1. Download the MySQL Green installation package and unzip it to a location (D:\MySQL).

2. Add the D:\MySQL\Bin directory to the system variable path.

3. Edit the database run configuration file My.ini

Setting up the MySQL database installation directory

Basedir= "D:\MySQL\MySQL Server 5.5\"

Set the data storage directory for the MySQL database

Datadir= "D:\ProgramData\MySQL\MySQL Server 5.5\data\"

4. Installing the MySQL Service

D:\MySQL\MySQL Server 5.5\bin>mysqld--install srvc_name--default-file= "D:\ProgramDat
A\mysql\mysql Server 5.5\my.ini "

5. Start and close the MySQL service

NET START MYSQL55

NET STOP MYSQL55

6. Set the root user password

Mysql> set Password=password (' 1234567 ');

If, at the end of the installation, the last step appears could not start the service MySQL error:0 error, first stop the MySQL service and then use the mysqld--remove command to delete the service,

Then uninstall MySQL, delete the installation directory and the data directory.

MySQL Learning notes MySQL installation details