MySQL-5.6.25 database installation-free configuration, mysql-5.6.25 installation-free

Source: Internet
Author: User

MySQL-5.6.25 database installation-free configuration, mysql-5.6.25 installation-free

Recently, when I was in contact with the MySql database and started the installation, I was always prompted that the configuration file could not be written during the execute operation. I tried several times and searched for some solutions, some people say that the installation directory contains Chinese characters, and then they have tried some other solutions, which is still fruitless. Therefore, select MySql without installation, and then configure some data. The specific configuration is as follows:

I. Decompress

Decompress the downloaded installation package to a path. Here my decompression path is: D: \ mysql-5.6.25-winx64

2. Complete my. ini configuration

Open the decompressed file, create a new my. ini file, and copy the following content to it:

######################################## #########################

[Client]
Port = 3306
Default-character-set = utf8
[Mysqld]
Port = 3306
Character_set_server = utf8
Basedir = D: \ mysql-5.6.25-winx64
# Decompress the Directory
Datadir = D: \ mysql-5.6.25-winx64 \ data
# Decompress the data directory in the directory
SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
[WinMySQLAdmin]
D: \ mysql-5.6.25-winx64 \ bin \ mysqld.exe

######################################## ############################

Note that you need to replace your own decompression path.

3. Add Environment Variables

1. My computer-right-click Properties-advanced system settings-Environment Settings

Create a system variable named MYSQL_HOME.

Variable: D: \ mysql-5.6.25-winx64

2. Add the following items to the path environment variable. Remember to add the ';' sign.

% MYSQL_HOME % \ bin

In this way, the configuration is successful. Next, we need to install the MySql service in the cmd window.

Iii. Install services

1. Open the dos window and go to your own decompression path:

Go to the bin directory and continue entering: mysqld install MySQL -- defaults-file = "D: \ mysql-5.6.25-winx64 \ my. ini"

If the registration is successful, the MySql database is successfully installed.

So far, all MySql configurations have been completed, and you only need to start the service again.

Start service command: net start mysql

You can also right-click my computer to manage and start the mysql service!


Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.

Related Article

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.