Site Backup… Lesson learned…
backup, backup, backup!!!...
Really important and even talked about it in my previous post... but never did act on it... until now... well... I am now using automatic backup plugin to back up my db and I feel lot better... ! Automatic backup does wonders for your mental health.
Took me 2 hours to bring it backup from its sorry state ... but lesson well learned... no I'll never go without backup !!!
Now if I can only do the same for all of my computers ... 
Problem Step Recorder
Running Windows 7 or 2008 server? Do you need to create quick instruction sheet for end user? Well you can with MS Problem Step Recorder. It's originally intended for recreating end user error / problem. But it does nice screen capture of each mouse click and keyboard actions into nice MHTM format. Want to post it online? No problem, just open file in Word and then use it's save as option to save as regular HTML file to upload to your web server... Not as originally intended but good job MS!
phpMyAdmin 1045 Access Denied error!
Having internet is like a double edged sword. On one hand, you have endless amount of information at your finger tip (literally), but asking the right question is the key of find that information your need in any given moment. Also, there's that problem of information overflow which is another issue all together, but I digress.
As a web admin / net admin / just a handy IT guy around the office, I do use phpMyAdmin quite often because its interface is much easier to navigate than terminal. Also, I'm a visual person and like to see large amount of data in nice tables. Today however, I was faced with an issue. I was not able to access it. Following was the error message that I've got.
1045 - Access denied for user 'root'@'localhost' (using password: NO)
To make sure I've tried to access it from the terminal using
mysql -u root
but the problem persisted. So on to the Google I went and searched online for the error message and apparently, this was a common instance that came up from time to time. After going through few of the top links, I've found following solution http://tekxplorer.blogspot.com/2010/05/phpmyadmin-mysql-error-1045-access.html which was easier than what other's have suggested and you know what? It works! thanks you internet and that guy who posted his experience
If you don't feel like following the link to the solution page, basically this is what you need to do...
- Add '/scripts/signon.php" at the end of your site URL, so that it will look like http://yourdomain.com/phpmyadmin/scripts/signon.php"
- From the sign on page, login using your root user id and password for mySQL
- Ta-da, you are back in!
After doing this once, problem with the access denied error seems to magically disappear. Well, one less worry for me and I'll know what to do next time 