2024年5月30日发(作者:)

安装mysql过程:

mysql解压版安装步骤

1.下载,解压到E盘(E:mysql-5.1.50-win32)。

2.复制为。

3.修改,在[client]、[mysqld]、[mysql]后面加default-character-set = utf8,

在[mysqld]下加,basedir、datadir。

[client]

default-character-set = utf8

[mysqld]

default-character-set = utf8

default-collation=utf8_bin

init_connect='SET NAMES utf8'

basedir=E:mysql-5.1.50-win32 // 此处两目录需指向安装目录

datadir=E:mysql-5.1.50-win32data // 此处两目录需指向安装目录

[mysql]

default-character-set=utf8

4.安装mysql服务。(移除mysql服务mysqld --remove)

命令行下进入E:mysql-5.1.50-win32bin,运行mysqld --install mysql

--defaults-file="E:"。

E:mysql-5.1.50-win32bin>mysqld --install mysql

--defaults-file="E:"

Service successfully installed.

注:要加参数安装,不然mysql administrator启动时将提示:

Either the server service or the configuration file could not be p

variable and service section are there for disabled.

进入后提示:

This section is only avaliable when connected to localhost

5.启动mysql服务.(停止mysql服务net stop mysql)

E:mysql-5.1.50-win32bin>net start mysql