準(zhǔn)備:
創(chuàng)新互聯(lián)于2013年成立,先為高昌等服務(wù)建站,高昌等地企業(yè),進(jìn)行企業(yè)商務(wù)咨詢服務(wù)。為高昌企業(yè)網(wǎng)站制作PC+手機(jī)+微官網(wǎng)三網(wǎng)同步一站式服務(wù)解決您的所有建站問(wèn)題。MySQL8.0 Windows zip包下載地址:https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip
環(huán)境:Windows 10
一、安裝
1. 解壓zip包到安裝目錄
我的安裝目錄是D:\Program Files\mysql-8.0.11-winx64
2.配置文件
windows系統(tǒng)中配置文件默認(rèn)是安裝目錄下的 my.ini 文件,部分配置需要在初始安裝時(shí)配置,大部分也可以在安裝完成后進(jìn)行更改,不知道別人是什么情況,我的是該文件目錄下不存在my.ini文件,所以我新建了該文件,如下
寫入基本配置如下:
[mysqld] default_authentication_plugin=mysql_native_password # 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\mysql-8.0.11-winx64 datadir=D:\Program Files\mysql-8.0.11-winx64\data(這兩行是主要修改的內(nèi)容,會(huì)自動(dòng)生成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 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES character-set-server = utf8mb4 performance_schema_max_table_instances = 600 table_definition_cache = 400 table_open_cache = 256 [mysql] default-character-set = utf8mb4 [client] default-character-set = utf8mb4
分享文章:windows10+mysql8.0.11zip安裝教程詳解-創(chuàng)新互聯(lián)
本文地址:http://bm7419.com/article26/cdehjg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供品牌網(wǎng)站制作、自適應(yīng)網(wǎng)站、網(wǎng)站營(yíng)銷、搜索引擎優(yōu)化、品牌網(wǎng)站設(shè)計(jì)、電子商務(wù)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容