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

ÀûÓÃmysqlµÄ×¢ÉäµãµÃµ½¸ü¶àmysqlµÄÐÅÏ¢

µ±×¢Éämysql¿âµÄÊäÈëµãµÄʱºò,ÎÒÃÇ¿ÉÒÔͨ¹ýversion()/user()/database()/password()µÈÄÚÖú¯ÊýÀ´µÃµ½mysqlµÄÏà¹ØÐÅÏ¢,ÆäʵÎÒÃÇÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃmysqlÄÚÖõıäÁ¿À´µÃµ½¸ü¶àµÄmysqlÐÅÏ¢
ÆäÖÐversion()¿ÉÒÔд³É@@versionÀ´°Ñversionµ±×ö±äÁ¿À´¶ÁÈ¡,ÕâÑùÒ»Ñù¿ÉÒԵõ½,ÆäËûµÄÄÚÖÃÊDz»¿ÉÒÔд³É±äÁ¿µÄÐÎʽ.
´ó¼Ò¶¼Ó¦¸ÃÓùýÀûÓÃpangolinÀ´×¢Èëmysql¿âµÄ×¢Éäµã,ÈÏÕæµÄÅóÓѶ¼Ó¦¸ÃÖªµÀ¿ÉÒԵĵõ½basedirºÍdatadirÕâÁ½¸ö±äÁ¿µÄÐÅÏ¢,Æäʵ»¹Óиü¶àµÄ±äÁ¿ÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃ
ÎÒÕûÀíÁ˼¸¸öÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓõ½,ÊÕ¼¯¸ü¶à¹ØÓÚmysqlµÄÅäÖÃÐÅÏ¢
@@have_openssl                 Èç¹ûmysqldÖ§³Ö¿Í»§¶Ë/·þÎñÆ÷ЭÒéµÄSSL(¼ÓÃÜ)ÔòΪYES
@@version_compile_os         ÅжÏϵͳÀàÐÍ
@@max_allowed_packet       °ü»òÈκÎÉú³ÉµÄ/Öмä×Ö·û´®µÄ×î´ó´óС
@@max_user_connections     MySQLÕË»§ÔÊÐíµÄ×î´óͬʱÁ¬½ÓÊý,0±íʾûÏÞÖÆ
@@skip_networking               Èç¹û·þÎñÆ÷Ö»ÔÊÐí±¾µØ(·ÇTCP/IP)Á¬½Ó£¬¸ÃֵΪON
@@table_type                       ĬÈϱíÀàÐÍ(´æ´¢ÒýÇæ)
@@basedir                           MySQL°²×°»ù׼Ŀ¼
@@character_set_database     ĬÈÏÊý¾Ý¿âʹÓõÄ×Ö·û¼¯
@@datadir                           Êý¾Ý¿â´æ´¢µÄµØ·½
@@expire_logs_days             ¶þ½øÖÆÈÕÖ¾×Ô¶¯É¾³ýµÄÌìÊý,ĬÈÏÊÇ0,±íʾ"ûÓÐ×Ô¶¯É¾³ý"
@@group_concat_max_len     ÔÊÐígroup_concat()º¯Êý½á¹ûµÄ×î´ó³¤¶È
@@log_error            &nb


Ïà¹ØÎĵµ£º

ÓÃmysql×÷openldapµÄºǫ́Êý¾Ý¿â

etting up OpenLDAP with MySQL backend
ÓÃmysql×÷ºǫ́Êý¾Ý¿â°²×°openldap
author: TBONIUS
OpenLDAP is an X.500 Lightweight Directory Access Server used for
centralized authentication and directory lookups. ......

ÐÞ¸ÄMySQLÊý¾Ý¿âµÇ½ÃÜÂëµÄ·½·¨

   MySQLĬÈÏûÓÐÃÜÂ룬°²×°Íê±ÏÔö¼ÓÃÜÂëµÄÖØÒªÐÔÊDz»ÑÔ¶øÓ÷µÄ¡£
£¨1£©ÃüÁî
       /usr/bin/mysqladmin -u root –p ‘old-password’ password 'new-password'
       ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
£ ......

»ùÓÚmysqlµÄweb³ÌÐòµÄÒ»¸öÐÔÄÜÌáÉýµÄ·½°¸

½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇ棬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......

mysqlÖØ×°ÎÊÌâ½â¾ö·½°¸

mysqlfrontÁ¬½Óʱ³öÏÖ“³ÌÐò×¢²áʱ¼äµ½ÆÚÁË£¬³ÌÐò½«±»ÏÞÖÆÔÚµ­Ä£Ê½ÏÂÔËÐДÕâ¸öÎÊÌâʱ£¬²»ÓÃÖØ×°£¬Ö»ÐèÔÚMysql Front µÄ°ïÖú²Ëµ¥ÏîµÄµÇ¼ÇÀïÊäÈëÒÔÏÂMysql FrontµÄ×¢²áÂë¼´¿É¡£
MysqlFront×¢²áÂëÈçÏ£º
0hjwKUddagvS41S9TIb8EwuiXwo4+dlr
t8z9sq/YRlP9e0zTx7jVlriD8bWlwoJM
TRlllybJ0+wce5rRZGaMBnWJH5H0/Pwv ......

Mysql ReplicationʵÏÖmysqlÖ÷´Ó¿â×Ô¶¯Í¬²½°²×°Ö¸ÄÏ

http://blog.csdn.net/zhangwenzhe/archive/2008/05/22/2470529.aspx
ÔÚ
MySQL 3.23.15
°æ±¾Ö®ºó
,MySQL
ÌṩÁËÊý¾Ý¿â¸´ÖƵŦÄÜ
,
¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âʵʱͬ²½
,
ÔöÇ¿ÁË
MySQL
Êý¾Ý¿âµÄÎȶ¨ÐÔ£¬¶øÇÒ¿ÉÒÔÔÚÆóÒµ¼¶Ó¦ÓõÄÊý¾Ý¿â²ãʵÏÖ
Cluster
£¬²»½ö´ó´óÌá¸ßÁË
mysql
µÄ°²È«ÐÔ£¬Í¬Ê±»¹¼õÇáÁË
DBA
´óÁ¿µÄ¹¤× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ