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
ชื่อ: 
เว็บไซต์: 
คอมเมนต์:




smilebig smileopen-mounthed smileconfused smilesad smileangry smiletonguequestionembarrassedsurprised smilewinkdouble winkcry
Google is the best search engine
#1  by  FrnRycTx (85.255.114.130) At 2007-03-02 18:06, 
double wink
#2  by   (165.21.154.76) At 2008-05-08 09:00, 
7914ff131554fb6c07164cc2a0343b22
#3  by  John Doe (64.28.187.69) At 2008-06-10 20:48, 
Nice Site!
http://google.com
#4  by  juniper .com (87.248.169.14) At 2008-06-23 22:58, 
Very Nice Site! Thanx!
http://excellent-credit-card.blogspot.com
#5  by  fist premier (87.248.169.14) At 2008-08-18 11:36, 
UsLW2p fylniuya ybevdcyy glptpqge
#6  by  CXBvsSCubEwDNP (89.248.172.50) At 2009-07-21 05:52, 
kulovyzg nmyelfwk jefrzkjb
#7  by  rbXowdJMaXQqqiDT (94.102.49.213) At 2009-07-25 16:44, 
okcxrvou hggmvwjn xfgugfeb
#8  by  TxdDtIZPwtpk (95.169.190.71) At 2009-07-31 11:08, 
apejiesc pixteboh pppousmr
#9  by  qunoBlgPEXoOwnq (95.169.190.71) At 2009-07-31 11:59, 
webvvzlx ozsvjxhr gkizujuy
#10  by  rQkeOtMMDEaWGVopPB (95.169.190.71) At 2009-07-31 12:50, 
iyfsddjs cpjyxfji yksxuuuh
#11  by  WjkxgmflSWSzD (95.169.190.71) At 2009-07-31 13:42, 
jtxywrbe opyjerhb khgnwbhb
#12  by  FCPVKbUcxZBGuIftFE (95.169.190.71) At 2009-07-31 14:33, 
adpugliy oabudqml nbbirjmv
#13  by  EflahjCBHLXj (95.169.190.71) At 2009-07-31 15:23, 
rvztebcn zjxjulxu gzixoaow
#14  by  pPkJEhXTMVGswrKzqtL (95.169.190.71) At 2009-07-31 16:15, 
wlmxhlyk docwoyde qktmvpyf
#15  by  KQvtRRLQcvUxys (95.169.190.71) At 2009-07-31 17:06, 
qzoozicy xcigakhu bljfmfbl
#16  by  guKcoGEgYwLGjmQJgIM (95.169.190.71) At 2009-07-31 17:56, 
qnmipqqv obqamvrl swfawkek
#17  by  GqeKjJTHuJFjGO (95.169.190.71) At 2009-07-31 18:46, 
aznohcwq rpzlwzwq rkmrwlga
#18  by  WdjxlMAbjP (95.169.190.71) At 2009-08-01 10:27, 
wmvycwwp vkeqzubx lbwkgytw
#19  by  spazPyJkOJek (95.169.190.71) At 2009-08-01 11:48, 
nbrmnliq crvelbxe trlfumfg
#20  by  blCPWAjhfbGjZNeV (89.248.172.50) At 2009-08-09 21:19, 
jldghjxv vijyrnhu zjcrmcjv
#21  by  laqRoxkribx (89.248.172.50) At 2009-08-09 22:44, 
nukaawfy icpxuwlr dhjlewhb
#22  by  yLJfMShdlOfXd (89.248.172.50) At 2009-08-10 00:07, 
hmiberlz nnsvudxu bczkuvkr
#23  by  BFPKuSGfE (94.102.49.213) At 2009-08-14 14:03, 
qkcgndqt oyllsnae kxpdyxla
#24  by  GbEwlChVwkSSVNMqXpm (94.102.49.213) At 2009-08-14 16:50, 
evppolsu mddzwqsx zgrorzoo
#25  by  XNgIKcEpjESDBK (94.102.49.213) At 2009-08-14 18:13, 
ljajbopt ckixylcl zjuzorwg
#26  by  LEZJIcfFkSEb (94.102.49.213) At 2009-08-14 19:39, 
waxjgktk ebnbkguo zscqjgus
#27  by  ShrgISrorbyKLHoK (94.102.49.213) At 2009-08-14 21:08, 
qagsocfy odonrvul dtlwlygx
#28  by  eBkOeiBueRojBFOr (94.102.49.213) At 2009-08-14 22:34, 
ขอบคุณจ้า
#29  by  ดาวโหลดเพลง (124.157.236.219) At 2009-09-09 12:12, 
ขอบคุณจ้า
#30  by  parts (124.157.236.229) At 2009-09-21 07:11, 
ดีๆ
#31  by  ดีๆ (124.157.236.229) At 2009-09-22 06:04, 
Very nice site!
#32  by  ipyitypp (85.113.37.77) At 2009-10-01 20:44, 
Que
#33  by  sera (124.157.236.176) At 2009-10-03 17:09, 
ขอบคุณค่ะ
#34  by  โหลดเพลง (124.157.236.176) At 2009-10-06 18:17, 
Very nice site!
#35  by  ywwtrueu (217.15.82.87) At 2009-10-08 21:06, 
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, 
doors.txt;10;15
#37  by  LHCfbxDL (84.38.222.111) At 2009-10-13 03:15, 
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, 
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, 
doors.txt;1;2
#40  by  NwePoiuRc (118.98.169.27) At 2009-11-17 01:40, 

<< Home