美文网首页
mysql8解压版安装

mysql8解压版安装

作者: 志华2020 | 来源:发表于2019-05-10 13:31 被阅读0次

1、下载

下载mysql8

2、安装

① 解压到需要安装的目录,然后新建一个my.ini(位于解压目录下,与bin目录在同一个目录下)


# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/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 = D:\\hzhh123\\mysql8.0
 datadir = D:\\hzhh123\\mysql8.0\data
 port = 3308
server_id = 1
 
 
# 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 

② 执行命令生成data文件和密码

mysqld --defaults-file=D:\hzhh123\mysql8.0\my.ini --initialize --console

③ 安装服务

mysqld install mysql8  --defaults-file="D:\hzhh123\mysql8.0\my.ini

mysql8是服务名
④登录,修改密码

mysql -uroot -p -P3308

然后输入密码,最后修改密码

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; 

3、参考

https://blog.csdn.net/Mint6/article/details/81038536

相关文章

  • windows下mysql使用独立data目录方法

    注意,适用于mysql5.7或mariadb10,不适用于mysql8 解压绿色版(或安装版安装时选择不创建实例)...

  • mysql8解压版安装

    下载后解压缩 bin文件夹配置到path 根目录下新建my.ini 内容为 cmd移动到根目录 开始执行命令 my...

  • mysql8解压版安装

    1、下载 下载mysql8 2、安装 ① 解压到需要安装的目录,然后新建一个my.ini(位于解压目录下,与bin...

  • CentOS7下安装Mysql8

    Mysql8解压版安装总结: 前文连接:CentOS7环境搭建 说明:为了接下来大数据Sqoop组件的使用,在此总...

  • Windows安装mysql8解压版

    下载 https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysq...

  • mysql 8.0 解压版安装与配置

    mysql 安装 到官网下载解压版解压到本地:下载windows解压版mysql 在安装路径下创建:my.ini ...

  • Mysql 安装启动并修改密码

    一、下载,解压,并安装里面各种RMP包及其依赖 Mysql8 地址:https://dev.mysql.com/g...

  • MySQL数据库免安装版

    MySQL 8.0.22解压版安装 一、下载安装包 1、官网下载免安装版的社区版; 2、解压文件,存放路径不要出现...

  • MySQL安装与卸载

    MySQL安装与卸载【==版本5.7+==】? [TOC] 下载MySQL解压版? 官网-下载下载解压版,解压后放...

  • Windows环境Mysql安装配置

    安装(解压) ZIP Archive版是免安装的。只要解压就行了。和安装版的没什么不同,但就是不需要安装。找到下载...

网友评论

      本文标题:mysql8解压版安装

      本文链接:https://www.haomeiwen.com/subject/lpfaoqtx.html