MySQL 5.1 °²×°ÅäÖÃͼ½â
Ò»¡¢MySQL5.1°²×°
´ò¿ªÏÂÔØµÄ°²×°Îļþ£¬³öÏÖÈçϽçÃæ£º
mysql°²×°Ïòµ¼Æô¶¯£¬µã»÷“next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ·½±ãÊìϤ°²×°¹ý³Ì¡£
ÔÚ“MySQL Server£¨MySQL·þÎñÆ÷£©”ÉÏ×ó¼üµ¥»÷£¬Ñ¡Ôñ“This feature, and all subfeatures, will be
installed on local hard drive.”£¬¼´“´Ë²¿·Ö£¬¼°ÏÂÊô×Ó²¿·ÖÄÚÈÝ£¬È«²¿°²×°ÔÚ±¾µØÓ²ÅÌÉÏ”¡£µãÑ¡“Change...”£¬ÊÖ¶¯Ö¸¶¨°²×°Ä¿Â¼¡£
ÌîÉϰ²×°Ä¿Â¼£¬ÀýÈç“F:MySQL”£¬Ò²½¨Òé²»Òª·ÅÔÚÓë²Ù×÷ϵͳͬһ·ÖÇø£¬ÕâÑù¿ÉÒÔ·Àֹϵͳ±¸·Ý»¹ÔµÄʱºò£¬Êý¾Ý±»Çå¿Õ¡£°´“OK”¼ÌÐø¡£
È·ÈÏÒ»ÏÂÏÈǰµÄÉèÖã¬Èç¹ûÓÐÎ󣬰´“Back”·µ»ØÖØ×ö¡£°´“Install”¿ªÊ¼°²×°¡£
ÕýÔÚ°²×°ÖУ¬ÇëÉÔºò£¬Ö±µ½³öÏÖÏÂÃæµÄ½çÃæ¡£
µã»÷“next”¼ÌÐø£¬³öÏÖÈçϽçÃæ¡£
ÏÖÔÚÈí¼þ°²×°Íê³ÉÁË£¬³öÏÖÉÏÃæµÄ½çÃæ£¬ÕâÀïÓÐÒ»¸öºÜºÃµÄ¹¦ÄÜ£¬mysql ÅäÖÃÏòµ¼£¬²»ÓÃÏòÒÔǰһÑù£¬
×Ô¼ºÊÖ¶¯ÂÒÆß°ËÔãµÄÅäÖÃmy.ini ÁË£¬½«“Configure the Mysql Server now”Ç°ÃæµÄ¹´´òÉÏ£¬µã“Finish”½áÊø
Èí¼þµÄ°²×°²¢Æô¶¯mysqlÅäÖÃÏòµ¼¡£
¶þ¡¢ÅäÖÃMySQL Server
µã»÷“Finsh”£¬³öÏÖÈçϽçÃæ£¬MySQL ServerÅäÖÃÏòµ¼Æô¶¯¡£
µã»÷“next”³öÏÖÈçϽçÃæ£¬
Ñ¡ÔñÅäÖ÷½Ê½£¬“Detailed Configuration£¨ÊÖ¶¯¾«È·ÅäÖã©”¡¢“Standard Configuration£¨±ê×¼ÅäÖã©”£¬ÎÒÃÇÑ¡Ôñ“Detailed Configuration”£¬·½±ãÊìϤÅäÖùý³Ì¡£
Ñ¡Ôñ·þÎñÆ÷ÀàÐÍ£¬“Developer Machine£¨¿ª·¢²âÊÔÀ࣬mysql Õ¼ÓúÜÉÙ×ÊÔ´£©”¡¢“Server Machine£¨·þÎñÆ÷ÀàÐÍ£¬mysqlÕ¼Óý϶à×ÊÔ´£©”¡¢“Dedicated MySQL Server Machine£¨×¨ÃÅ
Ïà¹ØÎĵµ£º
Mysql怬
µÇ¼MySQLµÄÃüÁîÊÇmysql£¬ mysql µÄʹÓÃÓï·¨ÈçÏ£º
¡¡¡¡mysql [-u username] [-h host] [-p[password]] [dbname]
¡¡¡¡username Óë password ·Ö±ðÊÇ MySQL µÄÓû§ÃûÓëÃÜÂ룬mysqlµÄ³õʼ¹ÜÀíÕʺÅÊÇroot£¬Ã»ÓÐÃÜÂ룬עÒ⣺Õâ¸örootÓû§²»ÊÇLinuxµÄϵͳÓû§¡£MySQLĬÈÏÓû§ÊÇroot£¬ÓÉÓÚ³õʼûÓÐÃÜÂ룬µÚÒ»´Î½øÊ± ......
1. ¼ò½é
ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ²úÆ·ÖÐʹÓÃMySQLÊý¾Ý¿â±ØÐë½øÐбØÒªµÄÓÅ»¯¡£
ÓÅ»¯ÊÇÒ»¸ö¸´ÔÓµÄÈÎÎñ£¬±¾ÎÄÃèÊöMySQLÏ ......
1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name |
+----+------------------+
| 1 | test &nbs ......
LINUXÏ mysql¿Í»§¶Ë²»ÄÜÊäÈëÖÐÎÄ
½ñÌìÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚLINUXÏÂÊäÈëÖÐÎÄ£¬Ã»ÓÐÎÊÌ⣬µ«ÔÚMYSQL¿Í»§¶ËÉÏÎÞ·¨ÊäÈëÖÐÎÄ£¬ºÜÆæ¹Ö£¿
ÕÒÁ˺ܶà×ÊÁÏÖÕÓÚ½â¾öÁËÕâ¸öÎÊÌ⣬ÆäʵÕâ¸öºÍ×Ö·û¼¯Î޹ء£Í¨³£³öÏÖÔÚ×Ô¼º±àÒëµÄmysql°æ±¾ÉÏ£¬Èç¹ûÊÇREDHATµÄ»°£¬ÇëʹÓÃϵͳ×Ô´øMYSQL¿Í»§¶Ë¡£ÏµÍ³Ä¬ÈÏrpm°²×°µÄmysqlÔòûÓÐÕâ¸öÎÊÌâ³öÏÖ¡£
Á ......