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ÕâÀï£
Ïà¹ØÎĵµ£º
MySql Error Nr. 1045
¹Ø¼ü×Ö: error 1045
ÎÊÌâÃèÊö£º
Ò»¸ö¿Í»§µÄ·þÎñÆ÷£¨windows£©ÉÏÒѾװÁËÒ»¸öphp+apache+mysql£¬ÏÖÔÚÐèÒªÔÚÕą̂·þÎñÆ÷ÉÏÔÙ×°Ò»¸ö֪ʶ¿âϵͳ£¬
Êý¾Ý¿âÒ²ÊÇʹÓõÄmysql£¬È»ºó°²×°Ò»¸öеÄmysql£¬Ê¹ÓÃÁËеĶ˿ںͷþÎñÃû£¬
°²×°×îºóÒ»²½Ìáʾ“Error Nr. 1045 ......”£¬½øÈëMySQL Comm ......
Äãд¹ýÒ»Ìõ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ÊÇÖ÷Íâ¼ü¹Øϵ ......
http://www.chinalinuxpub.com/read.php?wid=45
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëÄ¿ ......