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

MySQL³£ÓÃÓï¾ä

/*²éѯÊý¾Ý¿â*/
show databases;
/*´´½¨Êý¾Ý¿â*/
create database dengheping;
/*ʹÓÃÊý¾Ý¿â*/
use dengheping;
/*´´½¨±í*/
create table user(id int primary key auto_increment,name char(255));
/*²éѯ±í*/
show tables;
/*ÏÔʾ±í½á¹¹*/
desc user;
/*²åÈë×Ö¶Î*/
alter table user add password varchar(64);
/*ÐÞ¸Ä×Ö¶Î*/
alter table user modify password varchar(64) not null;
/*ɾ³ý×Ö¶Î*/
alter table user drop password;
ÉèÖñàÂë
 alter database mybbs default character set 'gbk';


Ïà¹ØÎĵµ£º

½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨


ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlº ......

ͨÓõÄmysql dump³ÌÐò

¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬 
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s ......

ÈçºÎ¸ü¸ÄÔÚUbuntuϵÄMySQLµÄĬÈÏÊý¾Ý¿â´æ´¢Î»ÖÃ

ÔÚUbuntuϰ²×°µÄMySQLĬÈÏÅäÖÃϵÄÊý¾Ý¿âÎļþ´æ´¢Î»ÖÃÊÇÔÚ/var/lib/mysql£¬
MySQLÊý¾Ý¿âµÄÎļþ½á¹¹ÊÇÔõôÑùµÄÄØ£¬¶ÔÓÚÕâÑù×Ó´´½¨µÄÊý¾Ý¿âÃüÁ
¡¡¡¡CREATE¡¡DATABASE¡¡mysqldb
¡¡¡¡ÔÚĬÈϵÄÊý¾Ý¿â´æ´¢Î»ÖÃϾͻáÓиöÎļþ¼Ðmysqldb¡£Òª²Ù×÷Êý¾Ý¿âÊ×ÏȵÃÍ£Ö¹Êý¾Ý¿â½ø³Ì£º
¡¡¡¡$sudo¡¡/etc/init.d/mysql¡¡stop
±¾ÎÄÒÔת ......

ÈÃMySQLÖ§³ÖInnoDB

ÔÚmysqlÖÐÊäÈëSHOW variables like "have_%"²é¿´£¬ÏÔʾÈçÏ£º
mysql> SHOW variables like "have_%";
  
+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| have_archive     ......

MySQL¿Í»§¶ËÃüÁîÐÐÓ¦Óü¼ÇÉ

1.ʵÏÖTAB¼ü²¹È«
SHELL>vi /etc/my.cnf
[mysql]
#no-auto-rehash
auto-rehash
SHELL>reboot mysqld
note: 1.ÒªÏÈuseµ½Ä³¸öÊý¾Ý¿âÏ£»2.Òª²¹È«µÄ¹Ø¼ü×ÖÐèÒª´óд¡£
2.promptÈòÙ×÷¸ü¼ÓÇå³þ
mysql>prompt \u@\h(\d) \r:\m:\s    (ÁÙʱ)
[mysql]   £¨³¤¾Ã£©
prompt=\\u@\\h
3.pagerÈÃä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ