How To Create A WordPress Admin Login Using MySQL

You can do this simply by running the following SQL commands through phpMyadmin or through command line MySQL. 1. First insert the new user account into the database. If you’re using command line MySQL then you will need to select the database first using the “use” command below: use wp_mywordpressdatabasename Now that you’ve selected the … Read more

Get RackTables working with php-cgi or fastcgi

If you’ve tried to google “racktables authentication not working after install” you won’t find much, but there is a couple of articles about fastcgi and the PHP_AUTH_PW and PHP_AUTH_USER not being passed correctly. But no real solution to the problem. I was able to get RackTables working using the following work around posted on http://www.rosmir.org/Index/Docs/archive/LabsFolder/FastCGI which … Read more

Upgrading Memory on a Macbook Pro OSX with the GeIL 16GB Memory Kit (GS316GB1333C9DC)

I recently purchased the “GeIL 16GB (2 x 8G) 204-Pin DDR3 SO-DIMM DDR3 1333 (PC3 10660) Laptop Memory (GS316GB1333C9DC)” from NewEgg on boxing day in hopes that it would work in my Macbook Pro (Early 2011 15″ – MC721LL/A – MacBookPro8,2 – A1286 – 2353-1*) And to my surprise after installing the memory my Macbook … Read more

Changing the Thumbnail on a YouTube Video to a Custom Image

The following code will allow you to use a custom image for the thumbnail on a YouTube video. <div style=”float: right; padding: 20px;”><img style=”cursor: pointer;” src=”/wp-content/uploads/2012/10/iframeyoutubevideo.png” alt=”” /></div> <div id=”thevideo” style=”display: none; float: right; padding: 20px;”><object width=”460″ height=”259″ classid=”clsid:d27cdb6e-ae6d-11cf-96b8-444553540000″ codebase=”http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0″><param name=”allowFullScreen” value=”true” /><param name=”allowscriptaccess” value=”always” /><param name=”src” value=”http://www.youtube.com/v/tX4l7aPoYLU?version=3&amp;hl=en_US&amp;rel=0&amp;autoplay=1&amp;autohide=1″ /><param name=”allowfullscreen” value=”true” /><embed width=”460″ height=”259″ type=”application/x-shockwave-flash” … Read more

WordPress SEO plugin by Yoast

I recently installed the plugin Wordpres SEO by Yoast on my this blog, and others. It was recommended by one of those top 10-20-50 WordPress Plugin posts you find all over the place. You can read more about Yoast and their plugin on their website http://yoast.com/articles/wordpress-seo/ One of the features that comes in handy quite often … Read more

Cheat Sheet for Administrating a PostgreSQL Database/Server

PostgreSQL Interactive Terminal   Postgresql is similar to MySQL in that it uses an interactive terminal. To gain access type the following as root su – postgres -c psql You’re now logged into the Postgresql interactive terminal and interacting with the local server. Common Shell Commands   Dump a database. When dumping and restoring a … Read more

MikroTik – DynDNS Update Script

This is a script for ensuring that your DynDNS hostname is updated when your IP changes on your MikroTik router. Unfortunately the script from the MikroTik Wiki doesn’t work and is broken. http://wiki.mikrotik.com/wiki/Dynamic_DNS_Update_Script_for_dynDNS There is a question mark within the URL that posts the update to members.dyndns.org and it gets removed when you paste and … Read more