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

MyEclipse Á¬½ÓÔ¶³ÌµÄ MYSQL

mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: È«Ñ¡
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë:      GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.68'IDENTIFIED BY 'admin' WITH GRANT OPTION
¡¡
ÕâÑùÊý¾Ý¿â¾ÍÔÊÐíÔ¶³ÌÁ¬½ÓÁË¡£
µ«ÔÚÓÃMyEclipseµÄdb
browser
Á¬½Óʱ£¬»¹ÊÇÌáʾÎÞ·¨Á¬½Ó¡£ÎҾͻ³ÒÉÊDz»ÊÇÎÒµÄmysqlÇý¶¯°üÓÐÎÊÌâ¡£
¸Õ¿ªÊ¼ÓõÄÇý¶¯°üÊÇmysql-connector-java-3.1.13-bin.jar
£¬»³Òɰ汾̫µÍ£¬½á¹ûÓÖDOWNÁËÒ»¸öеÄmysql-connector-java-5.1.7-bin.jar¡£¼ÌÐøÁ¬½Ó»¹ÊDz»ÐС£
Í·¶¼ÏëÆÆÁË£¬ÍøÉÏ×ÊÁϲéÁËÒ»¶ÑҲû·¢ÏÖÏà¹ØµÄ½â¾ö·½°¸£¬ÓÚÊDZ§×ÅÊÔÊÔ¿´µÄÐÄ̬ȥ²é¿´mysqlµÄÅäÖÃÎļþ
vi
/etc/mysql/my.cnf
½á¹û·¢ÏÖÓÐÕâô¼¸ÐÐ
´úÂë:bind-address = 127.0.0.1
#
# * Fine
Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack =
128K
thread_cache_size =
8
´ó¼Ò¿´µ½ÁË°Ébind-address = 127.0.0.1
ÕâÒ»ÐоͰÑÁ¬½ÓµØÖ·¸øÏÞÖÆËÀÁË£¬Ö»Äܱ¾»úÁ¬½Ó¡£ÓÚÊÇÎÒ°ÑÕâÐÐ×¢Ê͵ô\
´úÂë: #bind-address = 127.0.0.1
#
# * Fine
Tuning
#
ÖØÐÂÆô¶¯mysql
´úÂë:sudo /etc/init.d/mysql
restart
ÔÙÓÃMyEclipse Á¬½Ó¡£ÖÕÓڳɹ¦ÁË¡£


Ïà¹ØÎĵµ£º

ÀûÓÃ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½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql ......

MySQL ÃüÁîÐÐ

 MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ

À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html 
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......

ubuntu °²mysql install dbʱ³öÁËÎÊÌâ

ÕâÁ½ÌìÎÒ×°ÁËUBUNTU £¬ÔÚ±àÒë°²×°MYSQLµÄʱºòûÓгöʲôÎÊÌ⣬
µ½scripts/mysql_install_db --user=mysql
ÕâÒ»²½Ê±£¬µÃµ½ÈçÏ´íÎó
FATAL ERROR: Can't find mysqld. Please specify your installation
directory with the '--basedir=' option.
FATAL ERROR: Could not find SQL file '/fill_help_tables.sql'
µ½ÍøÉ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ