MySQL5.5.22 Installation notes under Windows 7 32bit

1. Prepare the mysql decompressed File ftp://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.5/mysql-5.5.22-win32.zip 2. decompress the package to the local Directory D: \ devTools \ mysql 3. add the system environment variable MYSQL_HOME ==> D: \ devTools \ mysql (new) Path ==>;% MYSQL_HOME % \ bin (append) 4. modify the configuration file of MySQL5.5 and change the my-small.ini to my. ini to edit a) append www.2cto.com ------- basedir = "d: \ devTools \ mysql" datadir = "d: \ devTools \ mysql \ data "character-set-server = utf8 ------- B) append ------- default-character-set = utf8 ------- 5 under [client. save my. ini configuration, and then open the command line (Start Menu ==> run ==> cmd) input: mysqld -- console and then press enter to see the following similar content: ------- 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.0 M 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 schedted: Loaded 0 events 120410 14:25:23 [Note] mysqld: ready for connections. version: '5. 5.22 'socket: ''port: 3306 MySQL Community Server (GPL) ------- ==> proves that mysql service has been started 6. set the password for logging on to the mysql root Account to open the new command line. Enter mysql-uroot and press ENTER ------- 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,201 1, 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.2cto.com Type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. ------- => the preceding content indicates that the logon is successful. The root account does not have a password. Run the command to change the password: use mysql; update user set password = PASSWORD ("enter the password you want to set here") where user = 'root'; exit mysql after the execution is complete, then close the mysql Service (ctrl + C close another command window), and restart mysql service author lotnhiro