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

Îå¸ö³£ÓÃMySQLͼÐλ¯¹ÜÀí¹¤¾ß

MySQLÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£ÓÉÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»Ìص㣬Ðí¶àÖÐСÐÍÍøվΪÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ΪÍøÕ¾Êý¾Ý¿â¡£
1¡¢phpMyAdmin£¨http://www.phpmyadmin.net/£©
phpMyAdminÊÇ×î³£ÓõÄMySQLά»¤¹¤¾ß£¬ÊÇÒ»¸öÓÃPHP¿ª·¢µÄ»ùÓÚWeb·½Ê½¼Ü¹¹ÔÚÍøÕ¾Ö÷»úÉϵÄMySQL¹ÜÀí¹¤¾ß£¬Ö§³ÖÖÐÎÄ£¬¹ÜÀíÊý¾Ý¿â·Ç³£·½±ã¡£²»×ãÖ®´¦ÔÚÓÚ¶Ô´óÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´²»·½±ã¡£
2¡¢MySQLDumper£¨http://www.mysqldumper.de/en/£©
MySQLDumperʹÓÃPHP¿ª·¢µÄMySQLÊý¾Ý¿â±¸·Ý»Ö¸´³ÌÐò£¬½â¾öÁËʹÓÃPHP½øÐдóÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄÎÊÌ⣬Êý°ÙÕ×µÄÊý¾Ý¿â¶¼¿ÉÒÔ·½±ãµÄ±¸·Ý»Ö¸´£¬²»Óõ£ÐÄÍøËÙÌ«Âýµ¼ÖÂÖмäÖжϵÄÎÊÌ⣬·Ç³£·½±ãÒ×Óá£Õâ¸öÈí¼þÊǵ¹úÈË¿ª·¢µÄ£¬»¹Ã»ÓÐÖÐÎÄÓïÑÔ°ü¡£
3¡¢Navicat£¨http://www.navicat.com/£©
NavicatÊÇÒ»¸ö×ÀÃæ°æMySQLÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢¹¤¾ß¡£ºÍ΢ÈíSQLServerµÄ¹ÜÀíÆ÷ºÜÏñ£¬Ò×ѧÒ×Óá£NavicatʹÓÃͼÐλ¯µÄÓû§½çÃ棬¿ÉÒÔÈÃÓû§Ê¹Óú͹ÜÀí¸üΪÇáËÉ¡£Ö§³ÖÖÐÎÄ£¬ÓÐÃâ·Ñ°æ±¾Ìṩ¡£
4¡¢MySQL GUI Tools£¨http://dev.mysql.com/downloads/gui-tools/£©
MySQL GUI ToolsÊÇMySQL¹Ù·½ÌṩµÄͼÐλ¯¹ÜÀí¹¤¾ß£¬¹¦ÄܺÜÇ¿´ó£¬ÖµµÃÍƼö£¬¿ÉϧµÄÊÇûÓÐÖÐÎĽçÃæ¡£
5¡¢MySQL ODBC Connector£¨http://dev.mysql.com/downloads/connector/odbc/£©
MySQL¹Ù·½ÌṩµÄODBC½Ó¿Ú³ÌÐò£¬ÏµÍ³°²×°ÁËÕâ¸ö³ÌÐòÖ®ºó£¬¾Í¿ÉÒÔͨ¹ýODBCÀ´·ÃÎÊMySQL£¬ÕâÑù¾Í¿ÉÒÔʵÏÖSQLServer¡¢AccessºÍMySQLÖ®¼äµÄÊý¾Ýת»»£¬»¹¿ÉÒÔÖ§³ÖASP·ÃÎÊMySQLÊý¾Ý¿â¡£
ÒÔÉϾÍÊÇÎÒ½éÉܵÄÎå¸ö³£ÓõÄMySQLά»¤¹ÜÀí¹¤¾ß£¬Èç¹ûÄãÖªµÀ¸üºÃµÄMySQL¹¤¾ß£¬ÇëÁôÑÔºÍÎÒÃÇ·ÖÏí¡£


Ïà¹ØÎĵµ£º

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

Mysql³£ÓÃÃüÁî½Å±¾
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÊÇ mysql -hÖ÷»ú -uÓû§Ãû -pÃØÃÜ
Àý×ÓÊÇ mysql -hlocalhost -uroot -p123456
Ҫȷ¶¨mysql°²×°Ê±ºò¹´Ñ¡ÁË¿ÉÒÔÔ¶³ÌÁ´½Ó¡£Èç¹ûµÇ½±¾µØ¼ÆËã»ú£¬-h¿ÉÒÔÊ¡ÂÔ£¬¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬 ......

mysqlÍâ¼üµÄʹÓÃ

ÏñMySQLÕâÑùµÄ¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÃǵĻù´¡ÊÇÔÚÊý¾Ý¿âµÄ±íÖ®¼ä´´½¨¹ØϵµÄÄÜÁ¦¡£Í¨¹ý·½±ãµØÔÚ²»Í¬±íÖн¨Á¢¼Ç¼µ½¼Ç¼µÄÁªÏµ£¬RDBMS¿ÉÒÔÀûÓò»Í¬µÄ·½·¨·ÖÎöÊý¾Ý£¬Í¬Ê±±£³ÖÊý¾Ý¿âÒÔϵͳµÄ·½Ê½¡¢×îСµÄÈßÓà½øÐÐ×éÖ¯¡£
¼òµ¥ÃèÊö£º
ÕâЩ¹Øϵ»ù±¾ÉÏÒÀ¿¿Íâ¼ü½øÐйÜÀí£¬ÔÚ¹ØϵÖÐËùÓбíÖоßÓÐÏàͬº¬ÒåµÄ×Ö¶Î×÷Ϊ¹«¹²²¿·ÖÀ´Á¬½Ó ......

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'
µ½ÍøÉ ......

CÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â£¬¶ÁÈ¡mysqlÄÚÈÝ

 //linuxϱàÒëg++ $(mysql_config --cflags)  ***.cpp  $(mysql_config --libs)
/*mysqlÊý¾Ý¿âÖбíµÄÄÚÈÝ
mysql> select * from maindb;
+------------------+---------+-------------+---------+----------+---------------------+---------------------+---------------------+------------------- ......

MySQLÖ®¶¯Ì¬±íÌØÕ÷

Èç¹ûÒ»¸öMyISAM±í°üº¬Èκοɱ䳤¶ÈÁУ¨VARCHAR, BLOB»òTEXTDynamic£©£¬»òÕßÈç¹ûÒ»¸ö±í±»ÓÃROW_FORMAT=DYNAMICÑ¡ÏîÀ´´´½¨£¬¶¯Ì¬´æ´¢¸ñʽ±»Ê¹Óá£
 
Õâ¸ö¸ñʽ¸üΪ¸´ÔÓÒ»µã£¬ÒòΪÿÐÐÓÐÒ»¸ö±íÃ÷ÐÐÓж೤µÄÍ·¡£µ±Ò»¸ö¼Ç¼ÒòΪ¸üеĽá¹û±»±äµÃ¸ü³¤£¬¸Ã¼Ç¼Ҳ¿ÉÒÔÔÚ³¬¹ýÒ»¸öλÖô¦½áÊø¡£
 
Äã¿ÉÒÔʹÓÃOPTIMIZE TAB ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ