Detailed installation tutorial for MySql5.6 Window, mysql5.6window

Source: Internet
Author: User
Tags dbvisualizer

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.