win 安装mysql
2024-08-25 01:58:47
windows上安装sql最容易出现 1067错误,网上查了很多,大部分都是误导。现在将验证过的步骤总结如下:
1.下载mysql,我用的是mysql-5.6.24-win32
下载后解压,进入到bin目录,修改配置文件。修改如下:
# 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 % of total RAM for dedicated server, else %.
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 = D:\Soft\Mysql\mysql-5.6.-win32
datadir = D:\Soft\Mysql\mysql-5.6.-win32\data
# port = .....
# server_id = ..... # 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
2.用管理员身份启动命令行工具,进入到bin目录下面
执行命令:
3.修改管理员密码
默认安装后用户root密码为空
可以用命令或者用第三方工具连接到mysql,到数据库mysql的user表中直接修改。
最新文章
- RPN-逆波兰计算器-中缀表达式转后缀表达式-javascript
- poj 1007:DNA Sorting(水题,字符串逆序数排序)
- 求1+2+3+...+n
- PAT (Basic Level) Practise:1009. 说反话
- ASP.NET MVC内置的Filter实现介绍
- ASP.NET服务器控件对应的HTML标签
- vim 编辑器 打开GB2312、GBK文件乱码解决方法
- N皇后摆放问题
- 一行代码搞定Adapter
- python-操作缓存
- HDU -2100-Lovekey
- 云计算之路-阿里云上:14:20-14:55博客后台2台服务器都CPU 100%引发的故障
- 【深入Java虚拟机】之八:Java垃圾收集机制
- 12.JavaScript字符串方法
- 安装wamp环境 最新完整版
- git批量修改已经提交的commit的姓名和邮箱
- UVa 11636 - Hello World! 二分,水题 难度: 0
- 随机重拍与抽样(random_shuffle,random_sample,random_sample_n)
- Go语言和ASP.NET的一般处理程序在处理WEB请求时的速度比较
- css3全屏背景显示