Because my computer only installed Windows system, so, only to organize the installation under the Windows system
More trouble, therefore, many quoted Baidu experience.
- Installing and configuring MySQL 5.6 under Windows platform
- Download, url: http://dev.mysql.com/downloads/mysql/#downloads at the bottom of the page, select the appropriate version (my is Windows (x86,64bit)), click Download.
- If you do not know what the configuration of your computer, you can refer to Baidu experience http://jingyan.baidu.com/article/a3a3f811997c7f8da2eb8a80.html
- You need to register an Oracle account to download. I am also very disgusted to download something, you have to register a eight life no need to account, every day by advertising bombing. So I used a non-used mailbox specially. I decided to share my Oracle account:[email protected] Password: My123456789
- Installation
- Double-click the downloaded Mysql-installer-community-5.6.22.msi file
- Click Install MySQL Product, and then the general steps to install the software. English is not good, want to divert, can refer to Baidu experience http://jingyan.baidu.com/article/f79b7cb3a25e759144023ee7.html
- Precautions
- When selecting the Server Configuration window, it is recommended that beginners select the "Development machine" option so that less resources are used to occupy the system
- The default user name for the system is root,
- Start the service and log in to the MySQL database
- During the previous configuration, MySQL was installed as a Windows service, and when Windows started and stopped, MySQL started automatically and stopped
- Start the MySQL service, refer to http://jingyan.baidu.com/album/eb9f7b6da47bcb869364e8c0.html
- Login Database
- MySQL Common graphics management tool
- MySQL Workbench Community Edition free, Business Edition yearly Fee: Http://dev.mysql.com/downloads/workbench
- PhpMyAdmin is written in PHP and must be installed in a Web server to control and manipulate the MySQL database via the web. http://www.phpmyadmin.net/
- NAVICAT supports triggers, stored procedures, functions, events, views, administrative users, and so on. It's also easy to use for beginners. Its well-designed GUI allows users to create, organize, access and share information in a safe and easy way. Navicat supports Chinese and is available for free version. Http://www.navicat.com
- Mysqldumper uses PHP-based MySQL database backup and recovery issues. The hundreds of trillion database can be easily backed up and restored without worrying about interruptions caused by slow internet speeds. Download Link: http://www.mysqldumper.de/en/
- SQLyog is a simple, efficient and powerful graphical MySQL database management tool. Using SQLyog, you can quickly and intuitively enable users to maintain remote MySQL databases from anywhere in the world via the network. : http://www.webyog.com/en/index.php
Learn MySQL1---MySQL installation and configuration from scratch (Windows only)