MySQL 5.6 Windows Installation Configuration trial

Does not require the effort to use the MSI file: Next, the next installation.

Just get the zip file (mysql-5.6.16-win32.zip) and you can use it after decompression.

1. Unzip the file, anywhere.

2. Go to the Bin directory, open a CMD window, execute: mysqld, the server is running. At this point, the Close CMD window is invalid and the server is still running in the background.

3. Close method: Open a CMD window again, execute: mysqladmin-u root shutdown can be.

4. Initial root user is no password, very dangerous, set a: mysqladmin-u root password 12345, it is changed.

5. The future operation will need to give the password, mysqladmin-u root-p12345 .....

=======================

Client Login:

Mysql-u root-p12345

Enter the directive after the prompt:

show databases; See which databases are available

Use MySQL; Enter a database

Show tables; Let's see what the tables are.

Desc Time_zone; View the structure of a table (which fields are available)

Quit or exit; Exit

MySQL 5.6 Windows Installation Configuration trial