¿ìËÙÖØÖÃMySQLÓû§ÃÜÂë
1¡¢Í£Ö¹ÕýÔÚÔËÐеÄMySQL½ø³Ì
LinuxÏÂ,ÔËÐÐ killall -TERM mysqld
WindowsÏ£¬Èç¹ûд³É·þÎñµÄ¿ÉÒÔÔËÐУºnet stop mysql,Èçδ¼ÓÔØÎª·þÎñ£¬¿ÉÖ±½ÓÔÚÈÎÎñ¹Ü ÀíÆ÷ÖнøÐйرա£
2¡¢ÒÔ°²È«Ä£Ê½Æô¶¯MySQL
LinuxÏ£¬ÔËÐÐ mysqld_safe --skip-grant-tables &
WindowsÏ£¬ÔÚÃüÁîÐÐÏÂÔËÐÐ X:/MySQL/bin/mysqld-nt.exe --skip-grant-tables
3¡¢Íê³ÉÉÏÊöÁ½²½ÒÔºó¾Í¿ÉÒÔ²»ÓÃÃÜÂë½øÈëMySQLÁË
LinuxÏ£¬ÔËÐÐ mysql -u root
½øÈë
WindowsÏ£¬ÔËÐÐ X:/MySQL/bin/mysql -u root ½øÈë
4¡¢¸ü¸ÄÃÜÂë
ʹÓÃÃüÁîÐÞ¸Ä:
mysqladmin -u root -p password NewPassword
»òÕßʹÓà sql Ö±½ÓÐÞ¸ÄÓû§ÐÅÏ¢±í:
>use mysql;
¡¡ >select host, user, password from user;
>update user set password=password("NewPassword") where user="root";
>flush privileges;
×¢£±
: ±¾ÈËÔÚRED HAT LINUX SERVER 5 ÉϲÙ×÷MySQL 5.0.77°æ±¾³É¹¦£¨LINUX¹ÜÀíÔ±rootµÄÃÜÂëûÍü£º£©
±¾ÎÄÒý×Ô£ºhttp://www.macophp.com/?action=index&cid=3&page=2
£¬¸ù¾Ýʵ¼ÊÇé¿ö×öÁ˲¿·ÖÐ޸ġ£
Ïà¹ØÎĵµ£º
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
ÓÃmysql
ÄÚÖú¯Êýת»»ipµØÖ·ºÍÊý×Ö
ÀûÓÃÁ½¸öÄÚÖú¯Êý
inet_aton:½«ipµØÖ·×ª»»³ÉÊý×ÖÐÍ
inet_ntoa:½«Êý×ÖÐÍת»»³ÉipµØÖ·
³ä·ÖÀûÓÃmysqlÄÚÖõÄ
format
º¯Êý
ÓÈÆäÊÇÔÚ´¦Àí×Ö·û¸ñʽµÄʱºò,ÀýÈ罫12345ת»»³É12,345ÕâÑùµÄ,Ö»ÒªÓÃ:format(12345,0)¼´¿É,Èç¹ûÓÃformat(12345,2)ÔòÏÔÊ ......
°²×°Ê±µÄÓÅ»¯
(ÒÔϲâÊÔÊý¾Ý¶¼À´×ÔÓÚmysqlµÄ¹Ù·½ÍøÕ¾)
²»ÒªÓÃrpm»òÆäËû¶þ½øÖÆ·½Ê½°²×°
ÒªÓÃÔ´´úÂë×Ô¼º±àÒë
Èç¹ûÊDZ¼ÌÚϵͳ£¬ÍƼöÓÃpgcc±àÒëÆ÷
ÇÒʹÓÃ-O6µÄ±àÒë²ÎÊý
ÕâÑù±à³öÀ´µÄmysql±ÈÓÃgcc2.95µÄÒª¿ì1%
½öÓÃÓõÃ×ŵÄ×Ö·û¼¯±àÒëMySql
mysqlĿǰ֧³Ö¶à´ï34ÖÖ²»Í¬µÄ×Ö·û¼¯(mysql4.1.11)
µ«ÎÒÃdz£ÓõÄÒ²Î޷ǾÍÊÇlati ......
Connect MySQL GUI tools to WAMP 2.0
Posted by: Vladislav Sadykov ()
Date: January 24, 2009 09:31AM
Hay, I have a problem with MySQL database.
I have installed WAMP 2.0 server on my Windows machine and now I would like to
connect it with MySQL GUI tools 5.
The problem is that at the startup of ......
MySQL 5.1.40ÒѾ·¢²¼£¬ÔÚÕâÀïÓÐһЩеÄÌØÐÔ³öÏÖ£¬°üÀ¨MySQL»ùȺ»ùÓÚ´ÅÅ̵ÄÊý¾ÝÖ§³ÖµÈµÈ¡£¡¡¡¡MySQL 5.1.40ÒѾ·¢²¼£¬ÕâÒ»°æ±¾µÄMySQLÓкܶàÐµĹ¦ÄÜÌØÐÔ£¬Ï£ÍûÕâЩÐÂÌØÐÔÄÜÈôó¼Ò½ñºóµÄ¹¤×÷¸üÓÐЧÂÊ¡£MySQLÊÇÏÖÔÚ×îÁ÷ÐÐÒ»¸ö¶àÏ̵߳Ä,½á¹¹»¯²éѯÓïÑÔ(SQL)Êý¾Ý¿â·þÎñÆ÷.¾ø´ó¶àÊýPHPÍøÕ¾µÄÊý¾Ý¿âºǫ́¶¼ÊDzÉÓÃÕâÒ»Êý¾Ý¿â.
¡¡ ......
×÷ÕߣºÒ¶½ðÈÙ£¨Email: imysql#gmail.com£©£¬À´Ô´£ºhttp://iMySQL.cn£¬×ªÔØÇë×¢Ã÷×÷Õߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
MySQLÌṩÁËÊý¾Ý¿âµÄͬ²½¹¦ÄÜ£¬Õâ¶ÔÎÒÃÇʵÏÖÊý¾Ý¿âµÄÈßÔÖ¡¢±¸·Ý¡¢»Ö¸´¡¢¸ºÔؾùºâµÈ¶¼ÊÇÓм«´ó°ïÖúµÄ¡£±¾ÎÄÃèÊöÁ˳£¼ûµÄͬ²½ÉèÖ÷½·¨¡£
Ò»¡¢×¼±¸·þÎñÆ÷
ÓÉÓÚMySQL²»Í¬°æ±¾Ö®¼äµÄ(¶þ½øÖÆÈÕÖ¾)b ......