Get the App
SLTechnology News&Howtos  ›  Database  › 

Simplified installation method of MySQLzip package under Windows

Shulou Source: shulou.com Published: 2022-06-01 18:59:06 11月17日 Update

The following mainly brings you the simplified installation method of MySQLzip package under Windows. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the installation method of MySQLzip package under Windows. All right, don't talk too much nonsense, let's just read the following.

Using this method, the zip installation package of MySQL can be reduced from more than 300m to 6m.

MySQL download address

Https://dev.mysql.com/downloads/mysql/

Streamlining process

1. Only [data/bin/share] and my-default.ini are left in the root directory.

2. Only [mysqladmin / mysql / mysqld] exe file is left under bin

3. Leave only the [charsets / english] directory and all the files under the share.

4. Only the [mysql] directory and all its files are left under data.

Modify the configuration file

[mysqld]

Basedir=C:\ Program Files\ MySQL\ MySQL Server 5.6

Datadir=C:\ Program Files\ MySQL\ MySQL Server 5.6\ data

Character_set_server=utf8

Init_connect = 'SET NAMES utf8'

Collation-server=utf8_general_ci

# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Port = 3306

[client]

Port = 3306

Default-character-set = utf8

Host=localhost

User='root'

Password='root'

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128m

[mysql]

Default-character-set = utf8

Delete the last line

Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Installation process:

Extract the MySQL.zip package to C:\ Program Files

two。 Add MySQL environment variable

Turn on the computer and select system Properties.

Select advanced system settings

Select "Advanced", "Environment variable".

Add environment variabl

Add C:\ Program Files\ MySQL\ MySQL Server 5.6\ bin to the Path, separated by;.

3. Installation

Cmd runs with administrator privileges

Cd C:\ Program Files\ MySQL\ MySQL Server 5.6\ bin

Mysqld-- install MySQL-- defaults-file= "C:\ Program Files\ MySQL\ MySQL Server 5.6\ my-default.ini"

4. Start the service

Enter net start mysql (stop service is stop)

5. Log in

Enter mysql and enter directly.

For the above about the simplified installation method of MySQLzip package under Windows, do you think it is very helpful? If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Tags: File method content variable environment selection advanced following directory system process under it service input line address actual property nonsense more Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Apple Linux Docker Shulou Tech Info