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ÕâÀï£
Ïà¹ØÎĵµ£º
15.2.6.5. InnoDBºÍMySQL¸´ÖÆ
MySQL¸´ÖƾÍÏñ¶ÔMyISAM±íÒ»Ñù£¬Ò²¶ÔInnoDB±íÆð×÷Óá£ÒÔijÖÖ·½Ê½Ê¹Óø´ÖÆÒ²ÊÇ¿ÉÄܵģ¬ÔÚÕâÖÖ·½Ê½ÖдӷþÎñÆ÷ÉϱíµÄÀàÐͲ»Í¬ÓÚÖ÷·þÎñÆ÷ÉÏÔʼ±íµÄÀàÐÍ¡£ÀýÈ磬Äã¿ÉÒÔ¸´ÖÆÐ޸ĵ½Ö÷·þÎñÆ÷ÉÏÒ»¸öInnoDB±í£¬µ½´Ó·þÎñÆ÷ÉÏÒ»¸öMyISAM±íÀï¡£
ҪΪһ¸öÖ÷·þÎñÆ÷½¨Á¢Ò»¸öзþÎñÆ÷£¬Äã²»µÃ²»¸´ÖÆIn ......
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 ÂÌÉ« ......
DOS¡¡´°¿Ú
¿ªÊ¼££¾ÔËÐУ£¾¡¡cmd
µ¼³öΪ£º¡¡mysqldump -u Óû§Ãû -p --opt Êý¾Ý¿âÓû§Ãû >
Êý¾Ý¿âÃû.sql
ÊäÈëÄãµÄÊý¾Ý¿âÃÜÂë!phpma.com
µ¼ÈëΪ£ºmysql -u Óû§Ãû -p Êý¾Ý¿âÓû§Ãû < Êý¾Ý¿âÃû.sql
£¨Òª
ÔÚµ±Ç°Ä¿Â¼Ï²Ù×÷£©
ÒªÏ뽫Îı¾Îļþ
“
pet.txt
”
×°Ôص½
pet
±íÖУ¬Ê¹Ó ......
http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......