MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á()
[Ô´´] MYSQL Ë«»úÈȱ¸ÅäÖÃÊÖ²á[Ô´´]
http://www.chinaunix.net ×÷Õß:squall1 ·¢±íÓÚ£º2007-07-23 19:01:43
¡¾·¢±íÆÀÂÛ¡¿¡¾²é¿´ÔÎÄ¡¿¡¾´æ´¢±¸·ÝÖ®¼ÒÌÖÂÛÇø¡¿¡¾¹Ø±Õ¡¿
×÷ÕߣºCU-squall
·¢±íÓÚ£º2005Äê4ÔÂ18ÈÕ 8:21 ¿ÉÒÔ²»¾×÷ÕßͬÒâ×ÔÓÉ´«²¥£¬Çë×¢Ã÷×÷Õß³ö´¦¡£
ʹÓõÄÈíÌ壺¢Ùmysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz£¬
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz/from/pick
Ò»¡¢°²×°MYSQL
# cp mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz /usr/local/
# tar zxvf mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz
# mv mysql-standard-4.1.9-pc-linux-gnu-i686 mysql
# cd mysql
# more INSTALL-BINARY
²é¿´°²×°Îĵµ£¬×¢ÒâÒÔºìÉ«¿òÄÚΪÖ÷¡£
# groupadd mysql £¨½¨Á¢mysql×飩
# useradd -g mysql mysql £¨½¨Á¢mysqlÓû§²¢½«ÆäÓû§¼ÓÈë¸Ã×飩
# scripts/mysql_install_db --user=mysql £¨ÒÔmysqlÓû§Éí·ÝÖ´ÐÐÊý¾Ý¿â³õʼ»¯°²×°½Å±¾£©
# chown -R root . £¨¹éÊôrootȨÏÞΪµ±Ç°Ä¿Â¼£©
# chown -R mysql data £¨¹éÊômysqlȨÏÞΪdataĿ¼£©
# chgrp -R mysql . £¨¸Ä±ämysqlµµ°¸/Ŀ¼µÄʹÓÃÕßÓëȺ×éÓµÓÐÈËΪµ±Ç°Ä¿Â¼£©
# bin/mysqld_safe --user=mysql & £¨ÒÔmysqlÓû§Éí·Ýºǫ́Æô¶¯mysqlÊý¾Ý¿â½ø³Ì£©
Ö®ºóÎÒÃǾͿÉÒÔÆô¶¯mysqlÊý¾Ý¿â£¬Èçͼ£º
ÏÔʾΪÉÏÊöͼ£¬±íʾ°²×°ÕýÈ·¡£
ΪÁËʹÊý¾Ý¿â¸ü¼Ó°²È«£¬ÎÒÃÇÀ´ÉèÖÃÊý¾Ý¿âÃÜÂë¡£
/usr/local/mysql/bin/mysqladmin -uroot password 123456
ÈçÔÚÏÂ´ÎÆô¶¯·þÎñÆ÷ʱÄÜ×Ô¶¯Æô¶¯mysqlÊý¾Ý¿â½ø³Ì£¬ÎÒÃÇ»¹ÐèдÈë/etc/rc.d/rc.localÎļþÀï
echo “/usr/local/mysql/bin/mysqld_safe --user=mysql &” >;>; /etc/rc.d/rc.local
¶þ¡¢ÅäÖÃMYSQLË«»úÈȱ¸
´«Í³Ä£Ê½¶¼ÊDzÉÓÃmysqlË«»ú»¥±¸£¬ÖÁÓÚË«»úÈȱ¸ÎÒËÑË÷ÁË´óÁ¿µÄ¾«»ªÌû×Ó¶¼Ã»Óз¢ÏÖ°²×°ÅäÖÃÎĵµ¡£¹ÊÎÒµÄÒ»¸öÏë·¨²úÉúÁË£ºµ±½¨Á¢ÐµÄÊý¾Ý¿âʱ£¬Ä¬ÈϻὨÁ¢µ½/usr/local/mysql/dataÕâÀï£
Ïà¹ØÎĵµ£º
½ñÌìµ÷³ÌÐò´ÓÊý¾Ý¿âÀïÈ¡Êý¾Ý£¬Ò»Ö±È¥²»³öÀ´£¬°ÑÈÕÖ¾Àï´ò³öÀ´µÄsql·Åµ½Êý¾Ý¿âÀïÈ¥Ö´ÐУ¬È´ÓÖÄÜ
È¡³öÊý¾ÝÀ´£¬ºÜÊÇÓôÃÆ¡£
Êý¾Ý¿âÊÇmysqlµÄ£¬Ò»¹²128¸ö¿â£¬Í¨¹ýij¸ö×ֶηֿ⡣
ºóÀ´·¢ÏÖÒª²éµÄÕâÌõÊý¾ÝµÄ·Ö¿â×ֶα»¸Ä¹ý£¬°´ÕÕ³ÌÐòÀïÖ´ÐеÄÈ¥²é£¬Ëû¾ÍÈ¥ÁËÁíÍâÒ»¸ö¿â ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
ͬÊÂÀëÖ°£¬ÓÖÒ»¸öÒ»¸öÀÃ̯×ÓÒªÊÕʰ¡£ÕâÀïÐÞÐÞ£¬ÄÇÀï²¹²¹¶¼Ã»Óо«Á¦À´Ð´µã¶«Î÷¡£
Ã÷Ìì»Ø¼Ò£¬ÉÏÎçÕûÀíºÃÎĵµ¡£ÏÂÎç¾ö¶¨³éµãʱ¼ä£¬°Ñ×î½üµÄ¶«Î÷¾¡Á¿ÀíÒ»Àí¡£ºÜ¶àÁé¸Ð¶¼ÒѾÒÅÍü¡£ÎÒÃÇ×ÜÔÚ²»¶ÏÃæ¶Ô£¬ËùÒÔÎÒÃDz»¶ÏÒÅÍü¡£¡¾syslog¡¢mysqlÓÅ»¯¡¢´¥·¢Æ÷¡¢´æ´¢ ......
Ô¶³ÌÁ¬½Ómysql×ÊÁÏ
Ô¶³ÌÁ¬½Óµ½mysqlÐèÒª×öµÄ£º
1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
²é¿´½á¹û£¬Ö´ÐУº
use mysql;
& ......
Äãд¹ýÒ»ÌõsqlÓï¾äÀ´ÐÞ¸ÄÁ½¸ö±íµÄÊý¾ÝÂð£¿
UPDATE test.table1 t1,test.table2 t2 SET t1.aa='a',t1.bb='b',t2.cc='c',WHERE t1.u_id=t2.u_id AND t1.u_id='1' £»
table1µÄu_idºÍtable2µÄu_idÊÇÖ÷Íâ¼ü¹ØÏµ ......