MySQL5.1版本免安装设置
注册服务
D:\MySql\MySQL5.1\bin\> mysqld-nt --install MySQL3310 --defaults-file=D:\MySql\MySQL5.1\my.ini
启动服务
D:\MySql\MySQL5.1\bin\> net start MySQL3310
删除服务
D:\MySql\MySQL5.1\bin\> mysqld-nt --remove MySQL3310 --defaults-file=D:\MySql\MySQL5.1\my.ini
停止服务
D:\MySql\MySQL5.1\bin\> net stop MySQL3310
检查MySQL中文乱码
SHOW VARIABLES LIKE 'character%';
临时设置
SET character_set_server = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
永久设置
配置my.ini设置
[client]
default-character-set=utf8
[mysqld]
basedir=D:/MySql/MySQL5.1
datadir=D:/MySql/MySQL5.1/data
port=3310
interactive_timeout=240
wait_timeout=240
character_set_server = utf8
注册服务
D:\MySql\MySQL5.1\bin\> mysqld-nt --install MySQL3310 --defaults-file=D:\MySql\MySQL5.1\my.ini
启动服务
D:\MySql\MySQL5.1\bin\> net start MySQL3310
删除服务
D:\MySql\MySQL5.1\bin\> mysqld-nt --remove MySQL3310 --defaults-file=D:\MySql\MySQL5.1\my.ini
停止服务
D:\MySql\MySQL5.1\bin\> net stop MySQL3310
检查MySQL中文乱码
SHOW VARIABLES LIKE 'character%';
临时设置
SET character_set_server = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
永久设置
配置my.ini设置
[client]
default-character-set=utf8
[mysqld]
basedir=D:/MySql/MySQL5.1
datadir=D:/MySql/MySQL5.1/data
port=3310
interactive_timeout=240
wait_timeout=240
character_set_server = utf8