Installation of 20140220-MySQL (use zip to decompress the green installation method)

Installation of 20140220-MySQL (use zip to decompress the green installation method)

Google can directly find the official website by entering MySQL. Download the green version.

Select MySQL Community Server.

If you have installed MySQL, run the following command:

(1) Stop MySQL services:Net stop mysql(Semicolon is not required)

(2) Remove MySQL services:Mysqld remove(Semicolon is not required)

Installation Steps

1. decompress the package and copy it to the specified location;

2. Add environment variables;

Add the following directory to the environment variable path: F: \ app \ mysql-5.6.16-winx64 \ bin (this step is important );

3. modify the configuration file;

(1) Rename one of the my-xx.ini In the mysql directory to my. ini;

(2) open my. ini and add two configuration information under [mysqld] in the file.

Basedir = point to the mysql directory, and datadir points to the mysql database storage directory.

Or write it like this.

4. Install MySQL through a command prompt

(1) enter the bin folder (although path has been configured, we recommend that you enter the bin directory of mysql during installation)

Execute the command: mysqld install

Expansion: InputMysqld removeYou can complete the uninstallation.

(2) Refresh F5 in the control panel and management tools to see the MySQL service.

(3) execute commandsNet start mysqlStart the service.

Note: if you cannot start it here, you must open the cmd path of bin in the current directory, even if you have set the bin directory of mysql as an environment variable. In cmd, go to the bin directory of the MySQL decompressed version and run the installation and startup commands.

Otherwise, an error message "the specified file cannot be found" is reported.

5. Enter MySQL;

UseMysql-u root-pPress enter and enter the password to enter MySQL.Show databasesQuery all databases in MySQL.

New users do not have a password,You can press enter directly..

6. view the database

Show databases;

Note: enter a semicolon here.