2. 下面是 my.ini 的配置文件,如果你對配置不熟的話,你可以直接 Copy 過去存為 my.ini 後放到 C:\windows 下即可 (我電腦的 RAM = 256) ======================================================================================================== # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options
# This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL
# Here is entries for some specific programs # The following values assume you have at least 32M ram
# The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1
# Uncomment the following if you want to log updates #log-bin
# Uncomment the following rows if you move the MySQL distribution to another # location #basedir = d:/mysql/ #datadir = d:/mysql/data/
# Uncomment the following if you are NOT using BDB tables #skip-bdb
# Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=10000
# Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:400M innodb_data_home_dir = C:/mysql/InnoDB/ibdata # InnoDB 及 ibdata 的資料夾你要自己動手 innodb_log_group_home_dir = C:/mysql/InnoDB/iblogs # iblogs 的資料夾同樣你要自己動手 innodb_log_arch_dir = C:/mysql/innodb/iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50
3. Create InnoDB table table space 如果運行沒有問題,你應該可以看到如下內容: ==========================================================
C:\mysql\bin>;mysqld --console InnoDB: The first specified data file C:\mysql\InnoDB\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! 040113 15:12:54 InnoDB: Setting file C:\mysql\InnoDB\ibdata\ibdata1 size to 400 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 040113 15:13:19 InnoDB: Log file C:\mysql\InnoDB\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file C:\mysql\InnoDB\iblogs\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 040113 15:13:19 InnoDB: Log file C:\mysql\InnoDB\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file C:\mysql\InnoDB\iblogs\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 040113 15:13:20 InnoDB: Log file C:\mysql\InnoDB\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file C:\mysql\InnoDB\iblogs\ib_logfile2 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 040113 15:13:26 InnoDB: Started; log sequence number 0 0 mysqld: ready for connections. Version: '5.0.0-alpha-max-debug' socket: '' port: 3306 ==========================================================
安裝 Ok, 進去看看吧,沒想到一進 Mysql 馬上就來了個下馬威, 原來的 '' 這個 user 不能用 mysql 的 databases ========================================================= C:\mysql\bin>;mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.0-alpha-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>; use mysql ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'mysql ==========================================================
C:\mysql\bin>;mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 5.0.0-alpha-max-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>; use test; Database changed mysql>; CREATE PROCEDURE MyProc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param 1 FROM sys_forms; END;
ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELE CT COUNT(*) INTO param1 FROM sys_forms' at line 1