Just upgraded, ok ok, not really upgrade but add a new feature to the top commentator plugin for wordpress. Not a newly created plugin, previously i add a gravatar support to the top commentator plugin, and it has been a while thinking to add another option the plugin, cloud. The idea has been in ‘just an idea’ state until about an hour ago where I finally code it. Maybe the air at the Universiti Cikgu Cikgu stimulate me or just because I was boring with the documents and got nothing else to do. It displays just like tags or categories cloud. Cloud exposes the higher commentator more than ever before, differentiated by the size and the color of the font. Now the plugin support:

1. Normal list
2. With Gravatar
3. Cloud

For cloud, the new options you have are:

You are welcome to read the rest of this entry »

Share This

I never knew there was engadget store in Malaysia, now it’s too late, the shop closed down, so sad. Engadget and Gizmodo are the two gadget sites that i frequent besides akihabara, local lowyat.net and others. Never really thought a small computer shop in Midvalley will feat in Engadget. And there’s a little joke about “Pusat Komputer” term he2x.

1: engadget:1 fake-engadget-store:0

2: a visit to the engadget store

3. This is a boring attempt to update hahaha

4. Awek Campbell ? No no, not here

Share This

ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: YES)

It’s is not surprising recovering lost password in open source product is relatively easy, after all they are open. Linux is very stable and secure, so stable that once your installation complete and has been configured and secured, you can just ignore its existence, it will work just fine. This, expose most administrator to one major problem, lost passwords. Today, for some reason, I logged in to one of our client email server we setup two years back. Uptime 147 days, last login december last year. Luckily I still remember the OS password. Tried to login to mysql, failed. Tried again with all possible passwords, still no luck. Tried, history | grep mysql, yay!, there is mysql -u -p in history, try that and still failed. Being the only person that have root access to the server, Nobody else will know the password and it is not in use anyway, I decided to change it and share the steps with whoever need it.

So how to recover your root password? It’s actually not recover the password, the correct term will be recovering root privileges as what we are going to do is change the root password without having to know the original password. Follow the following steps to do so:

1. service mysqld stop
2. safe_mysqld ––skip-grant-tables & or mysqld_safe ––skip-grant-tables &
3. mysql -uroot mysql
   1. Type the following command in mysql:-
   2. UPDATE user SET password=PASSWORD(”abcd”) WHERE user=”root”;
   3. FLUSH PRIVILEGES;
   4. quit
4. service mysqld restart

Now you can gain your root privileges by using the new password you just set. Collect enough mana and summon the following command:

mysql -uroot -pabcd

If you cannot gain access, then your mana if not enough. Try again, or just set ––skip-grant-tables to completely ignore the security option, which of course is not safe and not recommended.

And a little tip for you: lost root password for linux OS, google for ‘linux single’.

You are welcome to read the rest of this entry »

Share This