"MySQL notes" MySql5 installation illustration tutorial

Mysql5.6window Ultra-detailed installation tutorials

2015-06-23 0 Comments Source: Lin Bingwen Evankaka's Column

collection I want to contribute

First, the installation package preparation

1. Download MySql5.6

http://www.mysql.com/

To download the following tutorial, choose MySQL on Windows

Select MySQL Installer

Note the corresponding version of the system, the number of bits

Download MySQL installation package requires Oracel account, if not, register one yourself, then connect the above process, then login

You can download the number in the account.

This is the end of the download

Second, start the installation

A direct double-click begins.

Select the default

The required tool checks are performed before installation, and there is less Python3.4

Next down, it will automatically download Python3.4 and install

This is the installation in progress

After the installation is complete

Next, there are a few parameters to configure

Ports can be changed to their liking, the default 3306

Set the root user password

Set default startup

Test the connection, after you enter the password, check

Show success, Next

The installation is successful, you can finish the

Third, verify the installation

1, method One, using the MySQL own

1

2, method two, using cmd

Right-click My Computer--Properties--Advanced---> Environment variables to add the path to the MySQL bin directory in path.

Select the environment variable and enter your MySQL path under the path path in the environment variable to OK. Note If you also have path in your user environment variable, fill it in as well.

This is the default installation path C:\Program files\mysql\mysql Server 5.6\bin

OK, you can enter it. Mysql-h 127.0.0.1-u Root-p then enter the password. You can connect to the local MySQL database.

Iv. Client Tools

Using this black box to write the statement is very inconvenient, here I introduce two client tools, you can directly write SQL statements, look at the database and so on

1, MySQL Workbench 6.3 CE

Here MySQL installs, comes with the.

Connect to the local database and click the gray box when you open it

Enter a password,

When it's open, it's ready to be manipulated.

2,dbvisualIzer

Dbvisualizer is an aid and maintenance database tool that involves all major databases and is based on cross-platform. It allows the simultaneous connection of various databases through the JDBC driver, immediately pointing to and browsing the database structure, viewing the detailed characteristics of database objects, illustrating desktop data, arbitrary SQL statements or SQL scripts, using reverse engineering diagrams to primary/foreign key values, and display it in advanced chart mode, the friendly GUI interface and the unique combination of various features, it is worth you to collect a copy. Dbvisualizer is a powerful Java tool for viewing one or more JDBC-activated databases at the same time. It can graphically display the relationships between forms. It can display information about data items, keywords, and so on. With SQL commands, you can also execute all of the SQL statements.

Source: http://www.2cto.com/database/201506/409821.html

From for notes (Wiz)

"MySQL notes" MySql5 installation illustration tutorial