MySQL in 5 minutes (Linux)

Want to learn SQL, but you don’t have time to study tons of books or browsing endlessly the Internet?
Then here we go with MySQL in 5 minutes crash course. After five minutes you’ll be able to create databases and tables, list and drop them. You’ll be able to fill and to query them. At the end of the course you’ll do a backup of your database, drop it, and restore it again. Of course most of the capabilities of MySQL won’t be mentioned, but If you find out, what you want to focus on, you can go deeper into details, e.g. at MySQL’s web-site. Check our their documentation there.
Let’s go, the clock’s ticking. (I assume you’re on Linux, I’m on Ubuntu 8.10 Intrepid Ibex) Continue reading “MySQL in 5 minutes (Linux)”

Hacked after installing WP Security Scan plugin

If your WordPress installation is owned and defaced and you’re in a hurry, jump right to the Solution the top of the next page. But watch out, it could be a different problem.

I’m new to WordPress and was asking myself what I can do to secure my Blog. I’ve tried the WP Security Scan plugin, since I’ve stumbled upon it a few times.
I didn’t read the instructions thoroughly and so it came my wp-config.php file wasn’t writable. After the run of the WP – Database Security feature my Blog looked like a fresh install.
I’ve started to read the comments at site of the plugin, but it took me a while to find out what to do.
So a few kids took their chance to defaced my site. Why kids? – Simple: Continue reading “Hacked after installing WP Security Scan plugin”