1 设置环境变量 path F:\mysql-5.1.34-winx64\bin
2 my.ini 中设置 (设置数据库编码 character_set_server = utf8)
basedir=D:/Program Files (x86)/MySql # 设置mysql的安装目录
datadir=D:/Program Files (x86)/MySql/data
3 mysqld --install MySQL --defaults-file="D:\Program Files(x86)\MySql\my.ini"
4 cmd net start MySQL ( 启动服务器)
5 mysql -u root -p 默认密码为空白 登入后 然后修改密码 mysqladmin -u root -p password root
使用 root用户登录 ,命令记得结尾加分号
6 mysql -u root -p root
7 create database;
8 use database ;
9 source f:/**.sql;
10 关闭服务
SET character_set_client = utf8; SET character_set_connection = utf8; SET character_set_database = utf8; SET character_set_results = utf8; SET character_set_server = utf8; 然后 mysql> SHOW VARIABLES LIKE 'character%'; 你可以看到全变为 utf8
=========================
mysqld -nt --install 启动mysql服务
1 mysql -uroot -p 输入 root
2 show databases;
3 create database dbname;
5 use databasename
6 source f:/db.sql;
7 show tables