win1064位怎么安裝masql

首先是下載 mysql-installer-community-5.6.14.0.msi ，大家可以到 mysql 官方網(wǎng)去下載。

創(chuàng)新互聯(lián)專注為客戶提供全方位的互聯(lián)網(wǎng)綜合服務(wù)，包含不限于網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計、昌平網(wǎng)絡(luò)推廣、微信平臺小程序開發(fā)、昌平網(wǎng)絡(luò)營銷、昌平企業(yè)策劃、昌平品牌公關(guān)、搜索引擎seo、人物專訪、企業(yè)宣傳片、企業(yè)代運營等，從售前售中售后，我們都將竭誠為您服務(wù)，您的肯定，是我們最大的嘉獎；創(chuàng)新互聯(lián)為所有大學(xué)生創(chuàng)業(yè)者提供昌平建站搭建服務(wù)，24小時服務(wù)熱線：18980820575，官方網(wǎng)址：sd-ha.com

win10的安全機制比較嚴(yán)格，安裝前最好到設(shè)置--更新和安全--針對開發(fā)人員 選擇 《開發(fā)人員模式》

下載好 mysql 安裝文件之后就對它進(jìn)行運行安裝，運行之后就會出現(xiàn)如下的安裝界面。

3

當(dāng)加載完成之后就到了 MySQL install 的安裝的歡迎界面了，在這里有幾個選項，下面的兩項別管，點擊“Install MySQL Products”就行了。

4

這時安裝步驟來到了使用協(xié)議的地方的，全是英文，別管，再看我們也不懂，看重點就行了。

在“I accept the license terms”（我接受許可條款）的前面給打上勾，然后點擊右下邊的“Next”（下一步）來進(jìn)行下一步的操作。

5

這一步是要求我們在安裝前先檢查是否有新的版本，在這里我們選擇跳過吧，不用檢查了，浪費時間，如果你覺得有必要也可以對新版本進(jìn)行檢查。

在“Skip ths check for updates (not recommended)”（跳過這個檢查更新(不推薦)）前給打上勾，然后點擊“Next”（下一步）來進(jìn)行下一步的操作。

64位Win10怎么安裝MySQL5.6.35

1、解壓縮,比如到d:\，為了方便，改一下路徑，比如mysql

2、開始/運行，輸入cmd，回車進(jìn)入命令行

d:

cd mysql\bin

安裝mysql服務(wù)

mysqld.exe --install (默認(rèn)服務(wù)名稱是mysql或者mysqld.exe --install "mysql5"修改服務(wù)名稱)

刪除mysql服務(wù)

mysqld.exe --remove(或者mysqld.exe --remove "mysql5")

3、ini參數(shù)配置文件d:\mysql\

復(fù)制mysql-small.ini為my.ini

4、啟動停止服務(wù)

a)在命令行啟動/停止

net start mysql

net stop mysql

b)或者去控制面板找服務(wù)啟動

c)或者開始/運行輸入services.msc，確定后，找到mysql啟動

win764位系統(tǒng)怎么安裝mysql

1、 MySQL Community Server 5.6.10

2、解壓到d:\MySQL.（路徑自己指定）

3、在d:\MySQL下新建my.ini配置文件，內(nèi)容如下：

*****************配置文件開始*********************

# MySQL Server Instance Configuration File

#----------------------------------------------------------------------

# Generated by the MySQL Server Instance ConfigurationWizard

#

#

# Installation Instructions

#----------------------------------------------------------------------

#

#

# CLIENT SECTION

#----------------------------------------------------------------------

#

# The following options will be read by MySQL clientapplications.

# Note that only client applications shipped by MySQLare guaranteed

# to read this section. If you want your own MySQLclient program to

# honor these values, you need to specify it as anoption during the

# MySQL client library initialization.

#

[client]

port=3306

[mysql]

default-character-set=gbk

# SERVER SECTION

#----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server.Make sure that

# you have installed the server correctly (see above)so it reads this

# file.

#

[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=3306

#Path to installation directory. All paths are usuallyresolved relative to this.

basedir="d:\MySQL\"

#Path to the database root

datadir="d:\MySQL\Data"

[WinMySQLadmin]

Server="d:\MySQL\bin\mysqld.exe"

# The default character set that will be used when anew schema or table is

# created and no character set is defined

default-character-set=gbk

# The default storage engine that will be used whencreate new tables when

default-storage-engine=INNODB

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# The maximum amount of concurrent sessions the MySQLserver will

# allow. One of these connections will be reserved fora user with

# SUPER privileges to allow the administrator to logineven if the

# connection limit has been reached.

max_connections=100

# Query cache is used to cache SELECT results andlater return them

# without actual executing the same query once again.Having the query

# cache enabled may result in significant speedimprovements, if your

# have a lot of identical queries and rarely changingtables. See the

# "Qcache_lowmem_prunes" status variable tocheck if the current value

# is high enough for your load.

# Note: In case your tables change very often or ifyour queries are

# textually different every time, the query cache mayresult in a

# slowdown instead of a performance improvement.

query_cache_size=0

# The number of open tables for all threads.Increasing this value

# increases the number of file descriptors that mysqldrequires.

# Therefore you have to make sure to set the amount ofopen files

# allowed to at least 4096 in the variable"open-files-limit" in

# section [mysqld_safe]

table_cache=256

# Maximum size for internal (in-memory) temporarytables. If a table

# grows larger than this value, it is automaticallyconverted to disk

# based table This limitation is for a single table.There can be many

# of them.

tmp_table_size=26M

# How many threads we should keep in a cache forreuse. When a client

# disconnects, the client's threads are put in thecache if there aren't

# more than thread_cache_size threads frombefore. This greatly reduces

# the amount of thread creations needed if you have alot of new

# connections. (Normally this doesn't give a notableperformance

# improvement if you have a good threadimplementation.)

thread_cache_size=8

#*** MyISAM Specific options

# The maximum size of the temporary file MySQL isallowed to use while

# recreating the index (during REPAIR, ALTER TABLE orLOAD DATA INFILE.

# If the file-size would be bigger than this, theindex will be created

# through the key cache (which is slower).

myisam_max_sort_file_size=100G

# If the temporary file used for fast index creationwould be bigger

# than using the key cache by the amount specifiedhere, then prefer the

# key cache method. This is mainly used to force long character keys in

# large tables to use the slower key cache method tocreate the index.

myisam_sort_buffer_size=52M

# Size of the Key Buffer, used to cache index blocksfor MyISAM tables.

# Do not set it larger than 30% of your available memory,as some memory

# is also required by the OS to cache rows. Even ifyou're not using

# MyISAM tables, you should still set it to 8-64M asit will also be

# used for internal temporary disk tables.

key_buffer_size=40M

# Size of the buffer used for doing full table scansof MyISAM tables.

# Allocated per thread, if a full scan is needed.

read_buffer_size=64K

read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuildthe index in

# REPAIR, OPTIMZE, ALTER table statements as well asin LOAD DATA INFILE

# into an empty table. It is allocated per thread sobe careful with

# large settings.

sort_buffer_size=256K

#*** INNODB Specific options ***

innodb_data_home_dir="d:\MySQL\Data\INNODB\"

# Use this option if you have a MySQL server withInnoDB support enabled

# but you do not plan to use it. This will save memoryand disk space

# and speed up some things.

#skip-innodb

# Additional memory pool that is used by InnoDB tostore metadata

# information. If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not needto change this

# value. SHOW INNODB STATUS will display the currentamount used.

innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) thetransaction logs to the

# disk at each commit, which offers full ACIDbehavior. If you are

# willing to compromise this safety, and you arerunning small

# transactions, you may set this to 0 or 2 to reduce diskI/O to the

# logs. Value 0 means that the log is only written tothe log file and

# the log file flushed to disk approximately once persecond. Value 2

# means the log is written to the log file at eachcommit, but the log

# file is only flushed to disk approximately once persecond.

innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering logdata. As soon as

# it is full, InnoDB will have to flush it to disk. Asit is flushed

# once per second anyway, it does not make sense tohave it very large

# (even with long transactions).

innodb_log_buffer_size=1M

# InnoDB, unlike MyISAM, uses a buffer pool to cacheboth indexes and

# row data. The bigger you set this the less disk I/Ois needed to

# access data in tables. On a dedicated databaseserver you may set this

# parameter up to 80% of the machine physical memorysize. Do not set it

# too large, though, because competition of thephysical memory may

# cause paging in the operating system. Note that on 32bit systems you

# might be limited to 2-3.5G of user level memory perprocess, so do not

# set it too high.

innodb_buffer_pool_size=77M

# Size of each log file in a log group. You should setthe combined size

# of log files to about 25%-100% of your buffer poolsize to avoid

# unneeded buffer pool flush activity on log fileoverwrite. However,

# note that a larger logfile size will increase thetime needed for the

# recovery process.

innodb_log_file_size=39M

# Number of threads allowed inside the InnoDB kernel.The optimal value

# depends highly on the application, hardware as wellas the OS

# scheduler properties. A too high value may lead tothread thrashing.

innodb_thread_concurrency=8

*****************配置文件結(jié)束*********************

配置文件也放在了附件里，大家可以根據(jù)需要修改。

重點是以下配置，其中datadir的目錄名稱必須是data，并且好像必須是MySQL目錄下的data.之前自己制定了其他目錄，一直出現(xiàn)1067的錯誤。

#Path to installation directory. All paths are usuallyresolved relative to this.

basedir="d:\MySQL\"

#Path to the database root

datadir="d:\MySQL\Data"

4、在windows環(huán)境變量里加入以下內(nèi)容（方便執(zhí)行命令行命令）

新建MYSQL_HOME="d:\MySQL\"

在Path里加入%MYSQL_HOME%\bin

5、將mysql注冊為windows系統(tǒng)服務(wù)。具體操作是在命令行中執(zhí)行以下命令：

mysqld install MySQL --defaults-file="d:\MySQL\my.ini"

移除服務(wù)為 mysqld remove

6、第5步成功后，在命令行啟動mysql

c:net start mysql

7、修改root的密碼為62386997

方法一：

c:mysql –uroot

mysqlshowdatabases;

mysqluse mysql;

mysql UPDATE user SET password=PASSWORD("62386997") WHEREuser='root';

mysql FLUSH PRIVILEGES;

mysql QUIT

《從0到1 最詳細(xì)的MySQL安裝流程(Window版)

??在進(jìn)入到官網(wǎng)下載的時候,我們會發(fā)現(xiàn)官網(wǎng)上提供了很多類型的版本,它們到底是什么意思,哪個才是我們需要的呢?下面就來簡單介紹下常見的,如下:

?? 1、MySQL Enterprise Edition: Mysql企業(yè)版本,包含了最新的特性和管理工具,以及可以提供技術(shù)支持( 但是是要收費 )。

?? 2、MySQL Cluster CGE: 一個用于高吞吐量快速、穩(wěn)定的訪問數(shù)據(jù)的開源事務(wù)數(shù)據(jù)庫,它包含了MySQL Cluster、MySQL Enterprise Edition、MySQL Cluster Manager的功能。

?? 3、MySQL Community (GPL) ：遵循GPL開源協(xié)議的MySQL版本,平常我們使用的大多數(shù)遵循這個協(xié)議下的社區(qū)版

?? 4、MySQL Installer : 是一個安裝管理程序,因為MySQL家族包括了許多產(chǎn)品,所以提供了一個統(tǒng)一管理下載的工具。

?? 5、MySQL Community Server : MySQL Community (GPL)下的開源社區(qū)版本,是使用的數(shù)據(jù)庫開源版本( 免費的,盤它 )。

?? 6、Mysql Workbench : 類似navicat是個圖形界面UI工具，可以實現(xiàn)遠(yuǎn)程Mysql數(shù)據(jù)庫訪問(一開始不建議直接使用圖形化管理工具,建議先通過命令行了解,這樣能夠更快的認(rèn)識Mysql, 高手都是用命令行的 (PS: 如有需要圖形化工具的可以私我))。

??到官網(wǎng)下載自己需要的版本()或者直接到云盤下載(私信我,這種方式更快),下載步驟如下:

?? 1、進(jìn)入MySQL官網(wǎng) =》選擇“DOWNLOADS”選項 =》 點擊MySQL Community (GPL) Downloads ?

?? 2、根據(jù)自己的需要選擇“MySQL Community Server(不帶圖形化界面-推薦)”或者M(jìn)ySQL Workbench(帶圖形化界面的)

?? 3、下載安裝包(32位電腦下載32位的安裝包,64位電腦下載64位的安裝包)

?? 4、解壓下載好的安裝包

?? 5、配置環(huán)境變量

?? 環(huán)境變量: 指的是當(dāng)你在命令行屬于任意一個值時,win系統(tǒng)會去環(huán)境變量池中匹配,如果有匹配到可執(zhí)行的路徑,則直接去對應(yīng)的路徑下進(jìn)行執(zhí)行 。

??如你輸入mysql,然后你在環(huán)境變量中配置了你安裝的MySQL路徑為:D:mysql8.xbin,則系統(tǒng)會匹配成D:mysql8.xbinmysql，如果這個目錄下有這個可執(zhí)行文件,則運行,具體步驟如下:。

?? 1、啟動MySQL服務(wù)器,并進(jìn)行登錄

?? 2、如果發(fā)現(xiàn)MySQL服務(wù)無法啟動,則進(jìn)行下面的配置即可

?? (1)、在mysql壓縮的路徑中添加以下my.ini文件,內(nèi)容如下(把其中的兩處工作路徑改為自己的按照路徑即可):

?? (2)、執(zhí)行執(zhí)行 mysqld --initialize-insecure 指令進(jìn)行配置，安裝路徑會默認(rèn)生成一個data文件夾，如下:

?? 3、輸入mysqld --install將mysql注冊到Window服務(wù)中，如果提示已經(jīng)存在則跳過

?? 4、啟動mysql服務(wù):net start mysql

?? 5、連接Mysql服務(wù): mysql -u root -p 回車(默認(rèn)密碼為空,輸入密碼時直接回車即可,為了安全性,記得修改密碼哦),到此Mysql安裝完成,可以隨便操作了！

?? 6、修改密碼,分為MySQL5.x版本和8.x版本,步驟如下:

??(1)、選中mysql數(shù)據(jù)庫: use mysql

??(2)、修改root用戶的密碼

?? 不積跬步，無以至千里；不積小流，無以成江海。今天播種努力的種子,總會有一天發(fā)芽!

windows7 64位怎么安裝mysql

下載MySQL Community Server 5.6.13

解壓MySQL壓縮包

將以下載的MySQL壓縮包解壓到自定義目錄下,我的解壓目錄是:

"D:\Program Files\MySQL\mysql-5.6.13-win32"

添加環(huán)境變量

操作如下：

1）右鍵單擊我的電腦-屬性-高級系統(tǒng)設(shè)置(高級)-環(huán)境變量

點擊系統(tǒng)變量下的新建按鈕

輸入變量名：MYSQL_HOME

輸入變量值：D:\Program Files\mysql-5.6.11-winx64

#即為mysql的自定義解壓目錄。

2）選擇系統(tǒng)變量中的Path

點擊編輯按鈕

在變量值中添加變量值：%MYSQL_HOME%\bin

注意是在原有變量值后面加上這個變量，用;隔開，不能刪除原來的變量值，

MySQL下載及安裝教程

MySQL是一個跨平臺開源的關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，多用于中小型網(wǎng)站或系統(tǒng)的開發(fā)。軟件開發(fā)使用數(shù)據(jù)庫技術(shù)可以方便實現(xiàn)數(shù)據(jù)的共享，減少數(shù)據(jù)的冗余，也方便統(tǒng)一對數(shù)據(jù)進(jìn)行操作和控制。MySQL相對于Oracle、DB2等大型數(shù)據(jù)庫具有體積小、速度快、成本低的特點，這些特性使得MySQL在開源世界大受歡迎。下面我?guī)ьI(lǐng)大家去學(xué)習(xí)mySQL的下載及安裝。

工具/材料

Windows 操作系統(tǒng)

MySQL有兩個不同的版本， MySQL Community Server 是免費的社區(qū)版，MySQL Enterprice Server是企業(yè)版服務(wù)器，該版本需要付費，官方會提供技術(shù)支持。小型的軟件開發(fā)或者自己學(xué)習(xí)使用，我們下載免費的社區(qū)版即可。我們在搜狗搜索框中輸入mysql官網(wǎng)，進(jìn)入到如下的頁面，點擊DOWNLOADS--Community。

我們在跳轉(zhuǎn)的頁面選擇MySQL Community Downloads下方的DOWNLOAD按鈕，選擇Windows版本的安裝包，我們選擇MSI格式的安裝包，點擊Go to Download按鈕，如下圖所示。安裝包只能選擇32位的，即便本機是64位的操作系統(tǒng)也沒有關(guān)系，圖中有兩個安裝版本，第一個版本在線安裝，第二個下載的版本離線安裝。我們在安裝的過程中不需要登錄，選擇No thanks, just start my download。

安裝包下載完成后，我們點擊右鍵進(jìn)行安裝，安裝過程中License Agreement選擇I accept the licence terms。安裝類型選擇Server only,執(zhí)行過程如下圖所示。

安裝過程中，我們可以看到默認(rèn)端口號是3306，接下來我們需要輸入密碼，密碼不要設(shè)置太弱。安裝過程中我們勾選開機自啟動，如下圖所示。執(zhí)行安裝我們選擇Execute,然后便是開始等待安裝即可。

安裝完成后，我們找到本機的MySQL的客戶端工具，這是一個命令行工具，可以執(zhí)行sql命令，但不能用于復(fù)雜的開發(fā)工作，使用這個工具可以幫我們快速入門mysql數(shù)據(jù)庫。

我們打開這個客戶端軟件，輸入完密碼后，便可以看到光標(biāo)處的mysql， 輸入show databases可以看到默認(rèn)的數(shù)據(jù)庫有哪些。其他的sql命令也很多，我們便不再一一列舉了。

特別提示

安裝過程中可能會提示Microsoft Visual C++ 2015 沒有安裝之類的，我們在線等待安裝完成即可，這個時間可能有點久，請耐心等待。

本文標(biāo)題：包含64位怎么下載mysql的詞條
文章源于：http://sd-ha.com/article12/doosddc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供自適應(yīng)網(wǎng)站、網(wǎng)站收錄、網(wǎng)站設(shè)計公司、云服務(wù)器、網(wǎng)站營銷、定制開發(fā)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)