mysqlÃÜÂë
MYSQL ÐÞ¸ÄrootÃÜÂëÃüÁî
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
ǰÌ᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
ÊäÈë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë update user set password=password('ÐÂÃÜÂë') where user='root';
»ØÏÔ
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> ״̬ÏÂÊäÈë FLUSH PRIVILEGES;
»ØÏÔ
Query OK, 0 rows affected (0.00 sec)
mysql> ״̬ÏÂÊäÈë quit
Í˳ö sql
×¢Òâÿ¸öÃüÁîºó¶¼Òª¼ÓÉÏÒ»¸ö·ÖºÅ ";"
mysql ²Å¿ªÊ¼Ö´ÐиÃÐÐÃüÁî
¶øµÚ¶þ¸öÖ¸Áî»áÈÃÒÑÔØÈë¼ÇÒäÌåµÄ mysql ϵͳ×ÊÁÏ¿â¸üÐÂ
ÖØÆð mysql .
ÔÚ¸üРroot ÃÜÂëáᣬÈÕááÒªÓë MySQL Á¬Ïߵķ½·¨Îª£º
mysql -uroot -pÐÂÃÜÂë
==================================================
Íü¼Çmysql µÄroot ÃÜÂ룺
ÏÈÈ·ÈÏÒѾɱµômysqld ½ø³ÌÁË£¬È»ºóÖ´ÐÐÕâ¸ö
/usr/bin/safe_mysqld --skip-grant-tables &
ÔÙÕâÑùµÇ¼
mysql -h 192.168.1.2 -u root
ÉϱߵÄ192.168.1.2 ÊÇcloud µÄmysqld ÔËÐлúÆ÷£¬Äã»»³É×Ô¼ºµÄ£¬ÕâÑùµÇ¼ÉÏ
È¥£¬¾Í¿ÉÒÔÐÞ¸ÄÃÜÂëÁË¡£
ÐÞ¸ÄÃÜÂë
1.mysql -h hostname –u root ÃüÁîµÇ¼µ½mysqld server ÓÃgrant ÃüÁî¸Ä±ä¿ÚÁî:
Grant all on *.* to root indentified by "111111"
2. mysqladmin -u Óû§Ãû-p ¾ÉÃÜÂëpassword ÐÂÃÜÂë
Àý1£º¸øroot ¼Ó¸öÃÜÂëab12¡£Ê×ÏÈÔÚDOS ϽøÈëĿ¼mysqlbin£¬È»ºó¼üÈë
ÒÔÏÂÃüÁî
mysqladmin -uroot password ab12
×¢£ºÒòΪ¿ªÊ¼Ê±root ûÓÐÃÜÂ룬ËùÒÔ-p ¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
2¡¢Àý2£ºÔÙ½«root µÄÃÜÂë¸ÄΪdjg345¡£
mysqladmin –u root -pab12 password djg345 (×¢Òâ-p ²»ÒªºÍºóÃæµÄÃÜÂë·Ö
¿ªÐ´£¬ÒªÐ´ÔÚÒ»Æð)
3.
use mysql; update user set password =password('yourpass') where user='r
oot'
4. ÔØÈëȨÏÞ±í£º `mysqladmin -h hostname flush-privileges' £¬»òÕßʹ
ÓÃSQL ÃüÁî`FLUSH PRIVILEGES'¡££¨µ±È»£¬ÔÚÕâÀÄãÒ²¿ÉÒÔÖØÆômysqld¡££©
mysql µÄ½¨¿â£¬Ìí¼ÓÊý¾Ý·½·¨£º
mysqi –u root
mysql>create database ttt;
mysql>source 1.txt
mysql>load data local infile "2.txt" into table board;
1.txt ÄÚÈÝ:
CREATE TABLE board (
boardid int(11) NOT NULL auto_increment,
boardname char(255),
PRIMARY KEY (boardid)
);
Ïà¹ØÎĵµ£º
MySQL×Ö·û´®º¯ÊýµÄÓ¦ÓÃÓë×¢ÒâÊÂÏî
ÒÔϵÄÎÄÕÂÖ÷ÒªÏò´ó¼ÒÃèÊöµÄÊÇMySQL×Ö·û´®º¯ÊýµÄʵ¼ÊÓ¦ÓÃÓëÆäʵ¼Ê²Ù×÷´úÂëµÄÃèÊö£¬Í¬Ê±±¾ÎÄ»¹¶ÔÆäÔÚʵ¼ÊÓ¦ÓÃÖУ¬Ò»Ð©ÖµµÃÎÒÃÇ´ó¼Ò×¢ÒâµÄÏà¹ØÊÂÏîµÄÃèÊö£¬ÒÔϾÍÊÇÎÄÕµÄÖ÷ÒªÄÚÈÝÃèÊö£¬ÍûÄã»áÓÐËùÊÕ»ñ¡£
CHARSET(str) ·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2 [,& ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......
½ü¶Îʱ¼äͻȻ¶ÔMYSQLÕâ¸ö¿ªÔ´Êý¾ÝÓÐÁËÐËȤ£¬Ö÷ÒªÊÇÆäÊÇ¿ªÔ´Ãâ·Ñ£¬ÏëÏëÒÔºóÎÞÂÛÊǹ«Ë¾×öÏîÄ¿»¹ÊǸöÈË×öЩ¼òµ¥µÄСϵͳ£¬¶¼¿ÉÒÔÑ¡Ôñ£¬ÓÚÊÇ»¨Á˵ãʱ¼äÑо¿ÁËÏ£¬ÏÖÔÚ·ÖÏíÏÂ×Ô¼ºµÄѧϰÐĵ᣽ñÌì¿´ÁËдÆäϵͳµÄ×é³ÉºÍÕûÌå½á¹¹£¬ÏÖÔÚ°ÑÕûÌåµÄ½á¹¹ÓÃVISIO»ÁËÏ£¬È»ºóÖðÒ»½âÊÍ£¬²¢²ûÊöÏÂÎÒµÄÀí½â£¬Ï±ßÊÇMySQLϵͳ½á¹¹Í¼µ ......
1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
¡¡¡¡mysqld ......