mysql Êý¾Ý¿â´óС
information_schema¿âÖаüº¬Á˶ÔÕû¸öÊý¾Ý¿âµÄºÜ¶àͳ¼ÆÐÅÏ¢£¬¿ÉÒÔͨ¹ý²é¿´ËüÃÇ£¬À´µÃµ½Êý¾Ý¿âÏà¹ØµÄÐÅÏ¢¡£
mysql> use information_schema;
Database changed
mysql> select count(1) as tables, concat(round(sum(table_rows)/1000000,2),'M') as rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') as data, concat(round(sum(index_length)/(1024*1024*1024),2),'G') as idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') as total_size,round(sum(index_length)/sum(data_length),2) as idxfrac from tables;
+--------+--------+--------+-------+------------+---------+
| tables | rows | data | idx | total_size | idxfrac |
+--------+--------+--------+-------+------------+---------+
| 719 | 96.41M | 30.17G | 9.63G | 39.80G | 0.32 |
+--------+--------+--------+-------+------------+---------+
1 row in set (1 min 9.64 sec)
Ïà¹ØÎĵµ£º
ǰÑÔ
¡¡¡¡MySQL GUI¹¤¾ßºÜ¶à£¬±¾Îľͳ£ÓõÄNavicat for MySQLÓëMySQL GUI ToolsµÄÌØÉ«¹¦ÄÜ×öÒ»¸öÏêϸ½éÉÜÓë±È½Ï¡£
¡¡¡¡£¨Ò»£©MySQL GUI Tools
¡¡¡¡MySQL¹Ù·½ÌṩµÄÒ»¸ö¿ÉÊÓ»¯½çÃæµÄMySQLÊý¾Ý¿â¹ÜÀí¿ØÖÆÌ¨£¬ÌṩÁËËĸöͼÐλ¯Ó¦ÓóÌÐò£¬ÕâЩͼÐλ¯¹ÜÀí¹¤¾ß¿ÉÒÔ´ó´óÌá¸ßÊý¾Ý¿â¹ÜÀí¡¢±¸·Ý¡¢Ç¨ÒƺͲéѯЧÂÊ¡£ËüÃÇ·Ö±ðÊÇ£º ......
mysql> flush privileges;ʲôÒâ˼£¿
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
´ð:
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......
myphpadmin¹¦ÄÜËäÈ»ÒѾºÜÇ¿£¬µ«Óû§ÌåÑé·½Ãæ²¢²»ºÜºÃ¡£
SQLyog
Mysql-front
EMS MySQL Manager
Mysqlcc
Navicat for MySQL
mysql-gui-tools
MySQL ͼÐι¤¾ß½éÉÜ£¨×ªÔØ£©
1¡¢Navicat
NavicatÊÇÒ»¸öÇ¿´óµÄMySQLÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢¹¤¾ß¡£Navicatµ¼º½Îª×¨Òµ¿ª·¢ÕßÌṩÁËÒ»Ì×Ç¿´óµÄ×ã¹»¼â¶ËµÄ¹¤¾ß£¬µ«Ëü¶ÔÓÚÐÂÓû§ÈÔÈ» ......
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jee="http://www.springframework.org/schema/jee"
&nbs ......
ÔÚDOSÖнøÐÐMySQLµÄ·ÃÎÊ¿ÉÄÜÂÒÂëµÄÇé¿öÓÐÈýÖÖ£¬
Ê×ÏÈ£¬Òª×öµÄÊǼì²éMySQLµÄÅäÖ㬰²×°µÄʱºòÑ¡Ôñutf-8µÄÓïÑÔ»·¾³»áʡȥºÜ¶àµÄÂé·³
1. ¼ì²éMySQLµÄ·þÎñ¶Ë¡¢¿Í»§¶ËµÄÓïÑÔÉèÖÃÊÇ·ñΪ“utf8”£¬²»ÊǵϰÊÖ¶¯½«my.int¸ü¸Ä¹ýÀ´£»
2. ÔÚPHP½øÐеÚÒ»´Îmysql_query֮ǰÉèÖÃʹÓÃÁ¬½ÓµÄ×Ö·û¼¯Îª"SET N ......