管理-->服務和應用程序-->服務,查看是否有MySQL四、開始菜單-->附件-->命令提示符-->右鍵,一管理員身份運行五、cd/dE:\MySQL\binmysqld-installMySQL--defaults-fi" />

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

解壓版MySQL安裝說明

系統 1889 0

一、復制my.ini到MySQL解壓的目錄

例如:E:\MySQL

二、修改my.ini第39~40行

basedir = "E:\\MySQL"

datadir = "E:\\MySQL\\data"

三、檢查電腦上是否安裝過MySQL服務

我的電腦-->管理-->服務和應用程序-->服務,查看是否有MySQL

四、開始菜單-->附件-->命令提示符-->右鍵,一管理員身份運行

五、cd /d E:\MySQL\bin

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

提示成功安裝MySQL服務

六、我的電腦-->管理-->服務和應用程序-->服務,右鍵MySQL,點擊啟動。

如果啟動不成,請刪除E:\MySQL\data目錄下的對應文件

ib_logfile0

ib_logfile1

***.err

***.pid


32位MySQL:my.ini

      
         1
      
      
        # Example MySQL config file for small systems.


      
      
         2
      
      
        #


      
      
         3
      
       # This is for a system with little memory (
      
        <
      
      
        = 64M
      
      
        ) where MySQL is only used


      
      
         4
      
      
        # from time to time and it's important that the mysqld daemon


      
      
         5
      
      
        # doesn't use much resources.


      
      
         6
      
      
        #


      
      
         7
      
      
        # MySQL programs look for option files in a set of


      
      
         8
      
      
        # locations which depend on the deployment platform.


      
      
         9
      
      
        # You can copy this option file to one of those


      
      
        10
      
      
        # locations. For information about these locations, see:


      
      
        11
      
      
        # http://dev.mysql.com/doc/mysql/en/option-files.html


      
      
        12
      
      
        #


      
      
        13
      
      
        # In this file, you can use all long options that a program supports.


      
      
        14
      
      
        # If you want to know which options a program supports, run the program


      
      
        15
      
      
        # with the "--help" option.


      
      
        16
      
      
        17
      
      
        # The following options will be passed to all MySQL clients


      
      
        18
      
      
        [client]


      
      
        19
      
      
        #password    
      
      
        = your_password


      
      
        20
      
      
        port        
      
      
        = 3306


      
      
        21
      
      
        socket        
      
      
        = /tmp/mysql.sock


      
      
        22
      
      
        default-character-set 
      
      
        = utf8


      
      
        23
      
      
        24
      
      
        # Here follows entries for some specific programs


      
      
        25
      
      
        26
      
      
        # The MySQL server


      
      
        27
      
      
        [mysqld]


      
      
        28
      
      
        port        
      
      
        = 3306


      
      
        29
      
      
        socket        
      
      
        = /tmp/mysql.sock


      
      
        30
      
      
        skip-external-locking


      
      
        31
      
      
        key_buffer_size 
      
      
        = 16K


      
      
        32
      
      
        max_allowed_packet 
      
      
        = 1M


      
      
        33
      
      
        table_open_cache 
      
      
        = 4


      
      
        34
      
      
        sort_buffer_size 
      
      
        = 64K


      
      
        35
      
      
        read_buffer_size 
      
      
        = 256K


      
      
        36
      
      
        read_rnd_buffer_size 
      
      
        = 256K


      
      
        37
      
      
        net_buffer_length 
      
      
        = 2K


      
      
        38
      
      
        thread_stack 
      
      
        = 128K


      
      
        39
      
      
        basedir 
      
      
        = "E:\\MySQL"
      
      
        40
      
      
        datadir 
      
      
        = "E:\\MySQL\\data"
      
      
        41
      
      
        character-set-server 
      
      
        = utf8


      
      
        42
      
      
        43
      
      
        # Don't listen on a TCP/IP port at all. This can be a security enhancement,


      
      
        44
      
      
        # if all processes that need to connect to mysqld run on the same host.


      
      
        45
      
      
        # All interaction with mysqld must be made via Unix sockets or named pipes.


      
      
        46
      
      
        # Note that using this option without enabling named pipes on Windows


      
      
        47
      
      
        # (using the "enable-named-pipe" option) will render mysqld useless!


      
      
        48
      
      
        # 


      
      
        49
      
      
        #skip-networking


      
      
        50
      
      
        server-id    
      
      
        = 1


      
      
        51
      
      
        52
      
      
        # Uncomment the following if you want to log updates


      
      
        53
      
      
        #log-bin
      
      
        =mysql-bin


      
      
        54
      
      
        55
      
      
        # binary logging format - mixed recommended


      
      
        56
      
      
        #binlog_format
      
      
        =mixed


      
      
        57
      
      
        58
      
      
        # Causes updates to non-transactional engines using statement format to be


      
      
        59
      
      
        # written directly to binary log. Before using this option make sure that


      
      
        60
      
      
        # there are no dependencies between transactional and non-transactional


      
      
        61
      
      
        # tables such as in the statement INSERT INTO t_myisam SELECT * FROM


      
      
        62
      
      
        # t_innodb; otherwise, slaves may diverge from the master.


      
      
        63
      
      
        #binlog_direct_non_transactional_updates
      
      
        =TRUE


      
      
        64
      
      
        65
      
      
        # Uncomment the following if you are using InnoDB tables


      
      
        66
      
      
        #innodb_data_home_dir 
      
      
        = C:\\mysql\\data\\


      
      
        67
      
      
        #innodb_data_file_path 
      
      
        = ibdata1:10M:autoextend


      
      
        68
      
      
        #innodb_log_group_home_dir 
      
      
        = C:\\mysql\\data\\


      
      
        69
      
      
        # You can set .._buffer_pool_size up to 50 - 80 %


      
      
        70
      
      
        # of RAM but beware of setting memory usage too high


      
      
        71
      
      
        #innodb_buffer_pool_size 
      
      
        = 16M


      
      
        72
      
      
        #innodb_additional_mem_pool_size 
      
      
        = 2M


      
      
        73
      
      
        # Set .._log_file_size to 25 % of buffer pool size


      
      
        74
      
      
        #innodb_log_file_size 
      
      
        = 5M


      
      
        75
      
      
        #innodb_log_buffer_size 
      
      
        = 8M


      
      
        76
      
      
        #innodb_flush_log_at_trx_commit 
      
      
        = 1


      
      
        77
      
      
        #innodb_lock_wait_timeout 
      
      
        = 50


      
      
        78
      
      
        79
      
      
        [mysqldump]


      
      
        80
      
      
        quick


      
      
        81
      
      
        max_allowed_packet 
      
      
        = 16M


      
      
        82
      
      
        83
      
      
        [mysql]


      
      
        84
      
      
        no-auto-rehash


      
      
        85
      
      
        # Remove the next comment character if you are not familiar with SQL


      
      
        86
      
      
        #safe-updates


      
      
        87
      
      
        88
      
      
        [myisamchk]


      
      
        89
      
      
        key_buffer_size 
      
      
        = 8M


      
      
        90
      
      
        sort_buffer_size 
      
      
        = 8M


      
      
        91
      
      
        92
      
      
        [mysqlhotcopy]


      
      
        93
      
      
        interactive-timeout
      
    

64位MySQL:my.ini

      
         1
      
      
        # For advice on how to change settings please see


      
      
         2
      
      
        # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html


      
      
         3
      
      
        # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the


      
      
         4
      
      
        # *** default location during install, and will be replaced if you


      
      
         5
      
      
        # *** upgrade to a newer version of MySQL.


      
      
         6
      
      
         7
      
      
        [mysqld]


      
      
         8
      
      
         9
      
      
        # Remove leading # and set to the amount of RAM for the most important data


      
      
        10
      
      
        # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.


      
      
        11
      
      
        # innodb_buffer_pool_size = 128M


      
      
        12
      
      
        13
      
      
        # Remove leading # to turn on a very important data integrity option: logging


      
      
        14
      
      
        # changes to the binary log between backups.


      
      
        15
      
      
        # log_bin


      
      
        16
      
      
        17
      
      
        # These are commonly set, remove the # and set as required.


      
      
        18
      
      
        # basedir = .....


      
      
        19
      
      
        # datadir = .....


      
      
        20
      
      
        # port = .....


      
      
        21
      
      
        # server_id = .....


      
      
        22
      
      
        basedir = D:/MySQL-5.6.20-X64


      
      
        23
      
      
        datadir = D:/MySQL-5.6.20-X64/data


      
      
        24
      
      
        port = 3306


      
      
        25
      
      
        #server_id = .....


      
      
        26
      
      
        27
      
      
        character-set-server = utf8


      
      
        28
      
      
        default-storage-engine = INNODB


      
      
        29
      
      
        30
      
      
        # Remove leading # to set options mainly useful for reporting servers.


      
      
        31
      
      
        # The server defaults are faster for transactions and fast SELECTs.


      
      
        32
      
      
        # Adjust sizes as needed, experiment to find the optimal values.


      
      
        33
      
      
        # join_buffer_size = 128M


      
      
        34
      
      
        # sort_buffer_size = 2M


      
      
        35
      
      
        # read_rnd_buffer_size = 2M 


      
      
        36
      
      
        37
      
      
        sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 


      
      
        38
      
      
        39
      
      
        [client]


      
      
        40
      
       default-character-set=utf8
    

?

解壓版MySQL安裝說明


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 多色视频 | 久久爱伊人一区二区三区小说 | 性感毛片 | 青草视频网站 | 国产成人精品免费视频 | 欧美久在线观看在线观看 | 香蕉视频免费在线 | 天天谢天天干 | 日日操干 | 亚洲精品一二区 | 最新仑乱免费视频 | 美女福利视频一区二区 | 在线免费观看毛片 | 久久久这里有精品999 | 色偷偷亚洲女人天堂观看欧 | 天天摸夜夜添狠狠添2018 | 美女一级毛片免费不卡视频 | 精品久久久久久久久久中文字幕 | 久久久久久免费精品视频 | 香港a毛片免费全部播放 | 欧美精品一区在线看 | 国产91在线 | 亚洲 | 免费99精品国产自在现线观看 | 免费看黄色录像 | 亚洲a在线播放 | 天天插天天射天天操 | 免费一级特黄欧美大片久久网 | 亚洲综合一区二区三区 | 久久精品在线播放 | 91最新国产 | 精品少妇一区二区三区视频 | 亚洲国产天堂久久九九九 | 在线看日本吃奶孕交 | 亚洲第一成年免费网站 | 亚洲福利视频在线 | 欧美精品亚洲二区 | 亚洲精品中文一区不卡 | 成人国产精品免费视频 | 国产精品一久久香蕉产线看 | 91久久精品日日躁夜夜躁欧美 | 中文字幕在线高清 |