Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¿ìËÙÖØÖÃ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
£¬¸ù¾Ýʵ¼ÊÇé¿ö×öÁ˲¿·ÖÐ޸ġ£


Ïà¹ØÎĵµ£º

MYSQL¸´ÖƵļ¸ÖÖģʽ

 MySQL 5.1 ÖУ¬ÔÚ¸´ÖÆ·½ÃæµÄ¸Ä½ø¾ÍÊÇÒý½øÁËеĸ´ÖƼ¼Êõ£º»ùÓÚÐеĸ´ÖÆ¡£
MYSQL¸´ÖƵļ¸ÖÖģʽ
MySQL 5.1 ÖУ¬ÔÚ¸´ÖÆ·½ÃæµÄ¸Ä½ø¾ÍÊÇÒý½øÁËеĸ´ÖƼ¼Êõ£º»ùÓÚÐеĸ´ÖÆ¡£
¼òÑÔÖ®£¬ÕâÖÖм¼Êõ¾ÍÊǹØ×¢±íÖз¢Éú±ä»¯µÄ¼Ç¼£¬¶ø·ÇÒÔǰµÄÕÕ³­ binlog ģʽ¡£
´Ó MySQL 5.1.12 ¿ªÊ¼£¬¿ÉÒÔÓÃÒÔÏÂÈýÖÖģʽÀ´ÊµÏÖ£º
-- »ùÓÚ ......

ÐÞ¸ÄmysqlÃÜÂëµÄ·½·¨

use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
MYSQLADMIN -u root -p PASSWORD mypasswd
3.¿ÉÒÔÐÞ¸ÄMYSQLÎļþ¼ÐÖеÄMY.INIÎļþ
4.ʹÓÃSET PASSWORDÓï¾ ......

mysqlÖÐÎÄÂÒÂë

µÚÒ»²½£ºÐÞ¸ÄÊý¾Ý¿âÅäÖÃÎļþmy.ini
¿Í»§¶ËµÄĬÈÏ×Ö·û±àÂ룺
default-character-set=utf8
·þÎñÆ÷¶ËµÄĬÈÏ×Ö·û±àÂë
default-character-set=utf8
µÚ¶þ²½£ºÖØÐÂÆô¶¯mysqlÊý¾Ý¿â
net stop mysql
net start mysql
µÚ¶þ²½£ºÐÞ¸ÄapplicationContent.xml
ÐÞ¸ÄurlÊôÐÔ£¬½«Æä¸ÄΪ£ºjdbc:mysql://localhost:3306/member?useUni ......

MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷

MySQLÊý¾Ý¿âµÄ¼òµ¥²Ù×÷
Ò».´´½¨Êý¾Ý¿â ͨ¹ýshow databases;ÃüÁîÏÔʾËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÃû³Æ¡£
ͨ¹ýcreate database XXX;´´½¨Êý¾Ý¿âÃûΪXXXµÄÊý¾Ý¿â¡£ ÀýÈ磺mysql>create database test;     ¶þ.´´½¨±íµ¥ ͨ¹ýcreate table XXX();´´½¨ ÀýÈç: È»ºó¿ÉÒÔͨ¹ýdescÃüÁî²é¿´±íµ¥: ÀýÈç: Èý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ