windows7 32bit下MySQL5.5.22安裝筆記

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]下追加  www.aiwalls.com  

   ——-

   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.  www.aiwalls.com  

 

   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

發佈留言