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

Mysql³£ÓÃÃüÁî½Å±¾

Mysql³£ÓÃÃüÁî½Å±¾
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÊÇ mysql -hÖ÷»ú -uÓû§Ãû -pÃØÃÜ
Àý×ÓÊÇ mysql -hlocalhost -uroot -p123456
Ҫȷ¶¨mysql°²×°Ê±ºò¹´Ñ¡ÁË¿ÉÒÔÔ¶³ÌÁ´½Ó¡£Èç¹ûµÇ½±¾µØ¼ÆËã»ú£¬-h¿ÉÒÔÊ¡ÂÔ£¬¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë123456£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË¡£
µÚÈýÕС¢Ôö¼ÓÐÂÓû§
Óï·¨ÊÇ grant ȨÏÞ on Êý¾Ý¿â.±í to Óû§Ãû@µÇ¼Ö÷»ú identified by “ÃÜÂë”
Àý×ÓÊÇ
ËùÓÐȨÏÞ grant all privalleges on zf.* to guqin@localhost identified by “123456″
selectȨÏÞ grant all select on zf.* to guqin@localhost identified by “123456″
µÚËÄÕС¢²Ù×÷Êý¾Ý¿â
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
2¡¢ ÏÔʾ¿âÖеÄÊý¾Ý±í¡£
use mysql;
show tables;
3¡¢ ÏÔʾÊý¾Ý±íµÄ½á¹¹¡£
desc ±íÃ÷;
4¡¢ ½¨¿âÓëɾ¿â
create database ¿âÃû;
drop database ¿âÃû;
5¡¢ ½¨±íºÍɾ±í¡£
use ¿âÃû;
create table ±íÃû(×Ö¶ÎÁбí);
drop table ±íÃû;
6¡¢ Çå¿Õ±íÖмǼ¡£
delete from ±íÃû;
7¡¢ ÏÔʾ±íÖеļǼ¡£
select * from ±íÃû;
µÚÎåÕС¢µ¼³öºÍµ¼ÈëÊý¾Ý
1. µ¼³öÊý¾Ý¡£
Óï·¨ÊÇ mysqldump –opt ¿âÃû.±íÃû > c:\data.sql
Àý×ÓÊÇ mysqldump -hlocalhost -uroot -p123456 zf.user>c:\data.sql
2. µ¼ÈëÊý¾Ý:
Óï·¨ÊÇ mysqldump –opt ¿âÃû < c:\data.sql
Àý×ÓÊÇ mysqldump -hlocalhost -uroot -p123456 zf<c:\data.sql
»òÕß
mysqlimport -hlocalhost -u root -p123456 < c:\data.sql
3. ½«Îı¾Êý¾Ýµ¼ÈëÊý¾Ý¿â:
use ¿âÃû;
load data local infile “ÎļþÃû” into table ±íÃû;
µÚÁùÕÐ ´´½¨Ò»¸öÊý¾Ý¿â±í
CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));
µÚÆßÕÐ Íù±íÖмÓÈë¼Ç¼
insert into ±íÃû values (”1″,”2″);
µÚ°ËÕÐ ÓÃÎı¾·½Ê½½«Êý¾Ý×°ÈëÊý¾Ý¿â±íÖÐ
LOAD DATA LOCAL INFILE “c:/data.sql” INTO TABLE ±íÃû;
µÚ¾ÅÕÐ µ¼Èë.sqlÎļþÃüÁÀýÈçc:/data.sql£©
use database;
source c:/data.sql
µÚÊ®ÕÐ ¸üбíÖÐÊý¾Ý
update MYTABLE set sex=”f” where name=’hyq’;
µÚʮһÕÐ ÐÞ¸´±í
repair ±íÃû


Ïà¹ØÎĵµ£º

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42    Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68    ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMaster·þÎñÆ÷
¡¡¡¡1¡¢±à¼­MasterÉϵÄ/etc/my.cnfÎļþ
¡¡¡¡¡¡ ......

ÀûÓÃmysqldumpµ¼³öµ¼ÈëmysqlËùÓÐÊý¾Ý¿â


1 µ¼³ö:
½øÈëÃüÁîÐÐ: Ö´ÐÐ
mysqldump -u username -p password –all-databases > all.sql
Ïêϸ²ÎÊý:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
2 µ¼Èë
½øÈëmysql -u username -p password
Ö´ÐÐsource all.sql;
......

MySQL 6 ÂÌÉ«¾«¼òBAT°æ

 
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
        MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ