ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨
http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;
Method 3:
mysql>SET PASSWORD FOR root=PASSWORD(’new_password’);
Ôö¼ÓÒ»¸ö²»ÖªµÀrootÃÜÂëÇé¿öÏÂÐÞ¸ÄrootÃÜÂë
mysqldÆô¶¯µÄʱºò¼ÓÉÏ–skip-grant-tables£¬È»ºóÂíÉÏÐÞ¸ÄÃÜÂ룬Ð޸ĺóÈ¥µô–skip-grant-tables£¬È»ºó¾ÍOKÁË¡£
Ïà¹ØÎĵµ£º
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql´æ´¢¹ý³ÌµÄ´´½¨£¬É¾³ý£¬µ÷Óü°ÆäËû³£ÓÃÃüÁî
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ ......
mastering Phpmyadmin
Beginning Php And Mysql³ÌÐòÉè¼Æ
Beginning PHP and MySQL from Novice to Professional 3rd Edition
Head First PHP MySQL
MySQLÈëÞµä
MySQL Stored Procedure Pr ......
ͬÊÂÀëÖ°£¬ÓÖÒ»¸öÒ»¸öÀÃ̯×ÓÒªÊÕʰ¡£ÕâÀïÐÞÐÞ£¬ÄÇÀï²¹²¹¶¼Ã»Óо«Á¦À´Ð´µã¶«Î÷¡£
Ã÷Ìì»Ø¼Ò£¬ÉÏÎçÕûÀíºÃÎĵµ¡£ÏÂÎç¾ö¶¨³éµãʱ¼ä£¬°Ñ×î½üµÄ¶«Î÷¾¡Á¿ÀíÒ»Àí¡£ºÜ¶àÁé¸Ð¶¼ÒѾÒÅÍü¡£ÎÒÃÇ×ÜÔÚ²»¶ÏÃæ¶Ô£¬ËùÒÔÎÒÃDz»¶ÏÒÅÍü¡£¡¾syslog¡¢mysqlÓÅ»¯¡¢´¥·¢Æ÷¡¢´æ´¢ ......
CREATE TABLE `user` (
`db_id` varchar(255) NOT NULL,
`name` varchar(45) default NULL,
`age` int(10) unsigned NOT NULL,
`address` varchar(45) default NULL,
PRIMARY KEY (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
// ÉèÖÃname='888'µÄageµÈÓÚname='111' ......
1. ¿ªÊ¼->¿ØÖÆÃæ°å->Ìí¼Ó»òɾ³ý³ÌÐò->Ð¶ÔØmysql
2. ¼ÙÉè֮ǰmysqlµÄ°²×°Ä¿Â¼ÊÇC:\Program Files\MySQL\MySQL Server 5.1/, ÄÇôÕâ¸öÏÂÃæ»¹±£ÁôÁËһЩ¶«Î÷£¬´ò¿ªmy.ini
3. ÕÒµ½#Path to the database root£¬ È»ºó°´ÕÕÕâ¸öPathÕÒµ½mysql,ɾµô
4. °ÑC:\Program Files\MySQLҲɾµô
5. ¿ªÊ¼->ÔËÐÐ ÊäÈër ......