MySql °²×°½Ì³Ì ʵ¼
×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾Éϰ²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËÒ»Ð©Ææ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢°²×°
Èç¹ûÊÇÆÕͨÓû§£¬ÇëÔÚ°²×°Ê±£¬Ñ¡Ôñ“Typical”£¬¼´µäÐÍÀàÐÍ£¬MYSQL½«°²×°µ½CÅÌÏÂProgram FilesϵÄMy SQLÎļþ¼ÐÄÚ¡£
2¡¢°²×°Íê±Ïºó£¬½øÐеÄÉèÖÃ
1£©½øÈëCMD
2£©CDµ½c:\program files\MySQL\MySQL Server 5.1\binÏÂ
3£©ÊäÈë“mysqld -install”,¼´MYSQL³ÉΪϵͳ·þÎñ£¬×÷Ϊ×Ô¶¯ÔËÐеķþÎñ¡£
4£©½øÈëMySQL Server Instance configure WizardÖУ¬½øÐÐÉèÖã¬Ñ¡Ôñ"Standard"ģʽ½øÐÐÉèÖ㬳ý·ÇÄãÊÇר¼Ò£¬¾ÍÑ¡"Detail"ģʽ¡£
5£©ÏÂÒ»²½ºó£¬»áÓÐÒ»¸öÒ³ÃæÈÃÄãÊäÈëÃÜÂ룬ÔʼµÄrootµÄÃÜÂëΪ¿Õ£¬ÕâÀï¼Ù¶¨ÄãÐèÒªÉèÖõÄÃÜÂëΪ"sa"
6£©ÏÂÒ»²½ºó£¬µã»÷execute£¬Èç¹û´ËʱÌáʾ“error 1045”£¬ËµÃ÷ÔʼµÄrootÃÜÂ벻Ϊ¿Õ
7£©finish
3¡¢½øÈëMySQL
1£©½øÈëCMD
2£©CDµ½ÉÏÒ»²½µÄĿ¼ÖÐ
3£©ÊäÈë“mysql -uroot -p”»áÌáʾÊäÃÜÂ룬ÃÜÂë¼´Äã¸Õ²ÅÉèÖõģ¬´Ë´¦Îª“sa”¡£
4£©½øÈ¥À²£¡
µÇ¼Êý¾Ý¿âʱ£¬ÓÐЩÈË¿ÉÄÜ»áÖ±½ÓÊäÈë mysql -p »ò mysql -root -p ÕâÑùµÄ»°¶¼²»Äܵǽµ½rootÓû§Ï£¬Òò´ËÄãÊäÈëµÄÃÜÂë¿Ï¶¨²»¶Ô£¬ËùÒÔ»áÌáʾ1045´íÎó¡£
»¶Òû·ÃÎÊ,²é¿´¸ü¶àÓйØJAVA·½ÃæµÄ¼¼ÊõÎÄÕ http://blog.csdn.net/robinlovesnow
Ïà¹ØÎĵµ£º
1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
ÒѾÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
ÎÊÌ⣺
cat /etc/mysql/my.conf
ÕÒµ½ÏÂÃæÒ»ÐÐ
bind-address = 127.0.0.1
Î ......
mysql error number 2003
Can't connect to MySQL server xxx.xxx.xxx.xxx (10061)
ÔÚubuntu 9.04ÖÐĬÈϰ²×°ÁËmysql£¬Ä¬ÈÏÖ»Äܱ¾µØ·ÃÎÊ£¬googleÁËһϣº
²ÉÓÃ
µÇ¼µ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ´ÐÐ
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
¼´¿É
Èç¹ûÒªÉèÖÃΪ ......
Java´úÂë
mysql> select version(),current_date;
²éѯmysqlµÄ°æ±¾ºÅ ºÍ ÈÕÆÚ
mysql> select version();
²éѯmysqlµÄ°æ±¾ºÅ
select now();
²éѯµ±Ç°ÈÕÆÚºÍ׼ȷµÄʱ¼ä
Java ......