Alvin Poh’s Blog

How To Login To Apple Genius When Your Password Is Rejected

I was trying out Apple’s iTunes Genius today, but then kept getting an error message saying that my Apple login credentials (username or password) was invalid. I was 100% sure that my username and password were correct, and even went to Apple.com to login again to make sure. It was annoying, but I finally found a [...]

Continue reading...

How To Reset The MySQL Root User Password and Privileges

Problem: I was developing using PHPMyAdmin when I added a new root user (with a host value of %), and removed the rights of the default root user. When you do that, you’ll get a gut-wrenching feel that you just made a huge boo-boo, find that suddenly everything will not work, and kick yourself in the [...]

Continue reading...

How To Lock Your Mac Like in Windows

It was in class when I realised that I need to lock my Mac when I had to go to the bathroom, but couldn’t because I didn’t know how to. I didn’t mean a physical lock, but locking my system from other people. Windows has a function that you could just hit Windows Key + [...]

Continue reading...

How To Enable Macros With A Password-Protected Workbook in Microsoft Excel 2007

Well, guess what, you can’t. Microsoft Office 2007. A brand new way to create frustration in your life. I was trying to create a macro in Microsoft Excel 2007 and nearly tore out my hair. The thing with macros in Excel 2003 was that it was relatively easy to accomplish, but it’s a whole different ballgame [...]

Continue reading...

Password Protect Sensitive Applications (SMS, Mail) on the iPhone

I have the iPhone, and I’d like to have the functionality to password protect certain applications on it, such as SMS/Text and Mail. It’s just something about me, because sometimes people borrow my phone, and I don’t feel comfortable having my personal information seen and read. Well if you have a jailbroken phone with the Cydia [...]

Continue reading...