Aug 25

If you are using the latest version of the terrible, slow, web-based remote support application LogMeIn free for mac then all you need to do to remove it is go to “Applications” -> LogMeIn -> and double click on the LogMeInUninstaller.  When the Uninstaller comes up, just click on “Yes” to uninstall it.

If you are using an older version of LogMeIn then you will need to go to the following directory:

/Library/Application Support/LogMeIn/

run uninstaller.command

This will open up a terminal and prompt you for your Mac username and password and then uninstall LogMeIn from your system.

Either way, you need to reboot your system after both methods.

Aug 20

sudo gedit /etc/apt/sources.list
Add these two Lines:
deb main
deb-src main
btw replace jaunty with intrepid if your still using that.

Now add the GPG Key:
sudo apt-key adv –recv-keys –keyserver 5a9bf3bb4e5e17b5

sudo apt-get update ; sudo apt-get install chromium-browser

Now once installed Go to Applications->Internet->Chromium Browser and right click it, add to Desktop
Right click the new chromium icon and go into properties and add the following where it says command:
chromium-browser %U –enable-plugins

Note: You’ll of course need flash installed for firefox first, to install that:
sudo apt-get install flashplugin-installer

Now lets install flash before we launch this baby:
sudo cp /usr/lib/firefox/plugins/ /usr/lib/chromium-browser/plugins/

Now click the newly made icon and head over to Youtube or Hulu

Aug 19

Everybody knows about some of these boot key combinations, but some of the more obscure combinations have been long forgotten (like how many of us have a Quadra AV and use a TV as a monitor!) – Check these out, you may need one of them someday!

  1. •C : Forces most Macs to boot from the CD-Rom drive instead of the internal hard drive. Only works with Apple ROM drives and with bootable CD discs.
  2. •D : Forces the first internal hard drive to be the startup disk.
  3. •N : Netboot (New World ROM machines only) – Looks for BOOTP or TFTP Server on the network to boot from.
  4. •R : Forces PowerBooks to reset their screen to default size (helpful if you’ve been hooked up to an external montior or projector!)
  5. •T : Target Disk Mode (FireWire) – Puts machines with built-in FireWire into target Disk mode so a system attached with a FireWire cable will have that device show up as a hard drive on their system. Very useful for PowerBooks!
  6. •Mouse Button Held Down : Ejects any mounted removable media.
  7. •Shift : Disables all extensions (Mac OS 7-9), or disables Login items when using Mac OS X 10.1.3 or later. Also works when booting Classic mode up just like you were using the OS natively.
  8. •Option : When using an Open Firmware “New World ROM” capable system, the System Picker will appear and query all mounted devices for bootable systems, returning a list of drives & what OS they have on them. On “Old World” systems the machine will simply boot into it’s default OS without any Finder windows open.
  9. •Space bar : Brings up Apple’s Extension Manager (or Casady & Greene’s Conflict Catcher, if installed) up at startup to allow you to modify your extension set.
  10. •Command-V : Boots Mac OS X into “Verbose Mode”, reporting every console message generated during startup. Really shows what’s going on behind the scenes with your machine on startup!
  11. •Command-S : Boots Mac OS X into “Single User Mode” – helpful to fix problems with Mac OS X, if necessary.
  12. •Command-Option : Rebuilds the Desktop (Mac OS 7-9).
  13. •Command-Option-P-R : Erases PRAM if held down immediately after startup tone. Your machine will chime when it’s erased the PRAM, most people will hold this combination for a total of 3 chimes to really flush the PRAM out.
  14. •Command-Option-N-V : Erases NVRAM (Non-Volatile RAM). Used with later Power Macintosh systems mostly.
  15. •Command-Option-O-F : Boots the machine into Open Firmware (New World ROM systems only).
  16. •Command-Option-Shift-Delete : Forces your Mac to startup from its internal CD-ROM drive or an external hard drive. Very helpful if you have a 3rd party CD-ROM drive that is not an Apple ROM device.
  17. •Command-Option-Shift-Delete-#(where #= a SCSI DEVICE ID) : Boot from a specific SCSI device, if you have your 3rd party CD-ROM drive set to SCSI ID 3, you would press “3″ as the # in the combination

And, the obscure ones :>) Older computers only, on some.

  1. •Command-Option-I : Forces the Mac to read the disc as an ISO-9000 formatted disk
  2. •Command : Boots with Virtual Memory turned off.
  3. •Command-Option-T-V : Forces Quadra AV machines to use TV as a monitor.
  4. •Command-Option-X-O : Forces the Mac Classic to boot from ROM.
  5. •Command-Option-A-V : Forces an AV monitor to be recognized correctly.
Aug 14

Let me guess, you can’t delete a file from the Trash bin on your Mac. When you try to ‘Empty Trash’ you get an error message saying ‘The operation cannot be completed because the file is locked’. This is a fairly common problem and one which almost every Mac user encounters at some point. I will show you how to delete the file from your system.

Deleting a file from Trash

Some Common errors upon attempting to Empty Trash include: “The operation cannot be completed because the file is locked” or “The operation cannot be completed because the item is in use”.

  1. 1.Drag the file from your Trash bin to the Desktop.
  2. 2.Launch a Terminal Go > Utilities > Terminal and type the following into the terminal window leaving a space after f:
  3. ~/.Trash && sudo rm -rf
  4. 4.Drag the file from your Desktop to the terminal window and then press Enter
  5. 5.Enter your password when prompted and press Enter

6.    If everything goes as planned the file should now be deleted from your system.

Aug 13

To login (from unix shell) use -h only if needed.

# [mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server.

mysql> create database [databasename];

List all databases on the sql server.

mysql> show databases;

Switch to a database.

mysql> use [db name];

To see all the tables in the db.

mysql> show tables;

To see database’s field formats.

mysql> describe [table name];

To delete a db.

mysql> drop database [database name];

To delete a table.

mysql> drop table [table name];

Show all data in a table.

mysql> SELECT * FROM [table name];

Returns the columns and column information pertaining to the designated table.

mysql> show columns from [table name];

Show certain selected rows with the value “whatever”.

mysql> SELECT * FROM [table name] WHERE [field name] = “whatever”;

Show all records containing the name “Bob” AND the phone number ’3444444′.

mysql> SELECT * FROM [table name] WHERE name = “Bob” AND phone_number = ’3444444′;

Show all records not containing the name “Bob” AND the phone number ’3444444′ order by the phone_number field.

mysql> SELECT * FROM [table name] WHERE name != “Bob” AND phone_number = ’3444444′ order by phone_number;

Show all records starting with the letters ‘bob’ AND the phone number ’3444444′.

mysql> SELECT * FROM [table name] WHERE name like “Bob%” AND phone_number = ’3444444′;

Show all records starting with the letters ‘bob’ AND the phone number ’3444444′ limit to records 1 through 5.

mysql> SELECT * FROM [table name] WHERE name like “Bob%” AND phone_number = ’3444444′ limit 1,5;

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with a.

mysql> SELECT * FROM [table name] WHERE rec RLIKE “^a”;

Show unique records.

mysql> SELECT DISTINCT [column name] FROM [table name];

Show selected records sorted in an ascending (asc) or descending (desc).

mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

Return number of rows.

mysql> SELECT COUNT(*) FROM [table name];

Sum column.

mysql> SELECT SUM(*) FROM [table name];

Join tables on common columns.

mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES(‘%’,'username’,PASSWORD(‘password’));
mysql> flush privileges;

Change a users password from unix shell.

# [mysql dir]/bin/mysqladmin -u username -h -p password ‘new-password’

Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

# mysql -u root -p
mysql> SET PASSWORD FOR ‘user’@'hostname’ = PASSWORD(‘passwordhere’);
mysql> flush privileges;

Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

# /etc/init.d/mysql stop
# mysqld_safe –skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(“newrootpassword”) where User=’root’;
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Set a root password if there is on root password.

# mysqladmin -u root password newpassword

Update a root password.

# mysqladmin -u root -p oldpassword newpassword

Allow the user “bob” to connect to the server from localhost using the password “passwd”. Login as root. Switch to the MySQL db. Give privs. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> grant usage on *.* to bob@localhost identified by ‘passwd’;
mysql> flush privileges;

Give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES (‘%’,'databasename’,'username’,'Y’,'Y’,'Y’,'Y’,'Y’,'N’);
mysql> flush privileges;


mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

To update info already in a table.

mysql> UPDATE [table name] SET Select_priv = ‘Y’,Insert_priv = ‘Y’,Update_priv = ‘Y’ where [field name] = ‘user’;

Delete a row(s) from a table.

mysql> DELETE from [table name] where [field name] = ‘whatever’;

Update database permissions/privilages.

mysql> flush privileges;

Delete a column.

mysql> alter table [table name] drop column [column name];

Add a new column to db.

mysql> alter table [table name] add column [new column name] varchar (20);

Change column name.

mysql> alter table [table name] change [old column name] [new column name] varchar (50);

Make a unique column so you get no dupes.

mysql> alter table [table name] add unique ([column name]);

Make a column bigger.

mysql> alter table [table name] modify [column name] VARCHAR(3);

Delete unique from table.

mysql> alter table [table name] drop index [colmn name];

Load a CSV file into a table.

mysql> LOAD DATA INFILE ‘/tmp/filename.csv’ replace INTO TABLE [table name] FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ (field1,field2,field3);

Dump all databases for backup. Backup file is sql commands to recreate all db’s.

# [mysql dir]/bin/mysqldump -u root -ppassword –opt >/tmp/alldatabases.sql

Dump one database for backup.

# [mysql dir]/bin/mysqldump -u username -ppassword –databases databasename >/tmp/databasename.sql

Dump a table from a database.

# [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

Restore database (or database table) from backup.

# [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql

Create Table Example 1.

mysql> CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));

Create Table Example 2.

mysql> create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default ‘bato’);

Aug 12

Snap is a quick way to resize your open windows.  All you have to do is drag them to the edges of your screen.

Depending on where you drag a window, you can make it expand vertically, take up the entire screen, or appear to the side of another window. Snap makes it easy to read, organize, and compare your windows.  This is just one of the new features in Windows 7.  Make sure you read my other tutorials related to the new features of Windows 7.

Aug 11

Let me guess, You have a windows machine running in VMWare Fusion.   Sometimes when you reboot the vm, it hangs while shutting down or rebooting.  When you look at t he VMWare menu you only see the following options:

If you have tried everything and can’t seem to shutdown or reboot  your vm then there’s one more thing you can do, go to the VMWare menu above and hold down the option key.  Once you do this you will see the following options:

You now can actually power off the machine or reset it.

Aug 10

Need to clean up disk space in Ubuntu? Try the following commands from a gnome terminal:

sudo apt-get autoremove – This command removes any unused dependencies from the Ubuntu system.

sudo apt-get clean – This command removes all cached package files.i

These commands won’t hurt your system. On a system that’s been updated a couple of times, you can free-up as much as a gigabyte using these commands.  You can do a before and after using the following command:

df -k

Aug 07

Changing your Mac’s computer name is easy.  Just follow the steps below:

  1. •Launch ‘System Preferences’
  2. •Click the ‘Sharing’ icon
  3. •Type in what you want your new computer name to be
  4. •Close ‘System Preferences’ – it’s that easy
Aug 06

To enable the viewing of hidden and system files in Windows Vista follow these steps:
1.Close all programs so that you are at your desktop.

2.Click on the “Start” button.

3.Click on the “Control Panel” menu option.

4.When the control panel opens you can either be in “Classic View” or “Control Panel Home” view:

If you are in the “Classic View” do the following:

1.Double-click on the Folder Options icon.

2.Click on the View tab.

3.Go to step 5.
5.If you are in the “Control Panel Home view” do the following:

1.Click on the “Appearance and Personalization” link.

2.Click on “Show Hidden Files or Folders”.

3.Go to step 5.

6.In the “Hidden files and folders” section, select the radio button labeled “Show hidden files and folders”.

7.Remove the checkmark from the checkbox labeled “Hide extensions for known file types”.

8.Remove the checkmark from the checkbox labeled “Hide protected operating system files”. Once this is done, your Folder Options screen should look similar to the following image.

9.Press the “Apply” button and then click the “OK” button.

10.    Windows Vista is now configured to show all hidden files.

preload preload preload