ÔÚMySQLÖе¼Èëµ¼³öÎļþ
Ç°Ì᣺MySQLÖдæÔÚÒ»¸öÓû§×Ô¼º½¨Á¢µÄÊý¾Ý¿â£¬¼ÙÉèΪmydb£¬mydbÖÐÓÐÒ»ÕÅÓû§×Ô¼º½¨Á¢µÄ±í¸ñ£¬¼ÙÉèÃû³ÆΪmytable
ÎÒµÄÇ°Ì᣺MySQLÖдæÔÚÁ½¸öÊý¾Ý¿â£¬yldbºÍyldb2£¬ÆäÖÐyldbÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í£¬ÃûΪpet
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
ÔÚConfigure the MySQL Server 5.1 server instance¹ý³ÌÖÐÓÐÒ»ÏîÊÇÒªÌáʾÊÇ·ñ"Include Bin Directory in Windows PATH"£¬Ñ¡ÔñÁËÕâ¸öÑ¡ÏÏ൱ÓÚ°ÑMySQLµÄ¿ÉÖ´ÐÐÎļþ·¾¶£¨binµÄ·¾¶£©¼ÓÈëµ½ÁËWINDOWSϵͳµÄ»·¾³±äÁ¿ÖУ¬ÕâÑùMySQL¿ÉÒÔ´ÓwindowsµÄÃüÁîÐÐÆô¶¯ÁË¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£ÕâÀïhostnameΪ·þÎñÆ÷µÄÃû³Æ£¬Èçlocalhost£¬usernameΪMYSQLµÄÓû§Ãû£¬Èçroot¡£
½øÈëÃüÁîÐкó¿ÉÒÔÖ±½Ó²Ù×÷MYSQLÁË¡£
2.¼òµ¥½éÉÜÒ»ÏÂMYSQLÃüÁ
mysql->CREATE DATABASE dbname;//´´½¨Êý¾Ý¿â
mysql->CREATE TABLE tablename;//´´½¨±í
mysql->SHOW DATABASES;//ÏÔʾÊý¾Ý¿âÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõÄÊý¾Ý¿â¡£
mysql->USE dbname;//Ñ¡ÔñÊý¾Ý¿â
mysql->SHOW TABLES;//ÏÔʾ±íÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõıí
mysql->DESCRIBE tablename;//ÏÔʾ´´½¨µÄ±íµÄÐÅÏ¢
Èý.´ÓÊý¾Ý¿âµ¼³öÊý¾Ý¿âÎļþ£º
1.½«Êý¾Ý¿âmydbµ¼³öµ½e:\mysql\mydb.sqlÎļþÖУº
´ò¿ª¿ªÊ¼->ÔËÐÐ->ÊäÈëcmd ½øÈëÃüÁîÐÐģʽ
c:\>mysqldump -h localhost -u root -p mydb >e:\mysql\mydb.sql
È»ºóÊäÈëÃÜÂ룬µÈ´ýÒ»»áµ¼³ö¾Í³É¹¦ÁË£¬¿ÉÒÔµ½Ä¿±êÎļþÖмì²éÊÇ·ñ³É¹¦¡£
ÎÒÊäÈëµÄÊÇ
C:\Documents and Settings\yangliu>mysqldump -h localhost -u root -p -C -v yldb >
e:\mysql\yldb.sql
Enter password: *******
-- Connecting to localhost...
-- Retrieving table structure for table pet...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...
¼ÓÈëÁË-C -v ¾Í¶à³öÁËÏÂÃæµÄÎåÐУ¬ÏÔʾÁ˾ßÌåµ¼³öµÄ¹ý³Ì¡£ÕâÑù¾Íµ¼³öÁËyldb.sqlÎļþµ½ÁËE:\mysql\ ÖÐ
2.
½«Êý¾Ý¿âmydbÖеÄmytableµ¼³öµ½e:\mysql\mytable.sqlÎļþÖУº
c:\>mysqldump -h lo
Ïà¹ØÎĵµ£º
¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿
ÕûÀí£ºleo
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇà ......
½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......
1¡¢µÇ½MySQL:
mysql -u root -p
2¡¢²é¿´Óû§ÐÅÏ¢
select user,host,password from mysql.user;
select user,host from mysql.user;
3¡¢ÉèÖÃÃÜÂë
set password for root@localhost=password('
ÔÚÕâÀïÌîÈërootÃÜÂë
');
4¡¢ÐÞ¸ÄÃÜÂë
·½·¨1£ºmysqladmin -u root -p password newpassword
·½·¨2£º ££mysql -u root ......
Éý»ªÌṩÖÕÉíÃâ·ÑASP+access PHP+mysqlÐéÄâÖ÷»ú
Ò»£ºÉý»ªÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾,ÓëÉý»ªÍ¬ÔÚÕ¾³¤ÖÕÉíÃâ·Ñ¿Õ¼ä·ö³Ö¼Æ»®.
1¡¢×ð¾´µÄÓû§ÄúºÃ,Ò²ÐíÄú»¹ÔÚΪÿÄêÒ»½»µÄ¿Õ¼ä·ÑÓ÷¢³î,Ò²ÐíÄúÏë»ñµÃÒ»¸ö¸üÓÅÖʵĿռäÈ´²»ÏëͶÈëÌ«¶à,´ÓÏÖÔÚÆð ÕâЩÎÊÌ⽫ÓÈжø½â→Éý»ªÍøÂç←ÓëÉý»ªÍ¬ÔÚÕ¾³¤·ö³Ö¼Æ»®È«ÃæÆô¶¯¡£
2¡¢Ã»ÓÐ×¢²á¹«Ë¾ ......