Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL Proxy°²×°ºÍʹÓÃ(Ò»)

°´ÕÕÊֲᰲװMySQL Proxy֮ǰÏÈÒª°²×°ÒÔÏÂÈí¼þ libevent 1.x or higher (1.3b or later is preferred) lua 5.1.x or higher glib2 2.6.0 or higher pkg-config libtool 1.5 or higher MySQL 5.0.x or higher developer files rpm²é¿´libevent $rpm -q libevent
libevent-1.1a-3.2.1 ÃãÇ¿ÓðÉ,¼ÒÏÂÀ´°²×°lua $tar xvzf lua-5.1.4.tar.gz $cd lua-5.1.4 $make linux $make install $cp etc/lua.pc /usr/local/lib/pkgconfig/ Ö®ºó°²×°MySQL Proxy°´×ªÊÀ¼ÌÐø±¨´í,ºÇºÇ,ËäÈ»ÊÖ²áÉ϶ÔÓÚglib2дµÄ°æ±¾ÊÇ2.6.0¼°ÒÔºóʵ¼ÊÔÚMySQL Proxy0.7.2ÉÏÊÇÒªÇó>2.16µÄ,¼ÌÐøÉý¼¶glib2 $tar xvzf glib-2.23.0.tar.gz $cd glib-2.23.0 $./configure $make $make install È»ºóÌáʾ°²×°libevent°æ±¾¹ýµÍ,ÔÎÁË $tar xvzf libevent-1.4.13-stable.tar.gz $cd libevent-1.4.13-stable $./configure $make $make install Õâ´ÎÔÙÈ¥°²×°MySQL Proxy $tar zxf mysql-proxy-0.7.2.tar.gz $cd mysql-proxy-0.7.2 $./configure --with-mysql=/usr/local/mysql/bin/mysql_config --with-lua $make $make install ĬÈϵÄmysql-proxy ±»°²×°µ½/usr/local/sbin/mysql-proxy¶øluaʵÀý½Å±¾ÔòÔÚ/usr/local/share/docÏÂ(²»¹ýºÃÏñÐèҪ֮ǰmake test²ÅÓÐ,²»È·¶¨). ²é¿´ÏÂMySQL ProxyµÄ°æ±¾ $mysql-proxy -V
mysql-proxy: error while loading shared libraries: /usr/local/lib/libmysql-chassis.so.0: cannot restore segment prot after reloc: Permission denied ±¨´í,ÕâÊÇSELinuxµÄÎÊÌâ,¿ÉÈçϽâ¾ö $chcon -t texrel_shlib_t /usr/local/lib/libmysql-chassis.so.0 $ mysql-proxy -V
mysql-proxy 0.7.2
  glib2: 2.23.0
  libevent: 1.4.13-stable
  lua: Lua 5.1.4
    LUA_PATH: /usr/local/lib/mysql-proxy/lua/?.lua
    LUA_CPATH: /usr/local/lib/mysql-proxy/lua/?.so
2009-12-18 00:05:34: (warning) g_set_prgname() called multiple times
  == plugins ==
  admin: 0.7.0
  proxy: 0.7.0 ÖÁ´ËMySQL Proxy°²×°Íê³É,¼ÇסLUA_PATH: /usr/local/lib/mysql-proxy/lua/?.luaÏÂÃæÒªÓõ½ Æô¶¯,±àÒëÆ


Ïà¹ØÎĵµ£º

mysql ÈÕÖ¾ÎļþµÄʹÓÃ

MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ ......

MySQLѧϰ(1)Procedure,TRIGGER,FUNTCION

MySQLµÄÒ²Ö§³Ö´æ´¢¹ý³Ì£¬º¯Êý£¬´¥·¢Æ÷¡£
ÒÔϸ÷¸ö¹¦ÄܵÄÏêÊö£¬Ö÷ÒªÊÇʾÀý¡£
/**1.¶¨Òå·Ö¸î·û*/
DELIMITER //
/**2.´´½¨º¯Êý-¼ÆËãÁ½ÊýÖ®ºÍ*/
CREATE FUNCTION f_sum(num1 INT,num2 INT) RETURNS INT
BEGIN
RETURN num1+num2;
END;
//
/**
*3.´´½¨´æ´¢¹ý³Ì
*˼·£º3.1.Óиô洢¹ý³ÌÔòɾ³ý£¬3.2ÓÐʹÓõÄÖмä±í ......

[C++]MySQLÊý¾Ý¿â²Ù×÷ʵÀý

»·¾³ÉèÖãº
°²×°ÍêMySQLÖ®ºó£¬½«°²×°Ä¿Â¼ÖеÄincludeĿ¼ÏµÄlibmysql.libÎļþ¿½µ½VS2008°²×°Ä¿Â¼ÖеÄVC\lib\Ï£¬È»ºóÔÚ ÏîÄ¿-Ñ¡Ïî-c/c++-³£¹æ Öеĸ½¼Ó°üº¬Ä¿Â¼ÒÔ¼° Á´½ÓÆ÷-³£¹æ Öеĸ½¼Ó¿âĿ¼ÖмÓÈë“c:\MySQL\include\”£¬²¢ÇÒÔÚ Á´½ÓÆ÷-ÊäÈë Öеĸ½¼ÓÒÀÀµÏîÄÚÌí¼Ó“lib ......

(ת)MySQL¸ü¸Ä/ÐÞ¸ÄrootÃÜÂëµÄÈýÖÖ·½·¨

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖУº
/e ......

mysqlÃüÁî

²âÊÔ»·¾³£ºmysql 5.0.45
¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿
ÕûÀí£ºleo
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓп ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ