mysql在windows下的安装配置

MySQL在Windows下的基本配置文章分类:数据库说明：本文针对mysql-noinstall版本，也就是解压缩版在Windows下的基本配置操作系统： Windows XPMySQL版本： mysql-5.1.50-win321、下载MySQL解压包 mysql-noinstall-5.1.50-win32.zip解压缩到某个目录。

例如：D:\Java\mysql2、配置MySQL的根目录，里面有多个文件名如my-****.ini形式的文件，这就是MySQL配置的样例文件。

可以选取一个将其名字改为my.ini，MySQL启动的时候就是读取这个my.ini文件来决定数据库的各项参数。

在my.ini文件中需要进行配置的主要是两个方面，一个是客户端，一个是服务器端。

修改my.ini文件，添加以下内容：Sql代码1.# The following options will be passed to all MySQL clients2.[client]3.#password = your_password4.#客户端端口5.port = 33066.socket = /tmp/mysql.sock7.# 设置mysql客户端的字符集8.default-character-set=gbkSql代码1.# The MySQL server2.[mysqld]3.port = 33064.socket = /tmp/mysql.sock5.6.# 设置mysql服务器的字符集7.default-character-set=gbk8.9.# 设置mysql的默认存储引擎10.default-storage-engine=INNODB11.12.# 设置mysql的安装目录13.basedir=d:/Java/mysql/mysql-5.1.50-win3214.15.# 设置mysql数据库的数据的存放目录，必须是data16.datadir=d:/Java/mysql/mysql-5.1.50-win32/data完成后保存即可。

3、启动数据库为了方便，可以把数据库注册成一个服务：进入D:\Java\mysql\mysql-5.1.50-win32\bin 目录，运行命令:mysqld --install mysql这样就会在系统服务中注册了一个名字为mysql的服务( mysqld --remove mysql 卸载服务)在环境变量path中加入 D:\Java\mysql\mysql-5.1.50-win32\bin然后就可以正常使用MySQL数据库了.启动数据库服务：net start mysql关闭服务：net stop mysql4、使用MySQL数据库登录数据库：输入命令：mysql -u root -p回车后提示输入密码。

mysql解压缩版初次安装管理员root的密码为空，因此直接再回车一次就登入mysql 数据库了。

常用登录参数：-h 是指定登录服务器地址，-u 指定用户-p 指定密码如果想为root用户加上密码，可以退出数据库mysql>quit，然后使用如下命令设置root用户的密码：mysqladmin -uroot password 123456设定密码为123456至此，MySQL数据库的基本配置就完成了，可以通过客户端或是程序来使用这个数据库了。

附：现用my.ini (根据my-large.ini修改 )Sql代码1.# Example MySQL config file for large systems.3.# This is for a large system with memory = 512M where the system runs mainly4.# MySQL.5.#6.# You can copy this file to7.# /etc/f to set global options,8.# mysql-data-dir/f to set server-specific options (in this9.# installation this directory is C:\mysql\data) or10.# ~/f to set user-specific options.11.#12.# In this file, you can use all long options that a program supports.13.# If you want to know which options a program supports, run the program14.# with the "--help" option.15.16.# The following options will be passed to all MySQL clients17.[client]18.#password = your_password19.port = 330620.socket = /tmp/mysql.sock21.default-character-set=gbk22.23.# Here follows entries for some specific programs24.25.# The MySQL server26.[mysqld]27.port = 330628.socket = /tmp/mysql.sock29.default-character-set=gbk30.default-storage-engine=INNODB31.basedir=d:/Java/mysql/mysql-5.1.50-win3232.datadir=d:/Java/mysql/mysql-5.1.50-win32/data33.skip-locking34.key_buffer_size = 256M35.max_allowed_packet = 1M36.table_open_cache = 25637.sort_buffer_size = 1M38.read_buffer_size = 1M39.read_rnd_buffer_size = 4M40.myisam_sort_buffer_size = 64M41.thread_cache_size = 842.query_cache_size= 16M43.# Try number of CPU's*2 for thread_concurrency44.thread_concurrency = 846.# Don't listen on a TCP/IP port at all. This can be a security enhancement,47.# if all processes that need to connect to mysqld run on the same host.48.# All interaction with mysqld must be made via Unix sockets or namedpipes.49.# Note that using this option without enabling named pipes on Windows50.# (via the "enable-named-pipe" option) will render mysqld useless!51.#52.#skip-networking53.54.# Replication Master Server (default)55.# binary logging is required for replication56.log-bin=mysql-bin57.58.# binary logging format - mixed recommended59.binlog_format=mixed60.61.# required unique id between 1 and 2^32 - 162.# defaults to 1 if master-host is not set63.# but will not function as a master if omitted64.server-id = 165.66.# Replication Slave (comment out master section to use this)67.#68.# To configure this host as a replication slave, you can choose between69.# two methods :70.#71.# 1) Use the CHANGE MASTER TO command (fully described in our manual) -72.# the syntax is:73.#74.# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,75.# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;76.#77.# where you replace <host>, <user>, <password> by quoted stringsand78.# <port> by the master's port number (3306 by default).79.#80.# Example:81.#82.# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,83.# MASTER_USER='joe', MASTER_PASSWORD='secret';84.#85.# OR86.#87.# 2) Set the variables below. However, in case you choose this method, then88.# start replication for the first time (even unsuccessfully, forexample89.# if you mistyped the password in master-password and the slave fails to90.# connect), the slave will create a file, and any later91.# change in this file to the variables' values below will be ignored and92.# overridden by the content of the file, unless you shutdown93.# the slave server, delete and restart the slaver server.94.# For that reason, you may want to leave the lines below untouched95.# (commented) and instead use CHANGE MASTER TO (see above)96.#97.# required unique id between 2 and 2^32 - 198.# (and different from the master)99.# defaults to 2 if master-host is set100.# but will not function as a slave if omitted101.#server-id = 2102.#103.# The replication master for this slave - required104.#master-host = <hostname>105.#106.# The username the slave will use for authentication when connec ting107.# to the master - required108.#master-user = <username>109.#110.# The password the slave will authenticate with when connecting to111.# the master - required112.#master-password = <password>113.#114.# The port the master is listening on.115.# optional - defaults to 3306116.#master-port = <port>117.#118.# binary logging - not required for slaves, but recommended 119.#log-bin=mysql-bin120.121.# Point the following paths to different dedicated disks 122.#tmpdir = /tmp/123.#log-update = /path-to-dedicated-directory/hostname 124.125.# Uncomment the following if you are using InnoDB tables 126.#innodb_data_home_dir = C:\mysql\data/127.#innodb_data_file_path = ibdata1:10M:autoextend128.#innodb_log_group_home_dir = C:\mysql\data/129.# You can set .._buffer_pool_size up to 50 - 80 %130.# of RAM but beware of setting memory usage too high131.#innodb_buffer_pool_size = 256M132.#innodb_additional_mem_pool_size = 20M133.# Set .._log_file_size to 25 % of buffer pool size134.#innodb_log_file_size = 64M135.#innodb_log_buffer_size = 8M136.#innodb_flush_log_at_trx_commit = 1137.#innodb_lock_wait_timeout = 50138.139.[mysqldump]140.quick141.max_allowed_packet = 16M142.143.[mysql]144.no-auto-rehash145.# Remove the next comment character if you are not familiar with SQL146.#safe-updates147.148.[myisamchk]149.key_buffer_size = 128M150.sort_buffer_size = 128M151.read_buffer = 2M152.write_buffer = 2M153.154.[mysqlhotcopy]155.interactive-timeoutMySQL5解压缩版windows下安装配置应用总结MSN ：leizhimin@本文针对mysql-noinstall版本，也就是解压缩版的安装配置应用做了个总结，这些操作都是平时很常用的操作。