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

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö

mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£»
mysql -u root
4. ÐÞ¸ÄrootÓû§µÄÃÜÂ룻
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
ÖØÐÂÆô¶¯MySQL£¬¾Í¿ÉÒÔʹÓÃÐÂÃÜÂëµÇ¼ÁË¡£
¶þ. MySQLÃÜÂëµÄ»Ö¸´·½·¨¶þ
ÓпÉÄÜÄãµÄϵͳûÓÐ safe_mysqld ³ÌÐò(±ÈÈçÎÒÏÖÔÚÓÃµÄ ubuntu²Ù×÷ϵͳ, apt-get°²×°µÄmysql) , ÏÂÃæ·½·¨¿ÉÒÔ»Ö¸´
1. Í£Ö¹mysqld£»
  sudo /etc/init.d/mysql stop
(Äú¿ÉÄÜÓÐÆäËüµÄ·½·¨,×Üֹ֮ͣmysqldµÄÔËÐоͿÉÒÔÁË)
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£»
mysql -u root
4. ÐÞ¸ÄrootÓû§µÄÃÜÂ룻
mysql> update mysql.user set password=PASSWORD('newpassword') where User='root';
mysql> flush privileges;
mysql> quit
ÖØÐÂÆô¶¯MySQL
/etc/init.d/mysql restart
¾Í¿ÉÒÔʹÓÃÐÂÃÜÂë newpassword µÇ¼ÁË¡£


Ïà¹ØÎĵµ£º

MySQLÖеÄmysqldumpÃüÁîʹÓÃÏê½â

MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔ­ÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØÒªµÄÔ­ÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£Êǰº¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾­³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔ­ÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Êõ²»¶ ......

mysqlÖÐÎÄÅÅÐò

UTF8 ĬÈÏУ¶Ô¼¯ÊÇ utf8_general_ci , Ëü²»Êǰ´ÕÕÖÐÎÄÀ´µÄ¡£ÄãÐèÒªÇ¿ÖÆÈÃMySQL°´ÖÐÎÄÀ´ÅÅÐò¡£
select

*

from
core_vender_info
order

by

convert
(vender_abbrev USING gbk) COLLATE gbk_chinese_ci
......

mysql´æ´¢¹ý³Ì£¬Óα꣬ÊÂÎï

drop procedure if exists pro_rep_shadow_rs;
delimiter |
----------------------------------
-- rep_shadow_rs
-- ÓÃÀ´´¦ÀíÐÅÏ¢µÄÔö¼Ó£¬¸üкÍɾ³ý
-- ÿ´ÎÖ»¸üÐÂÉÏ´ÎÒÔÀ´Ã»ÓÐ×ö¹ýµÄÊý¾Ý
-- ¸ù¾Ý²»Í¬µÄ±ê־λ
-- ÐèÒªÒ»¸öÊä³öµÄ²ÎÊý£¬
-- Èç¹û·µ»ØÎª0£¬Ôòµ÷ÓÃʧ°Ü£¬ÊÂÎñ»Ø¹ö
-- Èç ......

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ