Lost MySQL root Password

Damn, I just wanted to access the MySQL database here at home but hmpf, do you think I remembered the root password when I installed it? No, but:

How to reset the lost root Password for MySQL:

  • /etc/init.d/mysql stop
  • /usr/bin/mysqld_safe –skip-grant-tables &
  • mysql -h localhost
  • use mysql;
  • update user set password=password(‚…….‘) where user=’root‘ and host=’localhost‘;
  • quit;
  • /etc/init.d/mysql start

Have fun ;-)

D-Link DWL900AP+

Today I looked at one of our 4 APs here at home. One of our two D-Link DWL900AP+ is not responding anymore. The LAN-Connection always goes and comes in a ~3 seconds rythm. First I resetted the device normal. No success. Then I hard resetted the device (push 15sec. the reset button, then power off, keep holding, after 15 seconds power on and still keep the button pushed for another 15 seconds). I was able now to access a firmware upgrade page. I tried uploading the last firmware but no success. The device seems to upload the firmware but starts its lan-coming and lan-going rythm again. I looked for an old firmware on the CD that was delivered with the AP, and I found the version 2.55. Via tftp I was able to transfer the firmware successfull (tftp -i 192.168.0.50 put 900ap_255rom.bin rom.img) and after a self-reboot the device was there. Great! I reconfigured it in order to work again as before as an Accesspoint in our house, tested everything, power off, walked on the floor, power in: ……. lan-coming, lan-going :-( Damn… Now I am trying since 2 houres to reenable this dead crap of electronic waste, no success… I think the flash-rom is corrupt somehow, and it is really bad, because it is the one AP that is responsible for the first floor in our house. Damn AP: please wake up, and I promise you I won’t take you any power until you burn yourself…… Did I ever mentioned that I /hate/ stuff like that??

Series…

I didn’t blog for a long time in english, but now I have to… First of all thanks to kero and einfachsilvia for the great dinner! But now to the headline…

Everybody who knows me, knows as well, that I am not a big series fan. Sometimes I watch from this or that an episode, but I don’t follow any regulary. Tonight kero pointed me to The IT-Crowd. It has simply six episodes yet, but I watched them all after another and was laughing so much… It is good to know the definition of Nerd in order to understand it, and if you get any chance to get the episodes somewhere on the net, give it a try!

@Roy, your phone answering will be on my answering machine in a second…