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

Mysql³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µÚÈýÕС¢Ôö¼ÓÐÂÓû§
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
È磬Ôö¼ÓÒ»¸öÓû§user1ÃÜÂëΪpassword1£¬ÈÃÆä¿ÉÒÔÔÚ±¾»úÉϵǼ£¬ ²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬Èëmysql£¬È»ºó¼üÈëÒÔÏÂÃüÁ
grant select,insert,update,delete on *.* to user1@localhost Identified by "password1";
Èç¹ûÏ£Íû¸ÃÓû§Äܹ»ÔÚÈκλúÆ÷Éϵǽmysql£¬Ôò½«localhost¸ÄΪ"%"¡£
Èç¹ûÄã²»Ïëuser1ÓÐÃÜÂ룬¿ÉÒÔÔÙ´òÒ»¸öÃüÁÃÜÂëÈ¥µô¡£
grant select,insert,update,delete on mydb.* to user1@localhost identified by "";
µÚËÄÕУº ²Ù×÷Êý¾Ý¿â
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
ȱʡÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ mysql¿â´æ·Å×ÅmysqlµÄϵͳºÍÓû§È¨ÏÞÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊǶÔÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql;
show tables;
3¡¢ ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±íÃû;
4¡¢ ½¨¿âÓëɾ¿â£º
create database ¿âÃû;
drop database ¿âÃû;
5¡¢ ½¨±í£º
use ¿âÃû;
create table ±íÃû(×Ö¶ÎÁбí);
drop table ±íÃû;
6¡¢ Çå¿Õ±íÖмǼ£º
delete from ±íÃû;
7¡¢ ÏÔʾ±íÖеļǼ£º
select * from ±íÃû;
µÚÎåÕС¢µ¼³öºÍµ¼ÈëÊý¾Ý
1. µ¼³öÊý¾Ý£º
mysqldump --opt test > mysql.test
¼´½«Êý¾Ý¿âtestÊý¾Ý¿âµ¼³öµ½mysql.testÎļþ£¬ºóÕßÊÇÒ»¸öÎı¾Îļþ
È磺mysqldump -u root -p123456 --databases dbname > mysql.dbname
¾ÍÊǰÑÊý¾Ý¿âdbnameµ¼³öµ½Îļþmysql.dbnameÖС£
2. µ¼ÈëÊý¾Ý:
mysqlimport -u root -p123456 < mysql.dbname¡£
²»ÓýâÊÍÁ˰ɡ£
3. ½«Îı¾Êý¾Ýµ¼ÈëÊý¾Ý¿â:
Îı¾Êý¾ÝµÄ×Ö¶ÎÊý¾ÝÖ®¼äÓÃtab¼ü¸ô¿ª¡£
use test;
load data local infile "ÎļþÃû" into table ±íÃû;
1:ʹÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES;
2:2¡¢´´½¨Ò»¸öÊý¾Ý¿âMYSQLDATA
mysql> CREATE DATABASE MYSQLDATA;
3:Ñ¡Ô


Ïà¹ØÎĵµ£º

mysql textºÍblob±È½Ï


1.
blobÊǶþ½øÖÆ´ó¶ÔÏó,¿ÉÒÔÈÝÄɿɱäÁ¿ÊýÁ¿µÄÊý¾Ý,ÆäÖÐblob·ÖΪ4ÖÐÀàÐÍ:TINYBLOB,BLOB,mediumblobºÍLongBlob,ËûÃÇÈÝÄɵij¤¶ÈÊDz»Í¬µÄ.
TextͬÑùÒ²·ÖΪËÄÖÖÀàÐÍ:TINYTEXT¡¢TEXT¡¢MEDIUMTEXTºÍLONGTEXT
2.
blob±»ÊÓΪ¶þ½øÖÆ×Ö·û´®,Text±»ÊÓΪ·Ç¶þ½øÖÆ×Ö·û´®;
blobÁÐûÓÐ×Ö·û¼¯£¬²¢ÇÒÅÅÐòºÍ±È½Ï»ùÓÚÁÐÖµ×Ö½ÚµÄÊýÖµÖµ¡£ ......

Linux»·¾³µÄAMP°²×° MYSQL°²×°


1¡¢MYSQLµÄ°²×°
1£©Ê×Ïȵ±È»ÊÇÏÂÔØÔ´Âë°ü¿©£¬È磺mysql-5.0.27µÄ°²×°£¬http://www.mysql.com
2£©½âѹËõ£¬>tar -zxvf mysql-5.0.27.tar.gz
3£©½âѹÍê³É£¬½øÈëmysql-5.0.27Îļþ¼Ð£¬>cd mysql-5.0.27
4£©°²×°ÅäÖã¬>./configure --prefix=/opt/mysql --with-extra-charsets=all --with-unix-socket-path=/opt/m ......

Head First PHP MYSQL Ñ§Ï°Ëæ±Ê 1


1) 
°²×°Apache/2.2.14 ºÍ PHP/5.2.12 Ö®ºó£¬ÖØÐÂÆô¶¯Apache£¬Æô¶¯Ê§°Ü¡£²éÁËһЩ×ÊÁÏ£¬»ù±¾Éϸø³öµÄ½¨ÒéÊǽûµôExtension¡£ÎÒ¾Í×°ÁËÒ»¸öExtesion Mysqli¡£
ÐÞ¸Äphp.ini ×¢Ê͵ôÕâÒ»ÐУ¬¹ûÈ»ÉúЧ¡£
[PHP_MYSQLI]
;extension=php_mysqli.dll
°²×°Íêmysql£¬ÔÙÖØÐÂenableÕâ¸öÅäÖþͺÃÁË£¬¹À¼ÆÊÇÒÀÀµÄ³Ð©mysqlµÄ¿â¡£ ......

¹ØÓÚmysql archive´æ´¢ÒýÇæ

Õþ¸®»¹ÓÐÒ»¸öÈÃÊý¾Ý¿âר¼Ò̯Éϸü¶àÊÂÇéµÄÖ°ÄÜ£¬¾ÍÊǰ²È«¿ØÖƺÍÊý¾ÝÉ󼯡£ÄÇЩ¹ÜÀíן£Á¿Êý¾Ý²Ö¿âµÄÆóÒµ¹ÙÔ±³£³£µÃ»Ø´ðÖîÈ瓺ÎÈ˺ÎʱÐÞ¸ÄÁËʲô”»òÕß“ºÎÈ˺Îʱ²é¿´ÁËʲô”ÕâÑùµÄÌáÎÊ¡£ÄÇЩӵÓÐÊýÒÔǧ¼ÆµÄÔ±¹¤£¬¿ªÕ¹×Ų»¼ÆÆäÊýµÄÒµÎñµÄÆóÒµ£¬Ã¿Ìì¶¼»á²úÉú³ö´óÁ¿µÄÈÕÖ¾¼Ç¼Êý¾Ý£¬¶øÇÒ±ØÐ뽫ÆäºÃºÃ±£´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ