Archive for October, 2010

October 24th, 2010

Connect to MySQL from windows command prompt.

This is a brief tutorial to help you connect to your database via the command prompt in windows using telnet. This should work just fine from the terminal window on a Mac as well but the screen shot won’t match exactly.

  1. Open the command prompt in windows through the start menu as shown in figures 1.1 and 1.2.

    figure 1.1

    figure 1.2

  2. Type ‘telnet’ into the command prompt (see figure 1.3).

    figure 1.3

    Then login to your web server using the command ‘open’ and entering the Login and Password you set up when you created your account. (figure 1.4) If you don’t know this information contact your web host.

    figure 1.4

  3. Once you’ve logged in open the MySQL command line by typing (see figure 1.5)
    %mysql -u -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 17109 to server version: 4.1.18-log
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

And there you have it. You are connected to MySQL now have fun manipulating your database.

October 21st, 2010

Google Chrome 7 browser update has a great user experience

Google announced today the release of the latest version of their Chrome browser, version 7. You can read all about the changes in the update from Google, but what I wanted to talk about was the great user experience for the update.

You start by click on the Wrench icon and going to About Google Chrome.  On there is a big button that says Update Now! You click on it and it starts installing right away. After it downloads and installs all the necessary files (in under 10 seconds by the way) it instructs you to close down all Chrome windows for the changes to take effect. That’s a GREAT EXPERIENCE. You installed all the stuff, but the update didn’t interrupt my current browsing session. You didn’t even force me to restart ANYTHING at that moment.  Then you finish what you’re doing and restart Chrome. Lets say you had 7 tabs open. Your start screen has a link to the 7 tabs you closed when you restarted so you can click on it and instantly be back where you were now running the latest version of Chrome. The whole process took under a minute for me.  That is a great user experience.