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ÕâÀï£
Ïà¹ØÎĵµ£º
£¨1£©ÔÚÉè¼ÆÊý¾Ý¿â×ֶεÄʱºò£¬°ÑÐèÒª»ñÈ¡ÊÖ»úºÅµÄ×Ö¶ÎÉèÖÃΪint(11)£¬ÔÒâÊÇҪȡ11λÊýµÄ£¬½á¹û·¢ÏÖËùÓеÄÊÖ»úºÅÂ룬¶¼±ä³ÉÁË2147483647
£¬¶Ùʱ¾õµÃºÜÆæ¹Ö£¬ÒÔΪÊdzÌÐòÓÐÎÊÌ⣬×îºó·¢¾õÊÇÊý¾Ý¿âÉè¼ÆµÄÎÊÌâ¡£ÒòΪÓзûºÅÕûÊýµÄ×î´óֵΪ
2147483647£¬ËùÒÔ×îºó¾ö¶¨°ÑÊý¾Ý¿âµÄ½á¹¹±ä»¯Ï£¬°Ñint(11)±äΪchar(11)²Å¸ã¶¨¡£
£¨2 ......
mysql Ã÷Ã÷ÒѾװºÃÁË£¬µ«ÊÇÎÞ·¨·ÃÎÊ¡£Á´½ÓµÄʱºò ×ÜÊÇ˵
Access Denied.
½â¾ö·½·¨£º
ÓÃmysqld --skip-grant-tableÆô¶¯mysql
È»ºóÔÚmysql¿âÖÐÖ´ÐÐÕâ¸ö
INSERT INTO user VALUES ('localhost', 'root', PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y', ......
MySQL Java ¿ª·¢Ì××°(·þÎñÆ÷,¹ÜÀí¹¤¾ß,JDBCÇý¶¯,ʾÀý´úÂë)
С¸üÐÂ: ΪÁ˼õÇḺµ£, Óà MySQL-Front 2.5 À´¹ÜÀí, Õâ¸öÈí¼þÎÞÖÐÎÄÎÊÌâ. Èç¹ûÒÔºó¿ªÔ´°æ±¾HeidiSQLµÄ½â¾öÁËÖÐÎÄÎÊÌâ, ¾ÍÓÿªÔ´µÄ.
ÏÂÔØ: http://tomcatmonitor.googlecode.com/files/portable_mysql5.exe 4.02MB (×Ô½âѹ°ü)
²Î¿¼Îĵµ: MySQL 5 ÂÌÉ« ......
MySql Error Nr. 1045
¹Ø¼ü×Ö: error 1045
ÎÊÌâÃèÊö£º
Ò»¸ö¿Í»§µÄ·þÎñÆ÷£¨windows£©ÉÏÒѾװÁËÒ»¸öphp+apache+mysql£¬ÏÖÔÚÐèÒªÔÚÕą̂·þÎñÆ÷ÉÏÔÙ×°Ò»¸ö֪ʶ¿âϵͳ£¬
Êý¾Ý¿âÒ²ÊÇʹÓõÄmysql£¬È»ºó°²×°Ò»¸öеÄmysql£¬Ê¹ÓÃÁËеĶ˿ںͷþÎñÃû£¬
°²×°×îºóÒ»²½Ìáʾ“Error Nr. 1045 ......”£¬½øÈëMySQL Comm ......
Ó¦ÓóÌÐòºÍÊý¾Ý¿â½¨Á¢Á¬½Ó£¬Èç¹û³¬¹ý8СʱӦÓóÌÐò²»È¥·ÃÎÊÊý¾Ý¿â£¬Êý¾Ý¿â¾Í¶ÏµôÁ¬½Ó ¡£ÕâʱÔٴηÃÎʾͻáÅ׳öÒì³££¬ÈçÏÂËùʾ£º
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav ......