MySQL-5.6.xx-winx64 installation-Free Edition configuration method,

Source: Internet
Author: User

MySQL-5.6.xx-winx64 installation-Free Edition configuration method,

MySQL-5.6.xx-winx64 installation-free configuration method
1. Download Mysql-5.6.xx-winx64 from the mysql official website.
2. decompress the MySQL package
Decompress the downloaded MySQL package to a custom directory, such as: D: \ Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64
Copy the configuration file my-default.ini In the extracted directory, rename my. ini, and copy the following configuration information to my. ini
# If there is no my-default.ini, you can create my. ini yourself or get it from somewhere else
######################################## #################
[Client]
Port = 3306
Default-character-set = utf8
[Mysqld]
Port = 3306
Character_set_server = utf8
# Decompress the Directory
Basedir = D: \ Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64
# Decompress the data directory in the directory
Datadir = D: \ Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64 \ data

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
[WinMySQLAdmin]
Unzip the mysqld.exe directory under the decompressed directory
D: \ Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64 \ bin \ mysqld.exe
######################################## #################
3. Add Environment Variables
Input variable name: MYSQL_HOME
Input variable values: D: \ Program Files \ mysql-5.6.xx-winx64; % MYSQL_HOME % \ bin
4. Register mysql as a windows system service
Log on to the MySQL extract directory bin directory from the console:
D:
Cd Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64 \ bin
Install services
Mysqld install MySQL -- defaults-file = "D: \ Program Files (x86) \ MySQL \ mysql-5.6.xx-winx64 \ my. ini"
5. Start the MySQL Service
Net start mysql
6. When the installation of MySQL is complete, the default password of the root account is blank and can be modified by yourself.
Mysql-u root

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.