mysql 5.7.13安装
来源:互联网 发布:常州软件开发公司 编辑:程序博客网 时间:2024/06/06 03:50
安装多次均失败,原因竟是MYSQL服务名称不能含有数字!!!
1.复制my-defualt.ini文件改名为my.ini (my-defualt.ini可以删除)
2.my.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.[client] port=3306 default-character-set=utf8 [mysql]default-character-set=utf8[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 = d:/Program Files/phpStudy/MySQL57/ datadir = d:/Program Files/phpStudy/MySQL57/Data/ port = 3306explicit_defaults_for_timestamp = true # server_id = .....#服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server=utf8 collation-server=utf8_general_ci default-storage-engine=MyISAM# 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
3.配置环境变量
新增系统环境变量 MYSQL_HOME;写入值E:\tools\MySQL-5.7.14-win32
在path中中增加;%MYSQL_HOME%\bin;
4.初始化mysql服务
cmd
mysqld -install mysql名
5.初始化data文件包
mysqld --initialize --user=mysql --console
记录最后打印的密码,用于修改密码
net start mysql名
6.修改密码
执行 mysql -u root -p
输入上面打印的密码
7.修改密码
set password = password('123');
8.刷新权限
flush privileges;
9.退出
quit
0 0
- mysql 5.7.13安装
- 安装MySQL 5.7.13
- 二进制安装包安装mysql-5.7.13
- mysql-5.7.13-win32 安装
- 【Mysql】mysql-5.7.13-winx64 zip包安装过程
- Mac os 下安装 mysql 5.7.13
- Centos 7.2 安装 Mysql 5.7.13
- MySql 5.7.13 覆盖安装问题
- mysql 5.7.13安装与初步使用
- MySQL 5.7.13 ZIP Archive 安装
- mysql 5.7.13免安装版配置。
- mysql 5.7.13 linux 安装 配置
- MySQL 5.7.13-winx64.zip安装笔记
- mysql-5.7.13-winx64的安装
- mysql-5.7.13-winx64.zip 安装
- mysql-5.7.13 解压版安装教程
- 关于mac 安装 5.7.13 mysql问题
- mac下安装mysql 5.7.13
- 浅谈使用NGUI的界面架构(一)
- AFNetworking3.0判断网络状态
- JAVA Script 学习之通过setTimeout 实现钟表的效果
- Android各个版本代号及其特性
- leetcode 70. Climbing Stairs QuestionEditorial
- mysql 5.7.13安装
- 事件监听器_Demo02.java
- 毕向东Java视频学习笔记【day21-IO流<1>】
- 在不加载图片的情况下读取图片宽高
- Kafka消费者生产者编程模型(二)
- lightoj-1109 - False Ordering【思维】
- TextView的setTextSize和getTextSize单位不同
- day01开始学习Java的第一步
- 事件监听器_Demo03.java