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

Mysql ÃüÁîʵÀý

1. Mysql Åàѵ
1.1. ÅàѵĿµÄ
±¾ÎĵµÊÇÕë¶ÔMySQL Êý¾Ý¿â·½ÃæµÄ»ù´¡Åàѵ£¬ÎªÁËʹÏîÄ¿×é³ÉÔ±Äܹ»´ïµ½Ê¹ÓÃMySQL Êý¾Ý¿âµÄÄ¿µÄ¡£
1.2. Åàѵ¶ÔÏó
¿ª·¢ÈËÔ±
1.3. ³£Óôʼ°·ûºÅ˵Ã÷
³£Óôʣº
Mysql£ºÒ»ÖÖÃâ·ÑµÄ¿çƽ̨µÄÊý¾Ý¿âϵͳ
E:\mysql£º±íʾÊÇÔÚdos ÃüÁî´°¿ÚÏÂÃæ
mysql> ±íʾÊÇÔÚmysql µÄÃüÁîÐÐÏÂ
1.4. ²Î¿¼ÐÅÏ¢
http://dev.mysql.com/doc/refman/5.0/en/index.html
2. MYSQL
2.1. Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû -pÓû§ÃÜÂë
Á¬½ÓÔ¶³Ì»úÆ÷£º
E:\mysql>mysql -h10.4.3.188 -uptsdb -p
µÈ¼Ûд·¨
E:\mysql>mysql --host=10.4.3.188 --user=ptsdb --password
Á¬½Ó±¾µØ»úÆ÷£º
E:\mysql>mysql -uroot -p
µÈ¼Ûд·¨
E:\mysql>mysql --user=root -password
£¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
×¢ÒâÊÂÏ»·¾³±äÁ¿path ÀïÃæÒªÉ趨mysqlµÄbinµÄ·¾¶£º
C:\Program Files\MySQL\MySQL Server 5.0\bin
2.2. ÐÞ¸ÄÃÜÂë
·½·¨Ò»£ºÊ¹ÓÃmysqladmin
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
Àý1£ºE:\mysql>mysqladmin -uroot password root
×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
Àý2£ºÔÙ½«rootµÄÃÜÂë¸ÄΪroot123¡£
E:\mysql>mysqladmin -uroot -proot password root123
·½·¨¶þ£ºÖ±½Ó¸üРuser ±í
mysql>UPDATE user SET password=PASSWORD("test123") WHERE user='test';
mysql> FLUSH PRIVILEGES;
mysql> SET PASSWORD FOR test=PASSWORD('test123');
mysql> FLUSH PRIVILEGES;
·½·¨Èý£ºÊ¹Óà grant
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿â.±í¸ñ| ÆäËû to Óû§@Ö÷»ú IDENTIFIED BY ¿ÚÁî
Àý1£º¸øtestÓû§ÔÚ±¾µØlocalhost ËùÓÐȨÏÞ(³ýÁËGRANT OPTION)£¬¿ÚÁîΪ test
(Ï൱ÓÚÐÞ¸ÄÁËtest Óû§µÄ¿ÚÁî)
mysql>grant all on *.* to test@localhost identified by "test";
µÈͬÓÚ
mysql>grant all on *.* to test @localhost identified by PASSWORD " *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 ";
Àý2¡¢Ôö¼ÓÒ»¸öÓû§testÃÜÂëΪabc£¬ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ£¬²¢¶ÔtestÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬ÈëMYSQL£¬È»ºó¼üÈëÒÔÏÂÃüÁ
mysql>grant select,insert,update,delete on test.* to test@"%" Identified by "abc";
ÔÚmysql.user ±íÖУ¬ÓÐÁ½¸ötest Óû§
Ò


Ïà¹ØÎĵµ£º

MySQL¶Ô±ê×¼SQLµÄÀ©Õ¹

MySQL·þÎñÆ÷°üº¬Ò»Ð©ÆäËûSQL DBMSÖв»¾ß±¸µÄÀ©Õ¹¡£×¢Ò⣬Èç¹ûʹÓÃÁËËüÃÇ£¬½«ÎÞ·¨°Ñ´úÂëÒÆÖ²µ½ÆäËûSQL·þÎñÆ÷¡£ÔÚijЩÇé¿öÏ£¬Äã¿ÉÒÔ±àд°üº¬MySQLÀ©Õ¹µÄ´úÂ룬µ«ÈÔ±£³ÖÆä¿ÉÒÆÖ²ÐÔ£¬·½·¨ÊÇÓÓ/*... */”×¢Ê͵ôÕâЩÀ©Õ¹¡£MySQL·þÎñÆ÷Äܹ»½âÎö²¢Ö´ÐÐ×¢ÊÍÖеĴúÂ룬¾ÍÏñ¶Ô´ýÆäËûMySQLÓï¾äÒ»Ñù£¬µ«ÆäËûSQL·þÎñÆ÷½«ºöÂÔ ......

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

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

MySQLÖеÄCREATE VIEWÓï·¨

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......

Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú

 Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾­Àú
  Ò»¡¢Ó²¼þ»·¾³
      CPU:4ºËIntel(R) Xeon(R) CPU           E5504  @ 2.00GHz
      6GÄڴ棬120GÓ²ÅÌ
  ¶þ¡¢Èí¼þ»·¾³
     L ......

mysqlÃüÁî´óÈ«

Æô¶¯£ºnet start mySql;
¡¡¡¡½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
¡¡¡¡ÁгöÊý¾Ý¿â£ºshow databases;
¡¡¡¡Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
¡¡¡¡Áгö±í¸ñ£ºshow tables£»
¡¡¡¡ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
¡¡¡¡½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
¡¡¡¡Æ¥Åä× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ