A brief description of how MySQL database is installed and related settings

There are a lot of tutorials on MySQL online, but none of them are up to date, I just have a brief description of the latest version of my SQL installation and setup, and most of the operations are the same.

The following is described in accordance with the Windows 64-bit operating system +my SQL 5.6.27 version.

MySQL installation version operating instructions

First step: Download MySQL Community Server (ie: MySQL community version) to MySQL website (http://dev.mysql.com/downloads/mysql/), this is free, can meet the needs of ordinary small and medium-sized enterprises, Of course you can also download the Enterprise version, that need to contact their sales related to purchase operations, the site does not provide direct download;

Website Download path: Menu on the right: MySQL on Windows-->mysql installer-->windows (x86, 32-bit), MSI Installer (with 1 1.6M and 252.6M, recommended to select Large capacity).

Description: MySQL Installer is the + bit, but will installs the both and the 32 bit binaries. (MySQL install software is a 32-bit or 64-bit MySQL)

The second step: Run the MySQL installation program, according to the actual situation of the installation, focus on a few places to note:

1. Install the components: the server side can choose the default installation, or choose a custom installation (need to include MySQL server and related management tools, such as: Workbench), the client can choose clients only;

2. Server Configuration type: If personal development, can choose to develop the machine, if used as a Web database server, you can choose a server, or dedicated server;

3. Set the root account password: Must meet the password complexity requirements;

The third step: After the successful installation, if not special settings, usually the MySQL service will automatically start, this can be done through the Workbench visual management interface or through the MySQL 5.6 command line client to perform some SQL command query database situation, The relevant commands are as follows:

Show databases;--Display all databases

Show CHARACTER set;--shows all the character sets supported by MySQL

Show VARIABLES like ' character_set_% ';--show current MySQL server character set settings

Show VARIABLES like ' collation_% ';--show current MySQL server character set checksum settings

Show create database name;--Display a database character set

Show variables like ' DataDir ';--shows where the current MySQL database data file is stored

Fourth step: The default database data file location is the same as the MySQL installation directory, location path such as: C:/programdata/mysql/mysql Server 5.6/data, through show variables like ' DataDir ' command can also be seen, the general database files with the increase in data and slowly become larger, not recommended by default, at this time we can modify the MySQL configuration file My.ini to modify the location of the database files, My.ini location as follows:C:\ProgramData \mysql\mysql Server 5.6\my.ini, Note that not in C:\Program files\mysql\mysql server 5.6, There is only one my-default.ini, which is not the same place as before, I think the main modification of the following several configurations:

Basedir= "C:/Program files/mysql/mysql Server 5.6/"-If you want to change this path in a no-install mode, the path will be changed to the MySQL directory

DataDir =d:\mysqldata--Change database file storage location is: D:\MySQLData

character-set-server=utf8--Change the database character set to: UTF8 (now the default is UTF8, if not modify, avoid Chinese garbled)

Fifth step: After the modified My.ini file is saved, copy the files from the original database directory to the new custom database directory (for example: D:\MySQLData), and then restart the MySQL service.

With the installation version is relatively simple, the relevant development environment will be automatically configured or installed, such as: Mysql-connector-net, Mysql-for-visualstudio, mysql-workbench-community, etc., So that we can directly carry out the relevant development operations, of course, if not adopted. NET development, perhaps some components do not need to install, it should be installed in the installation of a custom installation, or the following to be described in the installation-free mode + Install the appropriate plug-in and tool form.

MySQL free installation version operating instructions

Because the online already has the related post to explain, then this direct link: http://www.cnblogs.com/dazhaxie/p/3592494.html, for everybody reference!

A brief description of how MySQL database is installed and related settings