MysqlÖÐÈçºÎÅúÁ¿Éú³É½Å±¾
[root@sql21 ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.26-rc-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql>
mysql> use information_schema
Database changed
INFORMATION_SCHEMAÌṩÁË·ÃÎÊÊý¾Ý¿âÔªÊý¾ÝµÄ·½Ê½¡£
ÔªÊý¾ÝÊǹØÓÚÊý¾ÝµÄÊý¾Ý£¬ÈçÊý¾Ý¿âÃû»ò±íÃû£¬ÁеÄÊý¾ÝÀàÐÍ£¬»ò·ÃÎÊȨÏ޵ȡ£ÓÐЩʱºòÓÃÓÚ±íÊö¸ÃÐÅÏ¢µÄÆäËûÊõÓï°üÀ¨“Êý¾Ý´Êµä”ºÍ“ϵͳĿ¼”
×îͨË×ÎÒÃÇ¿ÉÒÔ¿´³ÉÊDZ£´æÏµÍ³ÐÅÏ¢£¨Êý¾Ý×ֵ䣩µÄscheme¡£
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| ENGINES &nbs
Ïà¹ØÎĵµ£º
MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØ
ÒªµÄÔÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£Êǰº¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²
Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Ê ......
1¡¢ÔÚlinuxÏ£º
²é¿´mysql ÊÇ·ñÔËÐУºps -ef | grep myslq
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮: kill mysqlµÄ½ø³ÌºÅ¡£
¡¡¡¡Æô¶¯ MySQL :/usr/bin/safe_mysqld --skip-grant-tables &
¡¡¡¡¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
¡¡¡¡È»ºó¾ÍÊÇ
¡¡¡¡>use mysql
¡¡¡¡ ......
À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ֪µÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼Æ÷ÊÔͼֱ½Ó±à¼ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......