ÀûÓÃ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ÖÐÿ¸öÃüÁîºó¶¼ÒªÒԷֺţ»½áβ¡£
£¨1£©ÏÔʾÊý¾Ý¿â
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.04 sec)
Mysql¸Õ°²×°ÍêÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ÆäÖУ¬mysql¿â·Ç³£ÖØÒª£¬ËüÀïÃæÓÐMyS ......
£¨1£©Æô¶¯
MySQL°²×°Íê³ÉºóÆô¶¯ÎļþmysqlÔÚ/etc/init.dĿ¼Ï£¬ÔÚÐèÒªÆô¶¯MySQL·þÎñʱÔËÐÐÏÂÃæÃüÁî¼´¿É¡£ [root@test1 init.d]# /etc/init.d/mysql start
£¨2£©Í£Ö¹
/usr/bin/mysqladmin -u root -p shutdown
£¨3£©ÉèÖÃMySQL×Ô¶¯Æô¶¯
1£©²ì¿´mysqlÊÇ·ñÔÚ×Ô¶ ......
ÎÊÌâ½â¾öÁË£¬ÔÒòÊÇÔÚ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>>;
......