在线看视频你懂的,97精品视频在线看,北岛玲日韩精品一区二区三区

天行健、君子以自強不息；地勢坤、君子以厚德載物……

mysql-noinstall安裝指南

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

1

# 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

17

# 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

#這里是我們增加的內容
23

#設置客戶端字符集
24

default-character-set=gbk
25

# Here follows entries for some specific programs
26

27

# 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

#這里是我們修改的內容
41

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

# 設置mysql數據庫的數據的存放目錄，必須是data，或者是\\xxx\data
43

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

# 設置mysql服務器的字符集
45

default-character-set=utf8
46

47

# 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

56

# Uncomment the following if you want to log updates
57

#log-bin=mysql-bin
58

59

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

#skip-bdb
61

62

# 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

77

[mysqldump]
78

quick
79

max_allowed_packet = 16M
80

81

[mysql]
82

no-auto-rehash
83

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

#safe-updates
85

86

[isamchk]
87

key_buffer = 8M
88

sort_buffer_size = 8M
89

90

[myisamchk]
91

key_buffer = 8M
92

sort_buffer_size = 8M
93

94

[mysqlhotcopy]
95

interactive-timeout
96

4，然后編寫啟動腳本；

1

@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

7

8

9

停止腳本

1

@echo off
2

echo stop mysql5
3

4

net stop mysql5
5

mysqld --remove mysql5
6

7

pause

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

靠沒驗證過就不要貼出來純粹誤導人。害我配了很久都沒成功

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

這里應該是

basedir=D:\\DevelopTools\\mysql-5.0.22-win32 回復更多評論

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

@lwcaly
沒有驗證的東西我是不會貼出來的，我自己在測試安裝過程正常使用，不信可以遠程登錄上來讓你看；

您的路徑為何要雙\\，難道轉義字符？

不要沒有教養、亂咬人，有能力就不到處找帖子配置了；
回復更多評論

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

手冊中的：

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

回復更多評論

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: mysql-noinstall安裝指南 OracleXE修改HTTP默認的監聽端口

<

2008年8月

>

日

一

二

三

四

五

六

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

統計

隨筆 - 16
文章 - 0
評論 - 16
引用 - 0

常用鏈接

留言簿(1)

隨筆分類(15)

積分與排名

積分 - 69216
排名 - 794

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