Archive for September, 2009

Documentation MacOSX – Burn a DMG or ISO image to disc.

0 Comments

Bring up the Disk Utility in Applications/Utilities.
Drag and drop the image file to the left window pane. The image file will be listed along with your other disk drives.
Click on the newly listed image file to select it in the Disk Utility.
Click on the Burn icon on the top toolbar.

Tags:

Documentation MySQL Commands

0 Comments

I intend to add to this as I have time.

To display the schema of a table:
mysql> desc tablename;

To update all records in a column of a table:
mysql> update tablename set columnname=’value‘;

To update one record in a column of a table. Note: othercolumnname needs to be unique to the record.:
mysql> update tablename set columnname=’value‘ where othercolumnname=`somevalue‘;

To create an account:
GRANT ALL PRIVILEGES ON databasename.* TO ‘username‘@’hostname‘ IDENTIFIED BY ‘password‘;
GRANT ALL PRIVILEGES ON databasename.* TO ‘username‘@’localhost’ IDENTIFIED BY ‘password‘;
FLUSH PRIVILEGES;

To make mysqld listen only localhost:
vi /etc/my.cnf

bind-address=127.0.0.1

Documentation Configure Finder to display the hidden files and directories.

0 Comments

From a Terminal session, type in the following:

To display hidden files:
defaults write com.apple.finder AppleShowAllFiles TRUE
killall Finder

To hide hidden files:
defaults write com.apple.finder AppleShowAllFiles FALSE
killall Finder

Tags: