ÀûÓÃ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
Ïà¹ØÎĵµ£º
Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
X:\proper\mysql\bin>mysql -h localhost -u root -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 5.0.22-community-nt-log
Type 'help;' or '\h' for help. Type ' ......
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. ......
½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇæ£¬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......
ÎÊÌâ½â¾öÁË£¬ÔÒòÊÇÔÚmy.cnfÖÐȱÉÙÁËÈçÏ´úÂ룺
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
Èç¹û²»¼ÓÒÔÉÏ´úÂ룬ÄÇô¼´±ãMYSQL±àÒ밲װʱָ¶¨µÄ±àÂëÊÇUTF8£¬ÄÇôÔÚ½¨¿âʱÆäĬÈϱàÂëÈÔÊÇLATIN1£¬¶øÓÉÓÚ×Ö·û¼¯µÄ¼Ì³ÐÐÔ£¬¿âÖеıíÒ²ÊÇLATIN1µÄÁË¡£
ÕâÀïÁм¸ÌõÃüÁ´ó¼Ò¿ÉÒÔ×Ô¼ºÊÔÏ ......
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
......