Granting Database Privileges in MySQL via SSH
Written on 03/26 • 1 CommentsThis week I experienced some problems installing Magento the Open Source shopping cart system onto a dedicated server hosted by Wedfusion. The installation seemed to go well until just after the database was populated by the installer script. All the tables were created as expected but Magento produced a rather unhelpful general error. After some investigation it turned out that the issue was occurring because by default a database created in the server control panel do not assign the CREATE TEMPORARY TABLES privilege to the database user. To fix the issue all I needed to do was add the privilege to the user and the installer then works flawlessly. Below are some simple instruction on granting privileges in MySQL via SSH.
Step 1: Connecting to your server via SSH.
See my previous article regarding login on to a remote server using SSH in OS X Terminal application here.
Continue ReadingChecklist of Things to Remember when Launching a Website
Written on 01/22 • 0 Comments
There are a few of these lists around on the internet giving people advice on what they should check before they launch a website but most contain things that should be thought about from the very start. If you have forgotten about browser testing, screen resolutions & progressive enhancement until you are ready to launch you should take a look at how you are going about the whole build process.
Continue ReadingUsing Googles Chart API to Create Charts for your Web Apps
Written on 12/04 • 0 Comments
The Google Charts API allows you to send data to Google and have it returned as a graph or chart. All the hard work is done for you by Google and its servers and you simply reference an image in your HTML. You pass Google the raw data — the numbers for the charts, axis labels, and so on — as part of the image’s URL. If you want to add charts to your site or web based applications to show dynamic data the Google API is a quick, easy and attractive choice.
Continue ReadingHow to Prevent or Allow Directory Listing
Written on 11/13 • 0 Comments
Having a list of files in a directory on your site sometimes is useful. You may for example want a directory you can upload large files to for others to download without wanting to spend time creating a fancy PHP (or your preferred language) interface. It is important to understand the security implications of allowing directory listings. Listing files in directories that contain your code will make it easier for someone to compromise your site. We recommended you restrict listings to specific folders. You can easily control this behavior on your Apache server using one simple line in a .htaccess file.
Continue ReadingHow to convert your site into a Joomla 1.5 Template
Written on 09/18 • 0 Comments
This tutorial will show you how to create a simple Joomla 1.5 template. The tutorial assumes you have already created a XHTML layout for your site along with the CSS and images and that you now want to use your design with Joomla. Joomla is one of the best known Content Management Systems (CMS) around but creating a template for Joomla can be a confusing process, hopefully this insight will make it a bit easier.
Continue Reading20 Handy Apple OSX Keyboard Shortcuts
Written on 07/03 • 0 Comments
Keyboard shortcuts can be a real timesaver, if you get to know a few for common tasks you can cut hours off your working week. The keyboard shortcuts are not application specific and should work in virtually any program running on OSX.
Continue ReadingMore articles can be found in the archives, feel free to have a look around and leave your comments.
Try a sample pack of 10 Business Cards for free from MOO
Upload images for the first side of your card. Choose up to 10 different images or designs. We accept high resolution JPEG, PNG, GIF or PDF files. Free standard shipping is included.
Mint