《Mysql實例mysql安裝詳細指南》要點：
本文介紹了Mysql實例mysql安裝詳細指南，希望對您有用。如果有疑問，可以聯系我們。

MYSQL學習2.安裝MySQL,我安裝在D:\MySQL\MySQL Server 5.7目錄下

MYSQL學習3.將目錄下的默認文件 my-default.ini 改名 為my.ini

MYSQL學習4.打開my.ini,添加配置：

MYSQL學習??? [WinMySQLAdmin]
??? Server=D:\MySQL\MySQL Server 5.7\bin\mysqld.exe

MYSQL學習??? [mysqld]

MYSQL學習??? basedir = D:\MySQL\MySQL Server 5.7
??? datadir = D:\MySQL\MySQL Server 5.7\data
??? port = 3306
??? server_id = 1
??? max_connections=1024

MYSQL學習??? log_bin = mysql-bin
??? explicit_defaults_for_timestamp = TRUE
????sql_mode=ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,

MYSQL學習?????????? ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES

MYSQL學習5.在D:\MySQL\MySQL Server 5.7目錄下創建data文件夾用來存放數據

MYSQL學習6.我的電腦->屬性->高級系統設置(高級)->環境變量,

MYSQL學習??? 添加MYSQL_HOME變量,值為D:\MySQL\MySQL Server 5.7

MYSQL學習??? 在Path變量中添加%MYSQL_HOME%\bin用分號(；)隔開

MYSQL學習7.cmd進入到bin下輸入初始化命令(管理員方式打開cmd)：

MYSQL學習??? D:\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=mysql --console

MYSQL學習?? 2016-08-07T02:57:11.678911Z 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.
2016-08-07T02:57:11.678911Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-08-07T02:57:16.351247Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-08-07T02:57:17.335589Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-08-07T02:57:18.054363Z 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: a700687c-5c4a-11e6-830e-e89a8ffd15e0.
2016-08-07T02:57:18.132545Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-07T02:57:18.210786Z 1 [Note] A temporary password is generated for root@localhost: dei05oKloX)k

MYSQL學習?? 此時產生一個隨機密碼請記住：dei05oKloX)k

MYSQL學習???如果出現如下告警,:

MYSQL學習????????? 2016-08-07T02:19:28.889373Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

MYSQL學習?? 檢查你的my.ini 中explicit_defaults_for_timestamp = TRUE是否配置正確

MYSQL學習????????? 2016-08-07T02:19:28.904984Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.

MYSQL學習?? 這是前面安裝失敗導致D:\MySQL\MySQL Server 5.7\data下產生了舊數據,將舊數據刪掉.

MYSQL學習8.cmd進入bin輸入安裝命令：

MYSQL學習?????????? D:\MySQL\MySQL Server 5.7\bin>mysqld --install
?????????? Service successfully installed.

MYSQL學習?? 表示安裝成功

MYSQL學習9.cmd進入bin輸入啟動命令：

MYSQL學習?????????? D:\MySQL\MySQL Server 5.7\bin>net start MySQL
????????? ?MySQL 服務正在啟動 ..
?????????? MySQL 服務已經啟動成功.

MYSQL學習10.cmd進入bin輸入進入mysql命令：

MYSQL學習????????? ?D:\MySQL\MySQL Server 5.7\bin>mysql -u root -p

MYSQL學習?????????? Enter password:輸入第7步產生的隨機密碼

MYSQL學習?

MYSQL學習?

MYSQL學習?????出現mysql>表示成功進入到了mysql

MYSQL學習11.對初始的隨機密碼進行修改

MYSQL學習?????????? mysql>set password for root@localhost = password('root')；

MYSQL學習?????????? Query OK, 0 rows affected, 1 warning (0.25 sec)

MYSQL學習?????????? 將root用戶的初始隨機密碼修改為root(自己設定的密碼)

MYSQL學習12.查看數據庫mysq>show databases;

MYSQL學習+--------------------+
| Database?????????? |
+--------------------+
| information_schema |
| myoneweb?????????? |
| mysql????????????? |
| performance_schema |
| sys??????????????? |
+--------------------+

MYSQL學習恭喜你至此你已經成功安裝完MySQL!

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/5788.html