windows732bit下MySQL5.5.22安裝筆記_MySQL

bitsCN.com
1. 準備文件 mysql解壓版 下載地址ftp://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/mysql-5.5.22-win32.zip 2. 解壓到本地目錄 D:/devTools/mysql 3. 把添加系統環境變量 MYSQL_HOME ==> D:/devTools/mysql (新建) Path ==> ;%MYSQL_HOME%/bin (追加) 4. 修改MySQL5.5的配置文件，把my-small.ini改名為my.ini進行編輯 a）在[mysqld]下追加 ------- basedir = "d://devTools//mysql" datadir = "d://devTools//mysql//data" character-set-server = utf8 ------- b) 在[client]下追加 ------- default-character-set = utf8 ------- 5. 保存my.ini的配置， 然后打開命令行（開始菜單==>運行==>cmd ） 輸入: mysqld --console 然后回車將看到如下類似內容: ------- C:/Windows/system32>mysqld --console 120410 14:25:22 [Note] Plugin 'FEDERATED' is disabled. 120410 14:25:22 InnoDB: The InnoDB memory heap is disabled 120410 14:25:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions 120410 14:25:22 InnoDB: Compressed tables use zlib 1.2.3 120410 14:25:22 InnoDB: Initializing buffer pool, size = 128.0M 120410 14:25:22 InnoDB: Completed initialization of buffer pool 120410 14:25:22 InnoDB: highest supported file format is Barracuda. 120410 14:25:22 InnoDB: Waiting for the background threads to start 120410 14:25:23 InnoDB: 1.1.8 started; log sequence number 1595675 120410 14:25:23 [Note] Event Scheduler: Loaded 0 events 120410 14:25:23 [Note] mysqld: ready for connections. Version: '5.5.22' socket: '' port: 3306 MySQL Community Server (GPL) ------- ==> 證明mysql服務已啟動 6. 設置登陸mysql root帳號的的密碼 打開新的命令行，輸入 mysql -uroot 回車 ------- Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 1 Server version: 5.5.22 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. ------- ==〉看到上面類似內容說明登陸成功，此時的root帳號是沒有密碼的 執行命令修改密碼： use mysql; update user set password=PASSWORD("這里填寫你要設置的密碼") where user='root'; 執行完成后退出mysql操作,然后關閉mysql服務（ctrl+C 關閉另一個命令窗口），然后重啟mysql服務 作者 lotnhiro bitsCN.com

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com