MYSQL8.0,MySQL 5.7.9 免安裝配置

 2023-11-18 阅读 25 评论 0

摘要:環境:win10 64位?mysql版本:mysql-5.7.9-winx64.zip (http://dev.mysql.com/downloads/mysql/) 首先聲明一下,5.7.9這個版本的配置方式跟之前的免安裝版配置不一樣。(.msi安裝版和其他版本的可以忽略該方法)?步驟:?1,在官網上下載了

環境:win10 64位?
mysql版本:mysql-5.7.9-winx64.zip (http://dev.mysql.com/downloads/mysql/)

首先聲明一下,5.7.9這個版本的配置方式跟之前的免安裝版配置不一樣。(.msi安裝版和其他版本的可以忽略該方法)?
步驟:?
1,在官網上下載了mysql-5.7.9-winx64.zip 這個文件之后, 解壓到指定目錄:F:\Java\mysql\mysql-5.7.9-winx64?
2,在F:\java\mysql\mysql-5.7.9-winx64 目錄創建data文件夾?
3,將my.default.ini改名為my.ini放到bin目錄,并且在my.ini目錄加入如下代碼:?
basedir = F:\java\mysql\mysql-5.7.9-winx64?
datadir = F:\java\mysql\mysql-5.7.9-winx64\data?
port = 3306?
4,配置環境變量,path=F:\java\mysql\mysql-5.7.9-winx64\bin?
5,以管理員權限打開命令行,進入到F:\java\mysql\mysql-5.7.9-winx64\bin目錄,?
執行: mysqld –initialize –user=mysql –console?
6,先執行以上命令, 會生成庫. 注意有個臨時密碼, 要記下來.

F:\java\mysql\mysql-5.7.9\bin>mysqld --initialize --user=mysql --console
2015-11-03T02:12:10.856918Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-11-03T02:12:10.856918Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2015-11-03T02:12:10.856918Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2015-11-03T02:12:14.162565Z 0 [Warning] InnoDB: New log files created, LSN=45790 2015-11-03T02:12:14.884331Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2015-11-03T02:12:15.123784Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4d177d5b-81d0-11e5-bb66-c454443dc023. 2015-11-03T02:12:15.176861Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2015-11-03T02:12:15.189872Z 1 [Note] A temporary password is generated for root@localhost: v2toK7w,TJ_< 

?

7,如本次執行的臨時密碼是:v2toK7w,TJ_<?
8, 執行安裝服務命令: mysqld –install?
9,執行啟動服務命令: net start mysql?
10,到此,mysql就安裝好了。 然后執行:mysql -uroot -p?
11,輸入剛才的密碼:v2toK7w,TJ_<?
12,執行改密碼命令:set password = password(‘password’)?
13,至此,就root賬號的密碼就被你改成password了

MYSQL8.0。轉載于:https://www.cnblogs.com/qiri07/p/5485396.html

版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。

原文链接:https://hbdhgg.com/1/174708.html

发表评论:

本站为非赢利网站,部分文章来源或改编自互联网及其他公众平台,主要目的在于分享信息,版权归原作者所有,内容仅供读者参考,如有侵权请联系我们删除!

Copyright © 2022 匯編語言學習筆記 Inc. 保留所有权利。

底部版权信息