linuxÖÐmysqlµÄÎÊÌâ
MYSQLÊý¾Ý¿â°²×°Ê±£¬ROOTµÄ³õʼÃÜÂëΪ¿Õ£¬ÎÒÉèÖÃÁËROOTµÄÃÜÂëºó£»Á¬½ÓMYSQL¾Í³öÏÖÁË´íÎó£¨ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)£©£¬µÇ½²»ÁË£¬ÎÒÔÚÍøÉϲ鵽½â¾ö·½·¨£¬ÐèÒª·ÖÅäÒ»ÏÂȨÏÞ£¬Ê¹ÓÃÒÔÏÂÓï¾ä:grant all on mysql.* to 'root'@'localhost' identified by 'password'; ÎÊÌâÊÇÎÒÏÖÔÚû°ì·¨µÇ¼µ½mysqlÃüÁîÐÐģʽ£¬ÒªÔõôÔËÐиÃÓï¾ä°¡
²»Ó÷¢2´Î°¡
µÇ¼mysqlµÄrootÓû§ÃÜÂë¸ÄÁË ²»ÐèÒªgrant all on mysql.* to 'root'@'localhost' identified by 'password';ÕâÑù°É
ÄãÁ¬½ÓÊäÈëµÄmysqlÃüÁîÊÇʲô
ÖÕ¶ËÏ£º
mysql -uroot -ppassowrd
OOTµÄ³õʼÃÜÂëΪ¿Õ£¬ÎÒÉèÖÃÁËROOTµÄÃÜÂëºó£»
ÄãÊÇÔõôÉèÖÃÃÜÂëµÄ£¿Í¼ÐνçÃæ£¿ÃüÁ
Ò»°ãµÄ¹ý³ÌÊÇ
yum install mysql-server mysql
service mysqld start
mysqladmin -uroot password "password"
mysql -uroot -p
ÊäÈë¸Õ²ÅµÄÃÜÂë
Èç¹ûÒª¿ª»úÆô¶¯µÄ»°ÐèÒªchkconfig mysqld on
µÇ¼µÄÃüÁîΪ£ºmysql -uroot -p£¬È»ºóÌáʾÄãÊäÈëÃÜÂë¡£
µÚÒ»´ÎÌý˵rootÒ²ÓÐÏÞÖÆ¡¡
mysqlÃüÁîÐÐģʽ ¶¼½ø²»ÁË ÔõôÇÃÃüÁ£¿£¿£¿
1.Äã²»ÊäÈëÃÜÂëÊÔÊÔ¡£
2.»»±ðµÄ»úÆ÷µÇ¼ÊÔÊÔ¡£
ÒòΪmysqlµÄÃÜÂëÊÇÕë¶ÔÌØ¶¨µÄÖ÷»úºÍÓû§µÄ£¬¾ÍÊÇ˵root@localhostºÍroot@192.168.0.1¿ÉÄܲ»ÊÇͬһ¸öÃÜÂë¡£
ËùÒÔ»»Ì¨»úÆ÷Á¬½ÓÐËÐí¿ÉÒÔÁ¬ÉÏ¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
×ÉѯQQ£º269562808
bzip2recover
¹¦ÄÜ˵Ã÷£ºÓÃÀ´ÐÞ¸´Ë𻵵Ä.bz2Îļþ¡£
Óï·¨£ºbzip2recover[.bz2ѹËõÎļþ]
²¹³ä˵Ã÷£ºbzip2ÊÇÒÔÇø¿éµÄ·½Ê½À´Ñ¹ËõÎļþ£¬Ã¿¸öÇø¿éÊÓΪ¶ÀÁ¢µÄµ¥Î»¡£Òò´Ë£¬µ±Ä³Ò»Çø
¿éËð»µÊ±£¬±ã¿ÉÀû ......
ÈçÌ⣬ÔÚWINDOWSµ×ϵÄCODE»á£¬µ«ÔÚLINUXϲ»ÖªµÀÈçºÎʵÏÖ£¬JSµÄ´úÂëÓ¦¸ÃÊDz»Ò»ÑùµÄ¡£ Çó½Ì¡£
·Ö²»¹»ÔÙ¼Ó¡£
http://topic.csdn.net/u/20100113/08/17ba1e71-4c33-43f6-91a5-0e031c86e5ed.html
linux ......