Detailed installation tutorial for MySql5.6 Window, mysql5.6window
Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka
Directory
I. Installation Package preparation
Ii. Start Installation
Iii. Verify Installation
Iv. Client tools
I. Installation Package preparation
1. Download MySql5.6
Http://www.mysql.com/
Download the following tutorial.
Select MysQl Installer
Pay attention to your own version, number of digits of the system
To download the Mysql installation package, you need the El account. If you do not have one, register one by yourself, connect the following process, and then Login.
You can download the account by entering it.
This is after the download
Ii. Start Installation
Double-click to start.
Select the default
Check the required tool before installation. Python3.4 is missing.
Next, it will automatically download Python3.4 and install
This is the installation in progress
After installation
Next, configure some parameters.
You can change the port to your preferred one. The default value is 3306.
Set the root user password
Set default startup
Test the connection. Enter the password and check the password.
Displayed successfully, next
The installation is successful. You can finish it.
Iii. Verify Installation
1. Method 1: Use the built-in MySql
1
2. Method 2: Use cmd
Right-click my computer --> properties --> advanced ---> environment variable and add the path of the mysql bin directory to the path.
Select the environment variable and enter your MySQL path under the path in the environment variable. Note that if your user environment variables also contain path, you should also enter it.
This is the default installation path C: \ Program Files \ MySQL Server 5.6 \ bin
Okay, you can enter it. Mysql-h 127.0.0.1-u root-p and enter the password. You can connect to the local MySql database.
Iv. Client tools
It is inconvenient to use this black box to write statements. Here I will introduce two client tools that can directly write SQL statements and read databases.
1. MySQL Workbench 6.3 CE
Here, Mysql comes with it during installation.
Connect to the local database and click the box.
Enter the password,
After opening, you can perform the operation.
2,DbVisualIzer
DbVisualizer is a database aid and maintenance tool that involves all major databases and is based on Cross platforms. It allows JDBC drivers to connect to different databases at the same time. It immediately points to and browses the database structure, views the detailed features of database objects, and graphic desktop data, arbitrary SQL statements, or SQL scripts, the primary/foreign key values are displayed in the reverse engineering diagram, and are displayed in advanced charts. The friendly graphical interface and a unique combination of various features are worth your attention. DbVisualizer is a powerful Java tool used to view one or more databases activated by JDBC at the same time. It displays the relationship between forms in graphs. It displays data items, keywords, and other information. You can use SQL commands to execute all SQL statements.
We recommend that you crack the version here.
Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka