mysql-noinstall安装指南.docVIP

mysql-noinstall安装指南# Example MySQL config file for small systems. # # This is for a system with little memory (= 64M) where MySQL is only used # from time to time and its important that the mysqld daemon # doesnt use much resources. # # You can copy this file to # /etc/f to set global options, # mysql-data-dir/f to set server-specific options (in this # installation this directory is /usr/local/var) or # ~/.f to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock #这里是我们增加的内容 #设置客户端字符集 default-character-set=gbk # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K #这里是我们修改的内容 basedir=D:\DevelopTools\mysql-5.0.22-win32 # 设置mysql数据库的数据的存放目录，必须是data，或者是\\xxx\data datadir=D:\DevelopTools\mysql-5.0.22-win32\data # 设置mysql服务器的字符集 default-character-set=utf8 # Dont listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (using the enable-named-pipe option) will render mysqld useless! # #skip-networking server-id = 1 # Uncomment the following if you want to log updates #log-bin=mysql-bin # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/var/ #innodb_data_file_path = ibdata1:10M:autoextend #