|
源代码网推荐
瀛︿範浜嗗緢闀挎椂闂寸殑linux锛屾湁蹇呰鍋氫竴涓嬫暣鐞嗙瑪璁颁簡锛屼互涓嬫槸mysql鐨勫畨瑁呯瑪璁�,鍜屽父瑙佺殑涓�浜涗娇鐢ㄦ柟娉曘��
鍥犳垜鍠滄璋冭瘯浼樺寲绯荤粺,鎵�浠ュ湪缂栬瘧瀹夎鏃朵娇鐢ㄤ簡涓�浜涢�夐」澧炲姞缂栫▼鍚庣▼搴忕殑鎵ц鏁堢巼,鏈変簺鍙兘鎴戠悊瑙ｆ湁閿�,甯屾湜澶у鎸囧嚭. mail:flashc@21cn.com
鈼忓畨瑁卪ysql
# tar zxvf mysql-4.0.14.tar.gz -C /setup
# cd /setup/mysql-4.0.14
# groupadd mysql
# useradd mysql -g mysql -M -s /bin/false
# ./configure --prefix=/web/mysql 鎸囧畾瀹夎鐩綍
--without-debug 鍘婚櫎debug妯″紡
--with-extra-charsets=gb2312 娣诲姞gb2312涓枃瀛楃鏀寔
--enable-assembler 浣跨敤涓�浜涘瓧绗﹀嚱鏁扮殑姹囩紪鐗堟湰
--without-isam 鍘绘帀isam琛ㄧ被鍨嬫敮鎸� 鐜板湪寰堝皯鐢ㄤ簡 isam琛ㄦ槸涓�绉嶄緷璧栧钩鍙扮殑琛�
--without-innodb 鍘绘帀innodb琛ㄦ敮鎸� innodb鏄竴绉嶆敮鎸佷簨鍔″鐞嗙殑琛�,閫傚悎浼佷笟绾у簲鐢�
--with-pthread 寮哄埗浣跨敤pthread搴�(posix绾跨▼搴�)
--enable-thread-safe-client 浠ョ嚎绋嬫柟寮忕紪璇戝鎴风
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static 浠ョ函闈欐�佹柟寮忕紪璇戞湇鍔＄鍜屽鎴风
# make
# make install
# scripts/mysql_install_db 鐢熸垚mysql鐢ㄦ埛鏁版嵁搴撳拰琛ㄦ枃浠�
# cp support-files/my-medium.cnf /etc/my.cnf copy閰嶇疆鏂囦欢,鏈塴arge,medium,small涓変釜鐜涓嬬殑,鏍规嵁鏈哄櫒鎬ц兘閫夋嫨,濡傛灉璐熻嵎姣旇緝澶�,鍙慨鏀归噷闈㈢殑涓�浜涘彉閲忕殑鍐呭瓨浣跨敤鍊�
# cp support-files/mysql.server /etc/init.d/mysqld copy鍚姩鐨刴ysqld鏂囦欢
# chmod 700 /etc/init.d/mysqld
# cd /web
# chmod 750 mysql -R
# chgrp mysql mysql -R
# chown mysql mysql/var -R
# cd /web/mysql/libexec
# cp mysqld mysqld.old
# strip mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start
# netstat -atln
鐪嬬湅鏈夋病鏈�3306鐨勭鍙ｆ墦寮�,濡傛灉mysqld涓嶈兘鍚姩,鐪嬬湅/web/mysql/var涓嬬殑鍑洪敊鏃ュ織,涓�鑸兘鏄洰褰曟潈闄愭病鏈夎缃ソ鐨勯棶棰�
# ln -s /web/mysql/bin/mysql /sbin/mysql
# ln -s /web/mysql/bin/mysqladmin /sbin/mysqladmin
# mysqladmin -uroot password "youpassword" #璁剧疆root甯愭埛鐨勫瘑鐮�
# mysql -uroot -p
# 杈撳叆浣犺缃殑瀵嗙爜
mysql>use mysql;
mysql>delete from user where password=""; #鍒犻櫎鐢ㄤ簬鏈満鍖垮悕杩炴帴鐨勭┖瀵嗙爜甯愬彿
mysql>flush privileges;
mysql>quit
鈼忓畨瑁匘BI鍜孌BD for mysql 鐢ㄤ簬鎻愪緵perl璁块棶mysql鏁版嵁搴撶殑鎺ュ彛瑙勮寖,璇风‘璁や綘宸茬粡瀹夎浜唒erl,涓�鑸粯璁ょ郴缁熼兘瑁呬笂浜�
# cd /setup
# tar zxvf DBD-mysql-2.9002.tar.gz -C /setup
# tar zxvf DBI-1.38.tar.gz -C /setup
# cd DBI-1.38
# perl Makefile.PL
# make
# make test
# make install
鍥犱负鏈夌殑perl绋嬪簭涓璸erl鐨勮矾寰勬槸/usr/local/bin/perl,鑰岀孩甯界郴缁熼粯璁ゆ槸/usr/bin/perl,鎵�浠ユ渶濂藉仛涓�涓繛鎺�,淇濊瘉鍏煎鎬�
# ln -s /usr/bin/perl /usr/local/bin/perl
# cd ../DBD-mysql-2.9002
鐢熸垚瀹夎閰嶇疆鏂囦欢闇�瑕佸湪perl Makefile.PL鍚庢坊鍔犱竴浜涘弬鏁�,姣旇緝楹荤儲,鎴戜滑鍙互閫氳繃娣诲姞涓�涓埌/web/mysql/bin/mysql_config杩欎釜绋嬪簭鐨勮繛鎺ヨВ鍐抽棶棰�
绯荤粺浼氳嚜鍔ㄥ鎵捐繖涓懡浠ょ敓鎴愬畨瑁呮墍闇�瑕佺殑鏁版嵁搴撳弬鏁�
# ln -s /web/mysql/bin/mysql_config /sbin/mysql_config
# perl Makefile.PL
# make
# make instll (杩欓噷make test鎴戞�绘槸杩愯涓�鍗婂氨鍑洪敊锛屼絾鏄畨瑁呭悗鏄彲浠ヨ繍琛宮ysql鐩綍涓嬬殑娴嬭瘯鑴氭湰,涓嶇煡閬�3.x鐨刴ysql濡備綍)
鐜板湪浣犲彲浠ヨ繍琛屾祴璇曡剼鏈簡,涓嶈繃閫熷害寰堟參,鎸傚湪鍚庡彴濂戒簡
# perl /web/mysql/sql-bench/run-all-tests --user=root --password="youpassword"
闄�:
鈼弇ysql甯歌鐨勪竴浜涙湁鐢ㄧ殑閫夐」鍜屽懡浠�
mysqld -----寮�鍚棩蹇楁敮鎸�
--log
--log-update
--log-long-formart
鈼弇ysql
grant all on database.* to user identified by "password" 鏂板缓涓�user鐢ㄦ埛,璧嬩簣鍏禿atabase鏁版嵁搴撶殑鎵�鏈夋潈闄�
revoke all on database from user 绉婚櫎user鐢ㄦ埛鍦╠atabase鏁版嵁搴撲笂鐨勬墍鏈夋潈闄�
mysql -uroot -p --one-database databasename < file.sql 浠巉ile.sql鏂囦欢瀵煎叆sql璇彞鍒癲atabasename杩欎釜鏁版嵁搴撻噷
鈼弇ysqladmin
mysqladmin flush-logs 鍛戒护mysqld閲嶆柊鎵撳紑涓�涓柊鐨勬棩蹇楁枃浠�,灏辨槸娓呯┖鑰佹棩蹇楁枃浠�,鐩稿綋浜庤疆鍥炰簡
鈼弇ysqldump
--add-drop-table 瀵煎嚭sql璇彞鏃舵坊鍔燿roptable if exists璇彞
--quick 蹇�熷鍑�
--opt 浼樺寲閫夐」(鎺ㄨ崘)
鈼弇yisamchk
妫�鏌ヨ〃閫夐」
--extend-check 鎵╁睍妫�鏌�
--medium-check 閫熷害姣旇緝鎶樹腑鐨勪竴涓鏌ラ�夐」
淇琛ㄩ�夐」
--recover 淇琛ㄦ枃浠�
--safe-recover 瀹夊叏淇琛ㄦ枃浠�,姣�--recover瑕佹參
淇グ淇琛ㄩ」
--force 寮哄埗娓呴櫎涓婃鐨勪复鏃舵枃浠�
--quick 鍙牴鎹礌寮曟枃浠剁殑鍐呭杩涜淇
鈼弇ysql鐨勭鐞�
鍙互浣跨敤phpmyadmin(闇�瑕乸hp鐨勭幆澧冩敮鎸�)鍜宮ysqlcc(linux鍥惧舰鐣岄潰鏀寔,WINDOWS绯荤粺鏀寔
源代码网供稿. |
