MySQL Environment setup

MySQL environment to build online posts have been more, I have to write because just want to record their own installation of the process points, cut off the commonplace content

1. Need to download 2 things, Microsoft.NET.exe and mysql-5.6.24

2. Install Microsoft.NET.exe First, this completely nothing to say, all the way next, just to wait for it the installation process will download something

3. Decompression mysql-5.6.24, I downloaded this is a free installation version, extracted to the C packing directory, and then so come

The folder is named mysql5.6.

4. Here is also find the way others say, pro-test successful

In the mysql5.6 there is a file called My-default.ini, then copy it a copy and rename it to My.ini, then the contents are as follows:

[client]port=3306default-character-set=utf8# client character type, consistent with server, recommended utf8[mysqld]port=3306character_set_server=utf8# Service-side character type, it is recommended utf8basedir=c:\mysql5.6# solution to the directory datadir=c:\mysql5.6\data# \datasql_mode=no_engine_substitution, Strict_trans_tables[winmysqladmin]c:\mysql5.6\bin\mysqld.exe #解压根目录 \bin\mysqld.exe

3.3 Configure a Mysql_home system environment variable, my configuration is C:\mysql5.6, then the end of path to add%mysql_home%\bin

3.4 Execute a few commands

Mysqld-install

Start MySQL service: net start MySQL

Stop MySQL service: net stop MySQL

Move out of MySQL service: mysqld-remove

To change the root password:

mysql> mysql-uroot

mysql>Show databases;

mysql>use MySQL;

mysql> Delete from User where user= "";

mysql> Update User set Password=password (' root ') where user= ' root ';

mysql> FLUSH privileges;

mysql>quit;

FLUSH privileges: Force MySQL to reload permissions and take effect immediately

At this point you can log in with the following command:

D:\wamp\mysql\bin>mysql-uroot-p

Enterpassword:root

3.5 Common Commands

Mysql>show databases; Show All Tables

Mysql>use MySQL; Switch to table MySQL

Mysql>show tables; Show the structure of a table

Part of the content is copied from the experience of others, but they are self-tested.

3.6mysql-front Tools

This is like Oracle's Plsql.

Installation is also a one-way next

View->sql Editor

3.7mysql garbled problem once rage, so in the environment when the eyes can be polished is not configured Utf-8

MySQL Environment setup