MySQL Decompression version installation

1. after decompression, add MySQL to the environment variable path:

D:\Java\mysql

2. Modify the My-default.ini file

# These is commonly set, remove the # and set as required. Basedir = D:\Java\mysql DataDir = d:\java\mysql\data# Port = .... # server_id = ... # Remove leading # to set options mai nly useful for reporting servers.# the server defaults is faster for transactions and fast selects.# Adjust sizes as need Ed, experiment to find the optimal values.# join_buffer_size = 128m# Sort_buffer_size = 2m# read_rnd_buffer_size = 2M sql_ Mode=no_engine_substitution,strict_trans_tables #服务端的编码方式character-set-server=utf8[client] #客户端编码方式, It's best to keep the server consistent loose-default-character-set = UTF8

3. Install MySQL service:

Command: Mysqld-install

4. Start the MySQL service:

net start MySQL

5. Log in to MySQL:

Execute "mysql-u root-p", prompt to enter the password, because the first run, the password is empty can be directly enter.

6. Set Root password:

This command is executed under the bin of MySQL, command to enter after the output, and then prompt for the password, is to let enter the old password, the old password is empty, the direct return can be.

Command: mysqladmin-u root-p password < new password >

7. Test the new Password connection:

MySQL Decompression version installation