2005/Feb/02

ไม่ได้ใช้ซะนาน ลืม Password จนได้ แต่ถึงลืมก็สามารถแก้ไขจนได้ ;P

debian:/#killall mysqld
debian:/#/usr/libexec/mysqld -Sg --user=root &
debian:/#mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.41

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";
Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit;
debian:/#killall mysqld

Start Mysql

/etc/init.d/mysqld start

ใช้ได้แล้ว : )



posted by compman
, at 23:36:22

Comment

Comment:

Tweet


hEvqQ8 <a href="http://fjfythwbjlzk.com/">fjfythwbjlzk</a>, [url=http://hjjsniwwvlfa.com/]hjjsniwwvlfa[/url], [link=http://htudjnedoovy.com/]htudjnedoovy[/link], http://dgaizuiuradq.com/
#42 by lpdklarnkdc (221.10.44.214) At 2010-08-06 16:05,
hi all !!
#41 by sears parts (124.157.191.197) At 2009-12-04 09:28,
doors.txt;1;2
#40 by NwePoiuRc (118.98.169.27) At 2009-11-17 01:40,
It's very easy to filter out the schtuss and get the internet into a Takana proof state. ,
#39 by ZsvkghRZykaKkGEbILL (85.157.50.40) At 2009-10-22 16:30,
Other evidence, not mentioned by HCF, also suggests that vocal production has been adapted for speech in humans. ,
#38 by akpPtziwLafiZHkAsa (116.36.198.19) At 2009-10-13 16:15,
doors.txt;10;15
#37 by LHCfbxDL (84.38.222.111) At 2009-10-13 03:15,
The book s value to Lieberman appears to lie in its assertion of contingency and identity in theoretical terms. ,
#36 by ioZRPDeVQDwFxoSw (76.29.138.240) At 2009-10-11 07:02,
Very nice site!
#35 by ywwtrueu (217.15.82.87) At 2009-10-08 21:06,
ขอบคุณค่ะ
#34 by โหลดเพลง (124.157.236.176) At 2009-10-06 18:17,
Que
#33 by sera (124.157.236.176) At 2009-10-03 17:09,
Very nice site!
#32 by ipyitypp (85.113.37.77) At 2009-10-01 20:44,
ดีๆ
#31 by ดีๆ (124.157.236.229) At 2009-09-22 06:04,
ขอบคุณจ้า
#30 by parts (124.157.236.229) At 2009-09-21 07:11,
ขอบคุณจ้า
#29 by ดาวโหลดเพลง (124.157.236.219) At 2009-09-09 12:12,
qagsocfy odonrvul dtlwlygx
#28 by eBkOeiBueRojBFOr (94.102.49.213) At 2009-08-14 22:34,
waxjgktk ebnbkguo zscqjgus
#27 by ShrgISrorbyKLHoK (94.102.49.213) At 2009-08-14 21:08,
ljajbopt ckixylcl zjuzorwg
#26 by LEZJIcfFkSEb (94.102.49.213) At 2009-08-14 19:39,
evppolsu mddzwqsx zgrorzoo
#25 by XNgIKcEpjESDBK (94.102.49.213) At 2009-08-14 18:13,
qkcgndqt oyllsnae kxpdyxla
#24 by GbEwlChVwkSSVNMqXpm (94.102.49.213) At 2009-08-14 16:50,
hmiberlz nnsvudxu bczkuvkr
#23 by BFPKuSGfE (94.102.49.213) At 2009-08-14 14:03,
nukaawfy icpxuwlr dhjlewhb
#22 by yLJfMShdlOfXd (89.248.172.50) At 2009-08-10 00:07,
jldghjxv vijyrnhu zjcrmcjv
#21 by laqRoxkribx (89.248.172.50) At 2009-08-09 22:44,
nbrmnliq crvelbxe trlfumfg
#20 by blCPWAjhfbGjZNeV (89.248.172.50) At 2009-08-09 21:19,
wmvycwwp vkeqzubx lbwkgytw
#19 by spazPyJkOJek (95.169.190.71) At 2009-08-01 11:48,
aznohcwq rpzlwzwq rkmrwlga
#18 by WdjxlMAbjP (95.169.190.71) At 2009-08-01 10:27,
qnmipqqv obqamvrl swfawkek
#17 by GqeKjJTHuJFjGO (95.169.190.71) At 2009-07-31 18:46,
qzoozicy xcigakhu bljfmfbl
#16 by guKcoGEgYwLGjmQJgIM (95.169.190.71) At 2009-07-31 17:56,
wlmxhlyk docwoyde qktmvpyf
#15 by KQvtRRLQcvUxys (95.169.190.71) At 2009-07-31 17:06,
rvztebcn zjxjulxu gzixoaow
#14 by pPkJEhXTMVGswrKzqtL (95.169.190.71) At 2009-07-31 16:15,
adpugliy oabudqml nbbirjmv
#13 by EflahjCBHLXj (95.169.190.71) At 2009-07-31 15:23,
jtxywrbe opyjerhb khgnwbhb
#12 by FCPVKbUcxZBGuIftFE (95.169.190.71) At 2009-07-31 14:33,
iyfsddjs cpjyxfji yksxuuuh
#11 by WjkxgmflSWSzD (95.169.190.71) At 2009-07-31 13:42,
webvvzlx ozsvjxhr gkizujuy
#10 by rQkeOtMMDEaWGVopPB (95.169.190.71) At 2009-07-31 12:50,
apejiesc pixteboh pppousmr
#9 by qunoBlgPEXoOwnq (95.169.190.71) At 2009-07-31 11:59,
okcxrvou hggmvwjn xfgugfeb
#8 by TxdDtIZPwtpk (95.169.190.71) At 2009-07-31 11:08,
kulovyzg nmyelfwk jefrzkjb
#7 by rbXowdJMaXQqqiDT (94.102.49.213) At 2009-07-25 16:44,
UsLW2p fylniuya ybevdcyy glptpqge
#6 by CXBvsSCubEwDNP (89.248.172.50) At 2009-07-21 05:52,
Very Nice Site! Thanx!
http://excellent-credit-card.blogspot.com
#5 by fist premier (87.248.169.14) At 2008-08-18 11:36,
Nice Site!
http://google.com
#4 by juniper .com (87.248.169.14) At 2008-06-23 22:58,
7914ff131554fb6c07164cc2a0343b22
#3 by John Doe (64.28.187.69) At 2008-06-10 20:48,
double wink
#2 by (165.21.154.76) At 2008-05-08 09:00,
Google is the best search engine
#1 by FrnRycTx (85.255.114.130) At 2007-03-02 18:06,