Connect to MySQL via SSH Tunnel

I have set up a MySQL server and want to connect to it from different machines.  However, I do not want to open it up to the public.  To secure my connection, I will not allow external connections to the MySQL server.  I will simply set up a SSH tunnel and connect to it that way.  My local MySQL commands are forwarded to the remote host.

Assumptions:

1. You can SSH into the remote host.
2. If you are like me, you are not running a MySQL on your local host.

Setting up the SSH tunnel:

1. ssh -f -L 3306:localhost:3306 user@host -N
2. Enter password:

Connect to MySQL

1. mysql -h 127.0.0.1 -u user -p
2. Enter password:

You should be see the MySQL prompt.

mysql>

Samsung Gravity T USB Connection on Mac

To connect your Samsung Gravity T to your Macbook go to

Menu > Settings > Phone Settings > PC Connection > Mass Storage

The USB cable must be unplugged and the phone must be on the idle/home screen.

 

Circular Google: Useless Top Search Results

Circular Google: http://ubuntuforums.org/showthread.php?t=401339

I google a lot.  Google is my public library.  If I have a question, I google for the answer.  I also happen to think that I am in the majority.  (Note: In the rant that follows, I am not blaming Google.  Google is great!)

Sometimes, not too rarely, the number one Google hit contains a forum question similar or identical to mine followed by an rude and unhelpful jerk responding, "Google it!"  This annoys me so much.  The reason why this annoys me so much is because the forum response will not only be seen by the person posing the question but also by others with the same question.  Eventually, this forum thread might become the number one search result, an useless top search result.

Thus, please if you are going to bother responding to someone on a forum, don't respond "Google it!"  I did!!!  Check out the Circular Google image above to see a perfect example of a useless top search result.

Installing Ubuntu 10.4 on HP Pavilion tx2000

Ubuntu 10.4 on HP Pavilion tx2000: Monitor 1

Ubuntu 10.4 on HP Pavilion tx2000: Monitor2

In a previous post, I described how easy it was to install Windows 7 on my HP Pavilion tx2000.  It worked almost perfectly out of the box.

Though, I am beginning to like Windows again thanks to Windows 7, I installed Ubuntu because I do Linux programming.

Wireless, tablet screen, and multiple monitors worked without having to hack anything.  Ubuntu supports them.

Things that don't work:

• HP Quick Launch Buttons around the screen border
• DVD, QuickPlay, Settings, and Rotation
• Mute button doesn't turn red when muted but the volume buttons do work.

As you have read, the list of things that didn't work using the standard Ubuntu 10.4 desktop installation were very few.  They are also identical to things to didn't work after installing Windows 7.  HP drivers are needed.  I don't think that I will bother for now.

I must also say that the start up and shutdown times are amazing! The picture above demonstrates my Ubuntu desktop.  I, of course, applied a dark theme to the controls and the window borders.  It looks and feels great.  I hope that this helps somebody trying do the same thing or something similar.

Soundness and Completeness

Universe

Here is a loose definition of soundness and completeness.

An argument is sound if everything that can be derived from it is true; no false positives.
An argument is complete if everything that is true can be derived from it; no false negatives.

Referring to Universe figure above,

• A is sound.
• B is sound and complete.
• C is complete.
• D is neither.

 B is the kind of argument, reasoning, and systems you want to be dealing with.