ÔÚ Cygwin ÖбàÒë MySQL ¿Í»§¶Ë
ת×Ôhttp://www.phpvim.net/windows/build-mysql-client-on-cygwin.html
MinTTY ÊÇÒ»¸öСÇɵ«È´ºÜʵÓÃµÄ Cygwin ÖÕ¶Ë»ú£¬µ«ÓиöÑÏÖØµÄÎÊÌâ¾ÍÊÇÎÞ·¨µ÷Óý»»¥Ð﵀ Windows ÔÉú³ÌÐò£¬±ÈÈç˵
mysql.exe£¬µ±ÄãÔÚ MinTTY ÖÐÊäÈëÈçϵÄÃüÁ
1
$ mysql -uroot
-p
±¾À´ mysql.exe »áÌáʾÊäÈëÃÜÂ룬µ«ÔÚ MinTTY ÖгÌÐò»áÖ±½Ó¹ÒÆð£¬²»ÔÙÏìÓ¦£¬Êµ¼ÊÉϼ´Ê¹ÔÚ -p
²ÎÊýºóÃæ¸úÉÏÃÜÂ룬ҲÊÇÒ»ÑùµÄ¡£
ijЩ³ÌÐò£¬±ÈÈç python£¬»áÌṩ²ÎÊý -i£¬Ê¹×ÔÉíÔÚÖÕ¶ËÖнøÈë½»»¥Ä£Ê½£¬¿Éϧ²¢·ÇËùÓеijÌÐò¶¼ÓÐÕâÑùµÄ²ÎÊý¡£
½â¾öµÄ°ì·¨£¬Ê¹Óà Cygwin °æ±¾µÄ MySQL ¿Í»§¶Ë£¬µ« Cygwin ²¢Ã»ÓÐÌṩ£¬ËùÒÔ¾ÍÖ»ÓÐ×Ô¼º¶¯ÊÖ±àÒëÒ»¸ö£¡
ÔÚ http://dev.mysql.com/downloads
ÏÂÔØÔ´Âë°ü²¢½âѹ¡£
1
2
3
$ wget
http://
dev.mysql.com/
get/
Downloads/
MySQL-5.5
/
mysql-5.5.0-m2.tar.gz/
from/
......
$ tar
zxvf mysql-5.5.0-m2.tar.gz
$ cd
mysql-5.5.0-m2
ÔÚ¶¯ÊÖ±àÒë֮ǰ£¬ÏÈ´ò¿ª Cygwin °²×°³ÌÐò°²×° readline£¬ÓÃÀ´Ìæ´ú MySQL ×Ô´øµÄ¡£MySQL Ô´Âë°üÀ¦°óµÄ
readline ÔÚ CygwinÖбàÒë»á±¨´í¡£
×¼±¸ºÃÒԺ󣬿ªÊ¼±àÒë¹ý³Ì£º
1
2
3
$ ./
configure --without-server
--without-readline
CFLAGS
=-O2 CXXFLAGS
=-O2
$ make
$ make
install
Cygwin µÄ±àÒëËÙ¶ÈÊǺÜÂýµÄ£¬ºÍÔÉú *nix ϵͳÍêȫû·¨±È£¬ËùÒÔÈç¹û²»ÊÇÏе½·¢»Å£¬×îºÃ²»ÒªÈ¥±àÒ듸´ÔÓ”µÄ MySQL
Server¡£
±àÒë°²×°Íê MySQL Client£¬´ò¿ª Windows ϵͳÖÐµÄ MySQL Server£¬Ê¹ÓÃÈçϵÄÃüÁî²âÊÔһϣº
1
$ mysql -h127.0.0.1 -uroot
-p
Ϊʲô¼ÓÉÏ -h127.0.0.1 ÄØ£¿Ä¬ÈϵÄÇé¿öÏ£¬²»´ø -h ²ÎÊý»òÕßʹÓà -h localhost£¬MySQL ¶¼»áʹÓà Unix
socket file Á¬½Ó·þÎñÆ÷£¬¼´Ê¹ÄãÔÚÃüÁîÖÐÖ¸¶¨Á˶˿ÚÒ²»á±»ºöÂԵģ¬ËùÒԿ϶¨Á¬½Ó²»Éϵģ¬ÌáʾÕÒ²»µ½ /tmp/mysql.sock¡£Ê¹ÓÃ
IP »òÕßÖ÷»úÃûºó£¬MySQL ¾Í»áʹÓà TCP/IP ģʽÁ¬½Ó·þÎñÆ÷µÄ 3306 ¶Ë¿Ú£¬ÕâÑù¾ÍʲôûÎÊÌâÁË¡£
ΪÁË·½±ã£¬ÔÚÅäÖÃÎļþÖÐÇ¿ÖÆ¿Í»§¶ËʹÓà TCP/IP Á¬½Óģʽ¡£
¸´ÖÆ mysql-5.5.0-m2/support-files ÖеÄÅäÖÃÎļþÑù°åµ½ /etc/my.cnf£¬EG£º
1
$ cp
support-files/
my-medium.cnf /
etc/
my.cnf
ÔÚ [client] ÖмÓÈë protocol=TCP£¬EG£º
1
2
3
4
5
6
7
8
9
10
# The following options will be passed to all MySQL clients
[
client]
#password = your_password
port
Ïà¹ØÎĵµ£º
¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......
1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
groupadd mysql
useradd -g mysq ......
[MySQLÓÅ»¯] -- ÈçºÎʹÓÃSQL Profiler ÐÔÄÜ·ÖÎöÆ÷
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:diesou
mysql µÄ sql ÐÔÄÜ·ÖÎöÆ÷Ö÷ÒªÓÃ;ÊÇÏÔʾ sql Ö´ÐеÄÕû¸ö¹ý³ÌÖи÷Ïî×ÊÔ´µÄʹÓÃÇé¿ö¡£·ÖÎöÆ÷¿ÉÒÔ¸üºÃµÄչʾ³ö²»Á¼ SQL µÄÐÔÄÜÎÊÌâËùÔÚ¡£ ÏÂÃæÎÒÃǾÙÀý½éÉÜһϠMySQL SQL Profiler µÄʹÓ÷½·¨£º Ê×ÏÈ£¬¿ªÆô MySQL SQL ......
×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸ö˶¼Ã»´í¡£
MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆÎª255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......
Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:gangzhong
REPAIR TABLE `table_name` ÐÞ¸´±í OPTIMIZE TABLE `table_name` ÓÅ»¯±í myisamchk table.MYI ÐÞ¸´Ë÷Òý REPAIR TABLE ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄ±í¡£ myisamchk TABLE.MYI ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄË÷ÒýÎļþ¡£ OPTIMIZE TABLE ÓÃÓÚ»ØÊÕÏÐÖõÄÊý¾Ý ......