日期:2014-05-16  浏览次数:20813 次

Mysql安装配置

?

Mysql安装配置

1.???????下载mysql5.5.18绿色版,mysql下载官网:mysql.com。

2.???????解压到目录D:\mysql5.5.18。

3.???????将mysql添加到环境变量path:

;D:\ mysql5.5.18\bin

4.???????修改端口和字符集:在安装目录下找到my.ini配置文件打开编辑,把端口改成3306(注:安装的时候默认就是3306),并且把服务器的字符集改成utf8(注:注意版本),如下:

# 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 = 256M

max_allowed_packet = 1M

table_open_cache = 256