mysql-5.7.15-winx64 配置(ZIP绿色)
来源:互联网 发布:apache tomcat 7 下载 编辑:程序博客网 时间:2024/05/06 19:17
教程使用是ZIP绿色版本,下载地址:点击下载
1、解压到非中文路径, 在根目录下新建 data文件夹
2、修改 my.ini ( 复制my-default.ini)
# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/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.#mysql根目录 basedir =F:\java\mysql-5.7.15-winx64#数据文件存放目录 datadir =F:\java\mysql-5.7.15-winx64\data# port = 3306# 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 #服务端的编码方式[client]default-character-set=utf8[mysqld]# 设置mysql服务器编码character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
3、cmd (管理员)
4、初始化
在打开的cmd面板,转到安装目录下的bin文件夹,然后初始化数据库,此时密码为空:
mysqld --initialize-insecure --user=mysql
文档表明,使用-initialize生成随机密码,由于自己学习,使用-initialize-insecure生成空密码。默认帐号root,后面的-user=mysql不更改
5、创建服务 mysqld --install
6、启动服务 net start mysql
7、进入数据库 mysql -u root -p
8、修改密码
mysql>update mysql.user set authentication_string=password('ycm12345') where user='root' and Host = 'localhost';
mysql> flush privileges;
mysql> quit;
附上MYSQL管理工具: 点击打开链接
0 0
- mysql-5.7.15-winx64 配置(ZIP绿色)
- mysql-5.7.11-winx64.zip 安装配置
- windows mysql-5.7.15-winx64解压版(zip版)安装配置教程
- mysql-5.7.15-winx64配置
- 配置mysql-5.7.15-winx64
- mysql-5.7.11-winx64.zip 安装配置说明
- windows 7下配置mysql-5.7.14-winx64.zip
- mysql-5.7.17-winx64.zip 的安装与配置
- mysql-5.7.17-winx64.zip 免安装版配置
- win7系统下载安装配置MySQL-5.7.19-winx64.zip
- mysql-5.7.17-winx64.zip 的安装与配置
- 免安装版的mysql5.7的安装和配置(mysql-5.7.18-winx64.zip)
- mysql5.7.17安装(mysql-5.7.17-winx64.zip)
- mysql-5.7.12-winx64.zip Windows (x86, 64-bit), ZIP Archive版免安装配置
- mysql-5.7.11-winx64.zip安装
- MySQL 5.7.13-winx64.zip安装笔记
- mysql-5.7.13-winx64.zip 安装
- mysql-5.7.16-winx64.zip安装教程
- java学习之匿名类
- linux下两台服务器文件实时同步方案设计和实现
- node.js中字符串相加还有html中字符串相加
- POJ 2828 线段树 逆序插入
- php gd imageaffine
- mysql-5.7.15-winx64 配置(ZIP绿色)
- 能够提高开发效率的Eclipse实用操作-第二篇
- 固定资产提完折旧之后应该怎么办呢
- 我对常见字符编码的体会心得
- Mybatis概述(一)
- json定义及jquery操作json
- nginx入门配置,及动静分离
- html获取选择checkbox个数
- 人件读书笔记(39)霍尔加丹斯克