亚洲欧洲日韩综合在线,亚洲欧洲日本在线,亚洲av综合avav中文

mysql-noinstall安裝指南

1，下載mysql：http://download.mysql.cn/
文件名：mysql-noinstall-5.0.22(win32)
2.加壓縮導(dǎo)任何一個(gè)目錄，最好目錄名稱不要有空格；
例如：D:\DevelopTools\mysql-5.0.22-win32
3，在mysql-5.0.22-win32
目錄下新建一個(gè)my.ini，拷貝my-small.ini代碼至my.ini；修改后如下：

# Example MySQL config file for small systems.
2

#
3

# This is for a system with little memory (<= 64M) where MySQL is only used
4

# from time to time and it's important that the mysqld daemon
5

# doesn't use much resources.
6

#
7

# You can copy this file to
8

# /etc/my.cnf to set global options,
9

# mysql-data-dir/my.cnf to set server-specific options (in this
10

# installation this directory is /usr/local/var) or
11

# ~/.my.cnf to set user-specific options.
12

#
13

# In this file, you can use all long options that a program supports.
14

# If you want to know which options a program supports, run the program
15

# with the "--help" option.
16

# The following options will be passed to all MySQL clients
18

[client]
19

#password = your_password
20

port = 3306
21

socket = /tmp/mysql.sock
22

#這里是我們?cè)黾拥膬?nèi)容
23

#設(shè)置客戶端字符集
24

default-character-set=gbk
25

# Here follows entries for some specific programs
26

# The MySQL server
28

[mysqld]
29

port = 3306
30

socket = /tmp/mysql.sock
31

skip-locking
32

key_buffer = 16K
33

max_allowed_packet = 1M
34

table_cache = 4
35

sort_buffer_size = 64K
36

read_buffer_size = 256K
37

read_rnd_buffer_size = 256K
38

net_buffer_length = 2K
39

thread_stack = 64K
40

#這里是我們修改的內(nèi)容
41

basedir=D:\DevelopTools\mysql-5.0.22-win32
42

# 設(shè)置mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄，必須是data，或者是\\xxx\data
43

datadir=D:\DevelopTools\mysql-5.0.22-win32\data
44

# 設(shè)置mysql服務(wù)器的字符集
45

default-character-set=utf8
46

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
48

# if all processes that need to connect to mysqld run on the same host.
49

# All interaction with mysqld must be made via Unix sockets or named pipes.
50

# Note that using this option without enabling named pipes on Windows
51

# (using the "enable-named-pipe" option) will render mysqld useless!
52

#
53

#skip-networking
54

server-id = 1
55

# Uncomment the following if you want to log updates
57

#log-bin=mysql-bin
58

# Uncomment the following if you are NOT using BDB tables
60

#skip-bdb
61

# Uncomment the following if you are using InnoDB tables
63

#innodb_data_home_dir = /usr/local/var/
64

#innodb_data_file_path = ibdata1:10M:autoextend
65

#innodb_log_group_home_dir = /usr/local/var/
66

#innodb_log_arch_dir = /usr/local/var/
67

# You can set .._buffer_pool_size up to 50 - 80 %
68

# of RAM but beware of setting memory usage too high
69

#innodb_buffer_pool_size = 16M
70

#innodb_additional_mem_pool_size = 2M
71

# Set .._log_file_size to 25 % of buffer pool size
72

#innodb_log_file_size = 5M
73

#innodb_log_buffer_size = 8M
74

#innodb_flush_log_at_trx_commit = 1
75

#innodb_lock_wait_timeout = 50
76

[mysqldump]
78

quick
79

max_allowed_packet = 16M
80

[mysql]
82

no-auto-rehash
83

# Remove the next comment character if you are not familiar with SQL
84

#safe-updates
85

[isamchk]
87

key_buffer = 8M
88

sort_buffer_size = 8M
89

[myisamchk]
91

key_buffer = 8M
92

sort_buffer_size = 8M
93

[mysqlhotcopy]
95

interactive-timeout
96

4，然后編寫啟動(dòng)腳本；

@echo off
2

echo start mysql5 on localhost
3

mysqld --install mysql5 --defaults-file=D:\DevelopTools\mysql-5.0.22-win32\my.ini
4

net start mysql5
5

pause
6

停止腳本

@echo off
2

echo stop mysql5
3

net stop mysql5
5

mysqld --remove mysql5
6

pause

posted on 2008-08-03 11:21 空白閱讀(3685) 評(píng)論(3) 編輯收藏所屬分類: DataBase

評(píng)論

# re: mysql-noinstall安裝指南 2009-05-10 23:52 lwcaly

靠沒驗(yàn)證過就不要貼出來(lái) 純粹誤導(dǎo)人。害我配了很久都沒成功

basedir=D:\DevelopTools\mysql-5.0.22-win32
# 設(shè)置mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄，必須是data，或者是\\xxx\data
datadir=D:\DevelopTools\mysql-5.0.22-win32\data

這里應(yīng)該是

basedir=D:\\DevelopTools\\mysql-5.0.22-win32 回復(fù) 更多評(píng)論

# re: mysql-noinstall安裝指南 2009-05-11 09:21 空白

@lwcaly
沒有驗(yàn)證的東西我是不會(huì)貼出來(lái)的，我自己在測(cè)試安裝過程正常使用，不信可以遠(yuǎn)程登錄上來(lái)讓你看；

您的路徑為何要雙\\，難道轉(zhuǎn)義字符？

不要沒有教養(yǎng)、亂咬人，有能力就不到處找帖子配置了；
回復(fù) 更多評(píng)論

# re: mysql-noinstall安裝指南 2009-08-27 00:49 addd

手冊(cè)中的：

An option file can be created and modified with any text editor, such as Notepad. For example, if MySQL is installed in E:\mysql and the data directory is in E:\mydata\data, you can create an option file containing a [mysqld] section to specify values for the basedir and datadir options:

[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mydata/data

Note that Windows path names are specified in option files using (forward) slashes rather than backslashes. If you do use backslashes, you must double them:

[mysqld]
# set basedir to your installation path
basedir=E:\\mysql
# set datadir to the location of your data directory
datadir=E:\\mydata\\data

回復(fù) 更多評(píng)論

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: mysql-noinstall安裝指南 OracleXE修改HTTP默認(rèn)的監(jiān)聽端口

# re: mysql-noinstall安裝指南 2009-05-10 23:52 lwcaly

# re: mysql-noinstall安裝指南 2009-05-11 09:21 空白

# re: mysql-noinstall安裝指南 2009-08-27 00:49 addd

mysql-noinstall安裝指南

評(píng)論

導(dǎo)航

統(tǒng)計(jì)

常用鏈接

留言簿(1)

隨筆分類(15)

積分與排名

最新評(píng)論

閱讀排行榜

評(píng)論排行榜