Grant a MySQL user access to a database
If you have a existing MySQL user account that you want to grant permissions to for a specific database, this howto will outline the steps required.
January 1, 2013
-
-
Create a new user in MySQL
This howto outlines the steps to add a new user to MySQL, and grant the new user permissions on a specific database.
January 1, 2013 -
Adding users to a .htpasswd file for Nginx
This howto article shows you how to add a new user and password combination to a .htaccess file, for use with Nginx or another web server. While these commands below work great with Nginx, they aren’t limited to just being used with Nginx. It will work with Apache too, however the htpasswd tool that comes …
December 20, 2012 -
VMWare vSphere client command line parameters
The VMWare ESXi / vSphere Infrastructure client allows for command line parameters to auto connect to a VMWare ESXi / vSphere server. The following command line options are available: Parameter Description -i Ignore untrusted certificate -s <server address> Server address of the ESXi / vSphere host. -u <username> Username to connect with. -p <password> Password …
December 10, 2012 -
Update time from network time server on Linux
To update the time on a Linux installation, simply run the following command: $ sudo ntpdate <time server address> Replacing <time server address> with a valid NTP time server address. eg: $ sudo ntpdate pool.ntp.org If you only want to query the time, without updating your system, use the following command: $ ntpdate -q pool.ntp.org …
December 10, 2012 -
Install VMWare ESXi / vSphere on a Adaptec 3405 RAID card
I recently set out to build a VMWare ESXi / vSphere white box. A white box in this case, is a custom built PC, that may not have all parts on the VMWare supported hardware list. Generally, ESX will work on most hardware, but the two common issues preventing things from working, are network adapters, …
December 9, 2012 -
Connect to a PPTP VPN Server from Ubuntu Linux
This howto outlines how to connect to a PPTP VPN server from a Linux computer running Ubuntu (or a Ubuntu based distribution). It covers the installing of the PPTP VPN client, configuration, and connecting/disconnecting from the VPN connection.
December 2, 2012 -
Enable and Disable Triggers in Microsoft SQL Server
The Microsoft SQL database server supports the use of Triggers on its tables. Triggers are a special kind of stored procedure that can be executed when records in a table are either inserted, updated, or deleted.
November 30, 2012 -
Enable and Disable Triggers in Firebird
The Firebird database engine supports the use of Triggers on its tables. Triggers are basically a set of SQL scripts that can be executed when data in a table is either inserted, updated, or deleted. Sometimes you may want to temporarily disable a trigger without completely removing it. The steps to do this, and enable …
November 30, 2012 -
Enable Apache Rewrite module on Ubuntu 12.04
By default, Ubuntu 12.04 doesn’t enable the rewrite engine module after installing Apache. The rewrite engine for Apache allows for on-the-fly URL rewriting/changing. This allows for the use of urls that are human readable, and SEO friendly. The rewrite engine is capable of capturing a website request, running it through a series of expression checks, …
November 29, 2012