Windows7 64 under Installation mysql-5.5.25

Target : Operating system is windows7 64 bit under Configuration mysql-5.5.25-winx64 (free installation version),: http://download.mysql.cn/src/2012/0602/5611.html

MySQL and mariadb

MARIADB is a branch of MySQL source code that has been separated after realizing what Oracle will do with MySQL license (MySQL was acquired by Sun and Oracle). In addition to being a "down substitute" for MySQL, MARIADB includes some of the new features that make it better than MySQL.

MySQL Version introduction

1. MySQL Community Server Community version, open source is free, but does not provide official technical support. This is also the version of MySQL that we usually use. Broken down into multiple versions based on different operating system platforms, let's take the Windows platform as an example.
2. MySQL Enterprise Edition is available for a fee and can be tested for 30 days.
3. MySQL Cluster Cluster Edition, open source free. Several MySQL servers can be packaged as one server.
4. MySQL Cluster CGE Premium Cluster edition, fees apply.
5. mysql Workbench (GUI tool) is a er/database modeling tool designed for MySQL. It is a successor to the famous database design tool DBDesigner4. MySQL Workbench is also divided into two versions, namely the Community Edition (MySQL Workbench OSS), the Business Edition (MySQL Workbench SE).

MySQL installation file preparation
First, the mysql-5.5.25-winx64.zip is extracted to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Web, the My-large.ini (and of course, depending on the circumstances, choose another INI configuration file) after the copy renamed to My.ini

This was mainly added in the [mysqld] segment:
#系统基本目录
Basedir= d:/mysql-5.5.25
#用户数据目录
Datadir= D:/mysql-5.5.25/data
#字符集设置
Character-set-server = UTF8
Added in the [client] segment:
Default-character-set = UTF8

MySQL Install Windows service
Locate the bin directory in the MYSQL5 installation directory and execute the Mysqld–install
In the cmd window
D: Enter
D:\mysql-5.5.25-winx64\bin> Mysqld–install
Install Windows Services successfully service successfully installed.
Start the MySQL service
d:\mysql-5.5.25-winx64\bin> net start MySQL
The service has started successfully.
Attached: command to install a MySQL Windows service: mysqld--install MySQL
Remove MySQL service: mysqld–remove MySQL
command to start the MySQL service: net start MySQL
Stop the MySQL service command: net stop MySQL
Change the empty password for MySQL default system user root to 12345 command: mysqladmin-u rootpassword "12345"
An easy way to do this is to add the MySQL bin path in the environment variable's path and then execute the MySQL command directly in the run.

Problems

Install MySQL under WinDOS cmd and execute it under the bin directory of MySQL: Mysqld-install

Error message: Install/remove of the Service Denied

Workaround: When opening the Cmd.exe program, select "Open With Administrator"

Graphical management tools
1. Mysql-workbench-gpl-5.2.40-win32-noinstall.zip after decompression to perform MySQLWorkbench.exe

2. Navicat for MySQL

Windows7 64 under Installation mysql-5.5.25