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

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.