ÀûÓÃ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
Ïà¹ØÎĵµ£º
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ĬÈÏûÓÐÃÜÂ룬°²×°Íê±ÏÔö¼ÓÃÜÂëµÄÖØÒªÐÔÊDz»ÑÔ¶øÓ÷µÄ¡£
£¨1£©ÃüÁî
/usr/bin/mysqladmin -u root –p ‘old-password’ password 'new-password'
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
£ ......
½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇ棬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......
mysqlfrontÁ¬½Óʱ³öÏÖ“³ÌÐò×¢²áʱ¼äµ½ÆÚÁË£¬³ÌÐò½«±»ÏÞÖÆÔڵģʽÏÂÔËÐДÕâ¸öÎÊÌâʱ£¬²»ÓÃÖØ×°£¬Ö»ÐèÔÚMysql Front µÄ°ïÖú²Ëµ¥ÏîµÄµÇ¼ÇÀïÊäÈëÒÔÏÂMysql FrontµÄ×¢²áÂë¼´¿É¡£
MysqlFront×¢²áÂëÈçÏ£º
0hjwKUddagvS41S9TIb8EwuiXwo4+dlr
t8z9sq/YRlP9e0zTx7jVlriD8bWlwoJM
TRlllybJ0+wce5rRZGaMBnWJH5H0/Pwv
......
http://blog.csdn.net/zhangwenzhe/archive/2008/05/22/2470529.aspx
ÔÚ
MySQL 3.23.15
°æ±¾Ö®ºó
,MySQL
ÌṩÁËÊý¾Ý¿â¸´ÖƵŦÄÜ
,
¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âʵʱͬ²½
,
ÔöÇ¿ÁË
MySQL
Êý¾Ý¿âµÄÎȶ¨ÐÔ£¬¶øÇÒ¿ÉÒÔÔÚÆóÒµ¼¶Ó¦ÓõÄÊý¾Ý¿â²ãʵÏÖ
Cluster
£¬²»½ö´ó´óÌá¸ßÁË
mysql
µÄ°²È«ÐÔ£¬Í¬Ê±»¹¼õÇáÁË
DBA
´óÁ¿µÄ¹¤× ......