To create a new database in MySQL and a new user with full rights to the newly created database you can follow these steps:

Open a terminal command prompt and login to mysql (enter the mysql root password when prompted):

This should get you into the mysql> prompt. All commands executed from now on will be for the mysql server that you just logged into. Please note that the semi-colon is important - it tells the mysql prompt that the end of the command has been reached and to execute the command.

I have an external drive connected to my router's USB port that I use a store center. And when I log into my linux (Xubuntu) box, I am able to open Thunar (the default file browser) and click the Browse Network location under the NETWORK column heading in the left navigation pane.

When developing web applications, clients usually would like some sort of SSL certificate verification image seal on their website. Some SSL certificate providers, like Norton Symantec, provide their customers with some JavaScript that retrieve the image seal based on some conditional logic.

One of my recent projects required the use of iframes. We had to place the content of service provider in an iframe on our website. The problem was however that the height of the iframe content would dynamically change depending on user interaction (like choosing a different product or rate plan). So since the iframe content was from a different domain from where it was being displayed, I needed to use the wonderful easyXDM library.

If you are like me and want to have WordPress perform updates from the admin section (and not provide FTP credentials) then you will probably want to know a few linux commands.

Listing is now on ComFree, please see: http://comfree.com/2-storey-for-sale-burlington-ontario-306910

Photos Added (see ComFree listing using above link)!

I often times come across a situation where I have a string in a certain date time format and wish to convert that string into a .NET DateTime object for further manipulation.  In one recent situation, a date was supplied in an XML node (without a specified data type) as a string, but the output of the date had to be in a specific format for my client. 

Example:  We need to convert <submit_date>2010-12-04 13:22:32</submit_date> and output it as December 4, 2010 at 1:22 PM 

This blog entry is going to be my collection of useful Linux commands that I wish to refer back to in the future. I hope you find them useful as well.

Apache 2, Restart, Stop, Start on Ubuntu Linux

Finding files

Find all files in the home folder (and its subfolders) with a 'txt' extension, sort the results, then output to a file:

I have seen many examples of JavaScript and jQuery pagination on the web, but none of them was what I wanted. I like to use small, compact code to perform simple actions such as paginating a list of items using JavaScript and jQuery. So I decided to write my own version. The JavaScript is about 100 lines of code (less if you removed the empty lines and comments) and works quite well for what I needed it for. So I would like to share my code with other coders and web developers.

I purchased a GXT 2-Ports NAS USB Dongle model number NAS-R104A from future shop about a week ago hoping to allow network printing to my USB printer with little configuration.  But, much to my surprise, I could not get the printer to print.