Window配置Mysql5.6.14

最新推荐文章于 2024-10-11 10:39:20 发布

像风一样流离失所

最新推荐文章于 2024-10-11 10:39:20 发布

阅读量656

点赞数 1

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/lt01221/article/details/27096593

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1、解压mysql-5.6.14-winx64.zip到F:\Server重命名为mysql，将目录下的my-default.ini拷贝一个并且重命名为my.ini，修改内容如下：

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir=F:\Server\mysql

datadir=F:\Server\mysql\data

port=3306

character-set-server=utf8

#CREATE TABLE 语句的默认表类型，如果不自己指定类型，则使用下行的类型

default-storage-engine = InnoDB

server-id = 1

# 最大连接数量

max_connections = 500

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

然后将F:\Server\mysql\bin配置到环境变量Path

在cmd中bin目录底下执行mysqld -install（将mysql安装为windows服务）
如果之前有安装过的mysql的，需要删除之前版本，则要进行以下操作，否则跳过
net sotp mysql//停止服务
mysqld -nt -remove//删除
sc delete mysql//从系统中删除服务名
同时，需要在注册表中删除
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL目录
以及它的兄弟.............\ControlSet002\....................................
.........................\CurrentControlSet\................................
卸载mysql
执行命令：net start mysql 或者windows管理工具->服务里面找到MySql服务，并启动
在命令行中运行mysql -u root 进入数据库。
修改密码
输入mysql回车
mysql> use mysql;
mysql> update user set password=password('123456') where user='root';
刷新权限
mysql> flush privileges;
mysql> \q;退出

！！注意：安装时，如果是WIN7系统，可能出现：Install/Remove of the Service Denied!今天在win7下安装 mysql 运行 mysqld -install 时，居然出现Install/Remove of the Service Denied!WINDOW 7 跟 vista 都有这问题。因为他们的权限更严格。
解决方法是：
进入 C:\Window 找到CMD.EXE 右键选择以管理员身份进行，再进入相应目录执行命令。

欢迎加入258154984群 258154984