How To Create a New Database with a New User in MySQL
Rob — February 1, 2014 - 12:04
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):
mysql -u root -p
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.
How To Mount A Network Share In Linux
Rob — October 13, 2013 - 14:04
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.
Standalone Norton Seal And JavaScript to open Verification Window for Testing
Rob — October 28, 2012 - 11:29
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.
How To Set Iframe Container Height From Remote Domain using easyXDM
Rob — May 25, 2012 - 11:19
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.
WordPress updates without providing FTP credentials
Rob — May 16, 2012 - 23:32
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.
2453 Sutton Drive Burlington Ontario Freehold Town Home For Sale
Rob — January 24, 2012 - 14:47
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)!
Convert string to DateTime or output DateTime to string using .NET
Rob — December 1, 2010 - 20:14
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
Useful Linux Commands
Rob — November 28, 2010 - 22:37
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
sudo /etc/init.d/apache2 restart
sudo /etc/init.d/apache2 stop
sudo /etc/init.d/apache2 restart
Finding files
Find all files in the home folder (and its subfolders) with a 'txt' extension, sort the results, then output to a file:
find /home -name '*.txt' | sort >> text-files.txt
JavaScript Pagination with jQuery
Rob — November 27, 2010 - 16:06
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.
Configuring the GXT NAS 2 Port USB Dongle Print Server on Windows 7
Rob — November 26, 2010 - 23:59
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.
