线上连载讨论：数据库运维之MySQL初级应用（有奖）

chenyx

我在数据管理的时候,一个web应用(比如discuz),指定一个单独的数据库,并且给一个账号,只对这个数据库有权限,别的库没有权限

ning_lianjie

回复 11# chenyx


很好的规范,晒出个命令,供参考:
创建一个名字为test_user的用户,允许从任何地方登录,拥有test下的所有权限

mysql> GRANT ALL PRIVILEGES ON test.* TO 'test_user'@'%' IDENTIFIED BY PASSWORD '123456'

renxiao2003

Linux下源码安装，MySQL5.5.16。
从5.5.16开始，MySQL采用cmake编译安装了。相对传统的Make安装区别也不是太大。
首先要安装cmake，然后解压后cmake，然后运行make和make install就可以安装了。
原来的安装参数在configure时指定，现在在make install时采用 DESTDIR指定。
编译参数有：

1. ACLOCAL_EXECUTABLE:FILEPATH=ACLOCAL_EXECUTABLE-NOTFOUND
   
2. AUTOCONF_EXECUTABLE:FILEPATH=AUTOCONF_EXECUTABLE-NOTFOUND
   
3. AUTOHEADER_EXECUTABLE:FILEPATH=AUTOHEADER_EXECUTABLE-NOTFOUND
   
4. AUTOMAKE_EXECUTABLE:FILEPATH=AUTOMAKE_EXECUTABLE-NOTFOUND
   
5. AWK_EXECUTABLE:FILEPATH=/usr/bin/gawk
   
6. BACKUP_TEST:BOOL=OFF
   
7. BISON_EXECUTABLE:FILEPATH=BISON_EXECUTABLE-NOTFOUND
   
8. BZR_EXECUTABLE:FILEPATH=BZR_EXECUTABLE-NOTFOUND
   
9. CAT_EXECUTABLE:FILEPATH=/bin/cat
   
10. CMAKE_AR:FILEPATH=/usr/bin/ar
    
11. CMAKE_BUILD_TYPE:STRING=RelWithDebInfo
    
12. CMAKE_COLOR_MAKEFILE:BOOL=ON
    
13. CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++
    
14. CMAKE_CXX_FLAGS:STRING=
    
15. CMAKE_CXX_FLAGS_DEBUG:STRING=-g
    
16. CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
    
17. CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
    
18. CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
    
19. CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc
    
20. CMAKE_C_FLAGS:STRING=
    
21. CMAKE_C_FLAGS_DEBUG:STRING=-g
    
22. CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
    
23. CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
    
24. CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
    
25. CMAKE_EXE_LINKER_FLAGS:STRING=
    
26. CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING=
    
27. CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING=
    
28. CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING=
    
29. CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
    
30. CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
    
31. CMAKE_LINKER:FILEPATH=/usr/bin/ld
    
32. CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make
    
33. CMAKE_MODULE_LINKER_FLAGS:STRING=
    
34. CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING=
    
35. CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING=
    
36. CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING=
    
37. CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
    
38. CMAKE_NM:FILEPATH=/usr/bin/nm
    
39. CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy
    
40. CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump
    
41. CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib
    
42. CMAKE_SHARED_LINKER_FLAGS:STRING=
    
43. CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING=
    
44. CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING=
    
45. CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING=
    
46. CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING=
    
47. CMAKE_SKIP_RPATH:BOOL=NO
    
48. CMAKE_STRIP:FILEPATH=/usr/bin/strip
    
49. CMAKE_USE_RELATIVE_PATHS:BOOL=OFF
    
50. CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE
    
51. COMMUNITY_BUILD:BOOL=ON
    
52. CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND
    
53. CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/libform.so
    
54. CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h
    
55. CURSES_INCLUDE_PATH:PATH=/usr/include
    
56. CURSES_LIBRARY:FILEPATH=/usr/lib/libcurses.so
    
57. CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/libncurses.so
    
58. CYBOZU:BOOL=OFF
    
59. DISABLE_SHARED:BOOL=OFF
    
60. DTRACE:FILEPATH=DTRACE-NOTFOUND
    
61. ENABLED_LOCAL_INFILE:BOOL=OFF
    
62. ENABLED_PROFILING:BOOL=ON
    
63. ENABLE_DEBUG_SYNC:BOOL=ON
    
64. ENABLE_GCOV:BOOL=OFF
    
65. EXECUTABLE_OUTPUT_PATH:PATH=
    
66. GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND
    
67. GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND
    
68. INSTALL_BINDIR:STRING=bin
    
69. INSTALL_DOCDIR:STRING=docs
    
70. INSTALL_DOCREADMEDIR:STRING=.
    
71. INSTALL_INCLUDEDIR:STRING=include
    
72. INSTALL_INFODIR:STRING=docs
    
73. INSTALL_LAYOUT:STRING=STANDALONE
    
74. INSTALL_LIBDIR:STRING=lib
    
75. INSTALL_MANDIR:STRING=man
    
76. INSTALL_MYSQLDATADIR:STRING=data
    
77. INSTALL_MYSQLSHAREDIR:STRING=share
    
78. INSTALL_MYSQLTESTDIR:STRING=mysql-test
    
79. INSTALL_PLUGINDIR:STRING=lib/plugin
    
80. INSTALL_PLUGINTESTDIR:STRING=
    
81. INSTALL_SBINDIR:STRING=bin
    
82. INSTALL_SCRIPTDIR:STRING=scripts
    
83. INSTALL_SHAREDIR:STRING=share
    
84. INSTALL_SQLBENCHDIR:STRING=.
    
85. INSTALL_SUPPORTFILESDIR:STRING=support-files
    
86. LIBRARY_OUTPUT_PATH:PATH=
    
87. LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize
    
88. MANUFACTURER:STRING=Built from Source
    
89. MYSQL_DATADIR:PATH=/usr/local/mysql/data
    
90. MYSQL_DOCS_LOCATION:PATH=
    
91. MYSQL_MAINTAINER_MODE:BOOL=OFF
    
92. NO_ALARM:BOOL=1
    
93. SYSCONFDIR:PATH=/usr/local/mysql/etc
    
94. TAR_EXECUTABLE:FILEPATH=/bin/tar
    
95. WITHOUT_SERVER:BOOL=OFF
    
96. WITH_ARCHIVE_STORAGE_ENGINE:BOOL=OFF
    
97. WITH_ATOMIC_LOCKS:STRING=
    
98. WITH_BLACKHOLE_STORAGE_ENGINE:BOOL=OFF
    
99. WITH_DEBUG:BOOL=OFF
    
100. WITH_EMBEDDED_SERVER:BOOL=OFF
     
101. WITH_EXTRA_CHARSETS:STRING=all
     
102. WITH_FAST_MUTEXES:BOOL=OFF
     
103. WITH_FEDERATED_STORAGE_ENGINE:BOOL=OFF
     
104. WITH_INNOBASE_STORAGE_ENGINE:BOOL=ON
     
105. WITH_LIBEDIT:BOOL=ON
     
106. WITH_LIBWRAP:BOOL=OFF
     
107. WITH_MYSQLD_LDFLAGS:STRING=
     
108. WITH_PARTITION_STORAGE_ENGINE:BOOL=ON
     
109. WITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON
     
110. WITH_PIC:BOOL=OFF
     
111. WITH_READLINE:BOOL=OFF
     
112. WITH_SSL:STRING=no
     
113. WITH_UNIT_TESTS:BOOL=ON
     
114. WITH_VALGRIND:BOOL=OFF
     
115. WITH_ZLIB:STRING=system
     
116. ZLIB_INCLUDE_DIR:PATH=/usr/include
     
117. ]ACLOCAL_EXECUTABLE:FILEPATH=ACLOCAL_EXECUTABLE-NOTFOUND
     
118. AUTOCONF_EXECUTABLE:FILEPATH=AUTOCONF_EXECUTABLE-NOTFOUND
     
119. AUTOHEADER_EXECUTABLE:FILEPATH=AUTOHEADER_EXECUTABLE-NOTFOUND
     
120. AUTOMAKE_EXECUTABLE:FILEPATH=AUTOMAKE_EXECUTABLE-NOTFOUND
     
121. AWK_EXECUTABLE:FILEPATH=/usr/bin/gawk
     
122. BACKUP_TEST:BOOL=OFF
     
123. BISON_EXECUTABLE:FILEPATH=BISON_EXECUTABLE-NOTFOUND
     
124. BZR_EXECUTABLE:FILEPATH=BZR_EXECUTABLE-NOTFOUND
     
125. CAT_EXECUTABLE:FILEPATH=/bin/cat
     
126. CMAKE_AR:FILEPATH=/usr/bin/ar
     
127. CMAKE_BUILD_TYPE:STRING=RelWithDebInfo
     
128. CMAKE_COLOR_MAKEFILE:BOOL=ON
     
129. CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++
     
130. CMAKE_CXX_FLAGS:STRING=
     
131. CMAKE_CXX_FLAGS_DEBUG:STRING=-g
     
132. CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
     
133. CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
     
134. CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
     
135. CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc
     
136. CMAKE_C_FLAGS:STRING=
     
137. CMAKE_C_FLAGS_DEBUG:STRING=-g
     
138. CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
     
139. CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
     
140. CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
     
141. CMAKE_EXE_LINKER_FLAGS:STRING=
     
142. CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING=
     
143. CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING=
     
144. CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING=
     
145. CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
146. CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
     
147. CMAKE_LINKER:FILEPATH=/usr/bin/ld
     
148. CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make
     
149. CMAKE_MODULE_LINKER_FLAGS:STRING=
     
150. CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING=
     
151. CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING=
     
152. CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING=
     
153. CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
154. CMAKE_NM:FILEPATH=/usr/bin/nm
     
155. CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy
     
156. CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump
     
157. CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib
     
158. CMAKE_SHARED_LINKER_FLAGS:STRING=
     
159. CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING=
     
160. CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING=
     
161. CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING=
     
162. CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
163. CMAKE_SKIP_RPATH:BOOL=NO
     
164. CMAKE_STRIP:FILEPATH=/usr/bin/strip
     
165. CMAKE_USE_RELATIVE_PATHS:BOOL=OFF
     
166. CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE
     
167. COMMUNITY_BUILD:BOOL=ON
     
168. CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND
     
169. CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/libform.so
     
170. CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h
     
171. CURSES_INCLUDE_PATH:PATH=/usr/include
     
172. CURSES_LIBRARY:FILEPATH=/usr/lib/libcurses.so
     
173. CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/libncurses.so
     
174. CYBOZU:BOOL=OFF
     
175. DISABLE_SHARED:BOOL=OFF
     
176. DTRACE:FILEPATH=DTRACE-NOTFOUND
     
177. ENABLED_LOCAL_INFILE:BOOL=OFF
     
178. ENABLED_PROFILING:BOOL=ON
     
179. ENABLE_DEBUG_SYNC:BOOL=ON
     
180. ENABLE_GCOV:BOOL=OFF
     
181. EXECUTABLE_OUTPUT_PATH:PATH=
     
182. GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND
     
183. GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND
     
184. INSTALL_BINDIR:STRING=bin
     
185. INSTALL_DOCDIR:STRING=docs
     
186. INSTALL_DOCREADMEDIR:STRING=.
     
187. INSTALL_INCLUDEDIR:STRING=include
     
188. INSTALL_INFODIR:STRING=docs
     
189. INSTALL_LAYOUT:STRING=STANDALONE
     
190. INSTALL_LIBDIR:STRING=lib
     
191. INSTALL_MANDIR:STRING=man
     
192. INSTALL_MYSQLDATADIR:STRING=data
     
193. INSTALL_MYSQLSHAREDIR:STRING=share
     
194. INSTALL_MYSQLTESTDIR:STRING=mysql-test
     
195. INSTALL_PLUGINDIR:STRING=lib/plugin
     
196. INSTALL_PLUGINTESTDIR:STRING=
     
197. INSTALL_SBINDIR:STRING=bin
     
198. INSTALL_SCRIPTDIR:STRING=scripts
     
199. INSTALL_SHAREDIR:STRING=share
     
200. INSTALL_SQLBENCHDIR:STRING=.
     
201. INSTALL_SUPPORTFILESDIR:STRING=support-files
     
202. LIBRARY_OUTPUT_PATH:PATH=
     
203. LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize
     
204. MANUFACTURER:STRING=Built from Source
     
205. MYSQL_DATADIR:PATH=/usr/local/mysql/data
     
206. MYSQL_DOCS_LOCATION:PATH=
     
207. MYSQL_MAINTAINER_MODE:BOOL=OFF
     
208. NO_ALARM:BOOL=1
     
209. SYSCONFDIR:PATH=/usr/local/mysql/etc
     
210. TAR_EXECUTABLE:FILEPATH=/bin/tar
     
211. WITHOUT_SERVER:BOOL=OFF
     
212. WITH_ARCHIVE_STORAGE_ENGINE:BOOL=OFF
     
213. WITH_ATOMIC_LOCKS:STRING=
     
214. WITH_BLACKHOLE_STORAGE_ENGINE:BOOL=OFF
     
215. WITH_DEBUG:BOOL=OFF
     
216. WITH_EMBEDDED_SERVER:BOOL=OFF
     
217. WITH_EXTRA_CHARSETS:STRING=all
     
218. WITH_FAST_MUTEXES:BOOL=OFF
     
219. WITH_FEDERATED_STORAGE_ENGINE:BOOL=OFF
     
220. WITH_INNOBASE_STORAGE_ENGINE:BOOL=ON
     
221. WITH_LIBEDIT:BOOL=ON
     
222. WITH_LIBWRAP:BOOL=OFF
     
223. WITH_MYSQLD_LDFLAGS:STRING=
     
224. WITH_PARTITION_STORAGE_ENGINE:BOOL=ON
     
225. WITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON
     
226. WITH_PIC:BOOL=OFF
     
227. WITH_READLINE:BOOL=OFF
     
228. WITH_SSL:STRING=no
     
229. WITH_UNIT_TESTS:BOOL=ON
     
230. WITH_VALGRIND:BOOL=OFF
     
231. WITH_ZLIB:STRING=system
     
232. ZLIB_INCLUDE_DIR:PATH=/usr/include
     
233. [/ACLOCAL_EXECUTABLE:FILEPATH=ACLOCAL_EXECUTABLE-NOTFOUND
     
234. AUTOCONF_EXECUTABLE:FILEPATH=AUTOCONF_EXECUTABLE-NOTFOUND
     
235. AUTOHEADER_EXECUTABLE:FILEPATH=AUTOHEADER_EXECUTABLE-NOTFOUND
     
236. AUTOMAKE_EXECUTABLE:FILEPATH=AUTOMAKE_EXECUTABLE-NOTFOUND
     
237. AWK_EXECUTABLE:FILEPATH=/usr/bin/gawk
     
238. BACKUP_TEST:BOOL=OFF
     
239. BISON_EXECUTABLE:FILEPATH=BISON_EXECUTABLE-NOTFOUND
     
240. BZR_EXECUTABLE:FILEPATH=BZR_EXECUTABLE-NOTFOUND
     
241. CAT_EXECUTABLE:FILEPATH=/bin/cat
     
242. CMAKE_AR:FILEPATH=/usr/bin/ar
     
243. CMAKE_BUILD_TYPE:STRING=RelWithDebInfo
     
244. CMAKE_COLOR_MAKEFILE:BOOL=ON
     
245. CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++
     
246. CMAKE_CXX_FLAGS:STRING=
     
247. CMAKE_CXX_FLAGS_DEBUG:STRING=-g
     
248. CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
     
249. CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
     
250. CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
     
251. CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc
     
252. CMAKE_C_FLAGS:STRING=
     
253. CMAKE_C_FLAGS_DEBUG:STRING=-g
     
254. CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
     
255. CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
     
256. CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
     
257. CMAKE_EXE_LINKER_FLAGS:STRING=
     
258. CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING=
     
259. CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING=
     
260. CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING=
     
261. CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
262. CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
     
263. CMAKE_LINKER:FILEPATH=/usr/bin/ld
     
264. CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make
     
265. CMAKE_MODULE_LINKER_FLAGS:STRING=
     
266. CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING=
     
267. CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING=
     
268. CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING=
     
269. CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
270. CMAKE_NM:FILEPATH=/usr/bin/nm
     
271. CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy
     
272. CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump
     
273. CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib
     
274. CMAKE_SHARED_LINKER_FLAGS:STRING=
     
275. CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING=
     
276. CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING=
     
277. CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING=
     
278. CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING=
     
279. CMAKE_SKIP_RPATH:BOOL=NO
     
280. CMAKE_STRIP:FILEPATH=/usr/bin/strip
     
281. CMAKE_USE_RELATIVE_PATHS:BOOL=OFF
     
282. CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE
     
283. COMMUNITY_BUILD:BOOL=ON
     
284. CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND
     
285. CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/libform.so
     
286. CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h
     
287. CURSES_INCLUDE_PATH:PATH=/usr/include
     
288. CURSES_LIBRARY:FILEPATH=/usr/lib/libcurses.so
     
289. CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/libncurses.so
     
290. CYBOZU:BOOL=OFF
     
291. DISABLE_SHARED:BOOL=OFF
     
292. DTRACE:FILEPATH=DTRACE-NOTFOUND
     
293. ENABLED_LOCAL_INFILE:BOOL=OFF
     
294. ENABLED_PROFILING:BOOL=ON
     
295. ENABLE_DEBUG_SYNC:BOOL=ON
     
296. ENABLE_GCOV:BOOL=OFF
     
297. EXECUTABLE_OUTPUT_PATH:PATH=
     
298. GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND
     
299. GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND
     
300. INSTALL_BINDIR:STRING=bin
     
301. INSTALL_DOCDIR:STRING=docs
     
302. INSTALL_DOCREADMEDIR:STRING=.
     
303. INSTALL_INCLUDEDIR:STRING=include
     
304. INSTALL_INFODIR:STRING=docs
     
305. INSTALL_LAYOUT:STRING=STANDALONE
     
306. INSTALL_LIBDIR:STRING=lib
     
307. INSTALL_MANDIR:STRING=man
     
308. INSTALL_MYSQLDATADIR:STRING=data
     
309. INSTALL_MYSQLSHAREDIR:STRING=share
     
310. INSTALL_MYSQLTESTDIR:STRING=mysql-test
     
311. INSTALL_PLUGINDIR:STRING=lib/plugin
     
312. INSTALL_PLUGINTESTDIR:STRING=
     
313. INSTALL_SBINDIR:STRING=bin
     
314. INSTALL_SCRIPTDIR:STRING=scripts
     
315. INSTALL_SHAREDIR:STRING=share
     
316. INSTALL_SQLBENCHDIR:STRING=.
     
317. INSTALL_SUPPORTFILESDIR:STRING=support-files
     
318. LIBRARY_OUTPUT_PATH:PATH=
     
319. LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize
     
320. MANUFACTURER:STRING=Built from Source
     
321. MYSQL_DATADIR:PATH=/usr/local/mysql/data
     
322. MYSQL_DOCS_LOCATION:PATH=
     
323. MYSQL_MAINTAINER_MODE:BOOL=OFF
     
324. NO_ALARM:BOOL=1
     
325. SYSCONFDIR:PATH=/usr/local/mysql/etc
     
326. TAR_EXECUTABLE:FILEPATH=/bin/tar
     
327. WITHOUT_SERVER:BOOL=OFF
     
328. WITH_ARCHIVE_STORAGE_ENGINE:BOOL=OFF
     
329. WITH_ATOMIC_LOCKS:STRING=
     
330. WITH_BLACKHOLE_STORAGE_ENGINE:BOOL=OFF
     
331. WITH_DEBUG:BOOL=OFF
     
332. WITH_EMBEDDED_SERVER:BOOL=OFF
     
333. WITH_EXTRA_CHARSETS:STRING=all
     
334. WITH_FAST_MUTEXES:BOOL=OFF
     
335. WITH_FEDERATED_STORAGE_ENGINE:BOOL=OFF
     
336. WITH_INNOBASE_STORAGE_ENGINE:BOOL=ON
     
337. WITH_LIBEDIT:BOOL=ON
     
338. WITH_LIBWRAP:BOOL=OFF
     
339. WITH_MYSQLD_LDFLAGS:STRING=
     
340. WITH_PARTITION_STORAGE_ENGINE:BOOL=ON
     
341. WITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON
     
342. WITH_PIC:BOOL=OFF
     
343. WITH_READLINE:BOOL=OFF
     
344. WITH_SSL:STRING=no
     
345. WITH_UNIT_TESTS:BOOL=ON
     
346. WITH_VALGRIND:BOOL=OFF
     
347. WITH_ZLIB:STRING=system
     
348. ZLIB_INCLUDE_DIR:PATH=/usr/include
     

复制代码

其它的参数在INSTALL－SOURCE文件中有。参见附件。

kns1024wh

回复 1# 无风之谷


    话题一:MySQL的安装(包括5.5版本),编译参数

1. 常规的编译和 php 要整合在一起
   
2. 这里是用mysql最多的应用方式，顺序 apache mysql php 首先是编译好mysql 然后在编译php的时候要调用-–with-mysql=/usr/local/mysql
   
3. mysql的编译参数
   
4. ./configure –-prefix=/usr/local/mysql –-enable-assembler –-with-mysqld-ldflags=--all-static –-disable-shared –-with-extra-charsets=′gb2312,utf8′ –-without-debug –-localstatedir=/data/dbdata

复制代码

1. mysql cluster编译要启用NDB引擎
   
2. ./configure --prefix=/usr/local/mysql \
   
3. > --without-debug \
   
4. > --enable-thread-safe-client \
   
5. > --enable-assembler \
   
6. > --enable-profiling \
   
7. > --with-mysqld-ldflags=-all-static \
   
8. > --with-client-ldflags=-all-static \
   
9. > --with-charset=utf8 \
   
10. > --with-extra-charsets=all \
    
11. > --with-plugins=ndbcluster \
    
12. > --with-mysqld-user=mysql

复制代码

1. 
   
2. 或者再简单一点
   
3. ./configure  --prefix=/usr/local/mysql --with-big-tables  --with-innodb --with-charset=utf8 --with-extra-charsets=all --without-debug --with-ndbcluster --enable-assembler --with-pthread --enable-thread-safe-client
   
4. 这个在6.0中就编译了

复制代码

话题二:MySQL的启动与关闭

1. 默认源码目录下/support-files/mysql.server这个就是在/etc/init.d中的执行的启动脚本
   
2.    cp ./support-files/mysql.server /etc/init.d/mysqld
   
3.    chmod +x  /etc/init.d/mysqld
   
4.    chkconfig --add mysqld
   
5.    chkconfig mysqld on
   
6. 这样就可以设置mysql的开机启动
   
7. /etc/init.d/mysqld stop；/etc/init.d/mysqld restart;/etc/init.d/mysqld start
   
8. 这些就是可以调用的服务管理脚本

复制代码

话题三:浅析启动脚本与配置文件

1. my.cnf中主要是针对不同的应用进行设置
   
2. 在mysqld部分
   
3. max_allowed_packet = 4M
   
4. thread_stack = 256K
   
5. table_cache = 128K
   
6. sort_buffer_size = 6M
   
7. 查询排序时所能使用的缓冲区大小。注意：该参数对应的分配内存是每连接独占！如果有100个连接，那么实际分配的总共排序缓冲区大小为100 × 6 ＝ 600MB。所以，对于内存在4GB左右的服务器推荐设置为6-8M。
   
8. read_buffer_size = 4M
   
9. 读查询操作所能使用的缓冲区大小。和sort_buffer_size一样，该参数对应的分配内存也是每连接独享！
   
10. join_buffer_size = 8M
    
11. 联合查询操作所能使用的缓冲区大小，和sort_buffer_size一样，该参数对应的分配内存也是每连接独享！
    
12. myisam_sort_buffer_size = 64M
    
13. table_cache = 512
    
14. thread_cache_size = 64
    
15. query_cache_size = 64M
    
16. 指定MySQL查询缓冲区的大小。
    
17. tmp_table_size = 256M
    
18. max_connections = 768
    
19. 指定MySQL允许的最大连接进程数。
    
20. max_connect_errors = 10000000
    
21. wait_timeout = 10
    
22. 指定一个请求的最大连接时间，对于4GB左右内存的服务器可以设置为5-10。
    
23. thread_concurrency = 8
    
24. 该参数取值为服务器逻辑CPU数量×2
    
25. skip-networking
    
26. 开启该选项可以彻底关闭MySQL的TCP/IP连接方式，如果WEB服务器是以远程连接的方式访问MySQL数据库服务器则不要开启该选项！否则将无法正常连接！

复制代码

话题四:连接MySQL常用的客户端

1. 默认都是localhost 如果有特殊需要 要指定IP 尽量少用% 帐号密码也要复杂点

复制代码

话题五:MySQL的简单管理:帐号添加删除,数据的增删改查

1. 使用phpmyadmin
   
2. 或者是 mysql-gui 以及其他的mysql的windows下的客户端都可以的
   
3. 命令 grant all 这个熟练管理帐号
   
4. drop create 要会用

复制代码

surpass_li

对于mysql dba来说，mysql的维护离不开命令行工具。运维的过程中随时会出现各种各样的问题，各种图形化工具使用是方便，但有时候手边没有工具时也要能进行系统的维护。

yahoon

一般来说自带的rpm确实够用了
既然是初级,那就是yum装就最初级了 呵呵
现在微博上都说oracle对mysql已经放弃完全开源的策略了
咱何不讨论一下其分支呢:
据我所知的 percona,drizzle,mariadb
可惜我没机会用,还是用的最原始的5.0.x(毕竟我不是dba)

哪位大大给咱解答一下 这些分支的优势和优缺点及应用场景呢???

yahoon

回复 12# ning_lianjie
我补一个
flush privileges;

呵呵

yahoon

回复 5# leo_ss_pku_cu


    这两个是啥东东,给个链接看看

ning_lianjie

回复 18# yahoon


    一个帮助设置系统的脚本

ning_lianjie

回复 14# kns1024wh


    强