Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql access deined

ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
ÏÖÔÚÖÕÓÚ±»ÎÒÕÒµ½Á˽â¾ö·½·¨£¬ÈçÏ£¨ÇëÏȲâÊÔ·½·¨Èý£¬Ð»Ð»£¡£©£º
·½·¨Ò»£º
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
·½·¨¶þ£º
Ö±½ÓʹÓÃ/etc/mysql/debian.cnfÎļþÖÐ[client]½ÚÌṩµÄÓû§ÃûºÍÃÜÂë:
# mysql -udebian-sys-maint -p
Enter password: <ÊäÈë[client]½ÚµÄÃÜÂë>
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
·½·¨Èý£º
ÕâÖÖ·½·¨ÎÒûÓнøÐйý²âÊÔ£¬ÒòΪÎÒµÄrootÓû§Ä¬ÈÏÃÜÂëÒѾ­±»ÎÒÐ޸ĹýÁË£¬ÄÇλÓпղâÊÔһϣ¬°Ñ½á¹û¸æËßÎÒ£¬Ð»Ð»£¡£¡
# mysql -uroot -p
Enter password: <ÊäÈë/etc/mysql/debian.cnfÎļþÖÐ[client]½ÚÌṩµÄÃÜÂë>
ÖÁ´Ë£¬À§»ó¶àʱµÄÎÊÌâ½â¾öÁË£¡


Ïà¹ØÎĵµ£º

MySQLн¨Óû§,ÊÚȨ,ɾ³ýÓû§,ÐÞ¸ÄÃÜÂë²Ù×÷

Ê×ÏÈÒªÉùÃ÷һϣºÒ»°ãÇé¿öÏ£¬ÐÞ¸ÄMySQLÃÜÂ룬ÊÚȨ£¬ÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ġ£
×¢£º±¾²Ù×÷ÊÇÔÚWINÃüÁîÌáʾ·ûÏ£¬phpMyAdminͬÑùÊÊÓá£
    Óû§£ºphplamp  Óû§Êý¾Ý¿â£ºphplampDB
1.н¨Óû§¡£
//怬MYSQL
@>mysql -u root -p
@>ÃÜÂë
//´´½¨Óû§
mysql> insert into mysql.user ......

MySQLÖÐÊý¾Ý½á¹û¼¯·ÖÒ³¹¦ÄܵÄʵÏÖ·½·¨

---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ­´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷ԭʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º  MySQL ·ÖÒ³  limit
----------------------- ......

±¸·ÝºÍ»¹Ô­SQL Server¼°Ñ¹ËõAccessÊý¾Ý¿â

*
 * ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
 * ×÷Õß: Áõ¹¦Ñ«;
 * °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
 * µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
 * µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
 *          ÒýÓÃC:/Progra ......

apache tomcat mysql ¸ºÔØƽºâºÍ¼¯Èº¼¼Êõ

¹«Ë¾¿ª·¢ÁËÒ»¸öÍøÕ¾£¬¹À¼Æ×î¸ßÔÚÏßÈËÊýÊÇ3 Íò£¬²¢·¢ÈËÊý×î¶à100 ÈË¡£¿ª·¢µÄÍøÕ¾ÊÇ·ñÄÜ·ñ³ÐÊÜÕâ¸öѹÁ¦£¬ÈçºÎÈ·±£ÍøÕ¾µÄ¸ººÉûÓÐÎÊÌ⣬¾­¹ýÑо¿¾ö¶¨ÈçÏ£º
£¨1 £©²ÉÓøºÔØƽºâºÍ¼¯Èº¼¼Êõ£¬³õ²½»ú¹¹²ÉÓÃApache Tomcat µÄ»úȺ¼¼Êõ¡£
£¨2 £©²ÉÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²âÊÔѹÁ¦¡£¹¤¾ßÊÇLoadrunner.
Ó²¼þ»·¾³´î½¨£º
ΪÁËÄܹ»½øÐÐѹÁ¦² ......

mysqlº¯Êý

now()º¯ÊýÒÔ`yyyy-mm-dd hh:mm:ss·µ»Øµ±Ç°µÄÈÕÆÚʱ¼ä£¬¿ÉÒÔÖ±½Ó´æµ½datetime×Ö¶ÎÖС£
curdate()ÒÔ’yyyy-mm-dd’µÄ¸ñʽ·µ»Ø½ñÌìµÄÈÕÆÚ£¬¿ÉÒÔÖ±½Ó´æµ½date×Ö¶ÎÖС£
curtime()ÒÔ’hh:mm:ss’µÄ¸ñʽ·µ»Øµ±Ç°µÄʱ¼ä£¬¿ÉÒÔÖ±½Ó´æµ½time×Ö¶ÎÖС£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ