Question

如何在windows里面安装MySQL

Answer 1

其实很简单，下载mysql的绿色版，放在某个文件夹
然后修改my.ini

# 设置mysql客户端的字符集
default-character-set=utf8
[mysqld]
# 设置mysql的安装目录
basedir=D:/DEV/Mysql
# 设置<a href="https://www.baidu.com/s?wd=mysql%E6%95%B0%E6%8D%AE%E5%BA%93&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3nHDLPAcdPW9-mW0kmWDL0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnWDkrHDzrHnzPjcdnWn4rjnYPs" target="_blank" class="baidu-highlight">mysql数据库</a>的数据的存放目录，必须是data，或者是\\xxx-data
datadir=D:/DEV/Mysql/data
# 设置mysql服务器编码
character_set_server=utf8
# 设置mysql服务器字符集
collation-server=utf8_general_ci
[WinMySQLAdmin]
# 指定mysql服务启动启动的文件
Server=D:/DEV/Mysql/bin/mysqld-nt.exe

2、添加/删除服务添加：D:\DEV\Mysql\bin>mysqld --install mysql --defaults-file=D:\DEV\Mysql\my.ini删除：D:\DEV\Mysql\bin>mysqld -remove3、启动/关闭服务启动：D:\DEV\Mysql\bin>net start mysql关闭：D:/DEV/Mysql/bin/mysqladmin -u root shutdown