MySQL installation Configuration

MySQLInstall configurations

1.Download mysql5.5.18 Green Edition and MySQL Official Website: mysql.com.

2.Decompress the package to the Directory D: \ mysql5.5.18.

3.Add MySQL to the environment variable path:

; D: \ mysql5.5.18 \ bin

4.Modify the port and Character Set: Find My. open and edit the ini configuration file, change the port to 3306 (Note: The default value is 3306 during installation), and change the server character set to utf8 (Note: note version), as shown below:

# The following options will be passed to all MySQL clients

[Client]

# Password = your_password

Port = 3306

Socket =/tmp/MySQL. Sock

Default-character-set = GBK

 

# Here follows entries for some specific programs

 

# The MySQL Server

[Mysqld]

Port = 3306

Socket =/tmp/MySQL. Sock

Skip-locking

Key_buffer_size = 256 m

Max_allowed_packet = 1 m

Table_open_cache = 256

Sort_buffer_size = 1 m

Read_buffer_size = 1 m

Read_rnd_buffer_size = 4 m

Myisam_sort_buffer_size = 64 m

Thread_cache_size = 8

Query_cache_size = 16 m

# Try Number of CPU's * 2 for thread_concurrency

Thread_concurrency = 8

Default-character-set = utf8

Log_bin_trust_function_creators = 1

Note: My. iniThe configuration file must be available.

5.After the MySQL database is installed, find the data folder under its installation directory and paste the database file into the data folder. Start mysqld in the bin folder under the installation directory.