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 Á¬½Ó¡£ÖÕÓڳɹ¦ÁË¡£
Ïà¹ØÎĵµ£º
MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³ÆÖ®ÎªÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌØ¶¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌØ¹æ·¶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁ˰üº¬± ......
À´Ô´£º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 ......
mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show variables like "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name | Value
&nb ......
½ñÌìÔÚÊý¾Ý¿âÖвåÈëÁËÖÐÎÄ£¬·¢ÏÖÓеÄÊÇÂÒÂ룬ÓеIJ»ÊÇ£¬ºÜÊÇÄÉÃÆ¡£
×îºóÕÒµ½Á˽â¾ö°ì·¨£º
´ò¿ª /etc/mysql/my.cnf
ÔÚ£Ûmysqld]ºÍ£Ûclient]½ÚÏ·ֱðÌí¼Ó:
default-character-set = utf8
È»ºóÖØÐÂÆô¶¯mysql£¬ÐèҪעÒâµÄÊÇ£¬¶ÔÐÞ¸ÄÒÔǰ´´½¨µÄÊý¾Ý¿âÀ´Ëµ£¬ËûµÄ×Ö·û¼¯»¹ÊÇÔÀ´µÄ£¬ËùÒÔ»¹ÊÇ»á³öÏÖÂÒÂí£¬¶øÐ´´½¨µÄÊý¾Ý ......