Installing MySQL

Before attempting to encode a link to MySQL, I thought I'd install MySQL on my local machine and have a bit of a play. My first port of call was the home page of the MySQL web site. I couldn't see any obvious link to installation or user instructions, so I tried the Windows page, but again it was all about selling the produce rather than using it. So I did a How to search on Google and ended up on a wikihow page which fitted the bill.

The screenshots on the installation page were from version 4.1 (I was installing 5.5), but they still pretty close to the mark. The recommendation to select "Standard Installation" from the Server Instance Configuration Wizard was a bad one because it hung. The default selection for custom installation worked better, not least because it automated the addition of the correct port to the Windows firewall.

Another reason the installation hung on my machine was AVG blocking the wizard, and it was not immediately obvious how to turn it off. After search for a forum post, it turns out I had to open Resident Shield, Advanced Settings, from the main console (see below).

From there is was pretty to uncheck "enable resident shield" (see below) to switch AVG off.

Meanwhile the wizard, having hung, needed to be closed with Task Manager, under the applications tab. Fortunately the initial installation of MySQL had placed an item in the Start menu under "Start">"All Programs">"MySQL">"MySQL Server 4.x" to restart the Server Instance Configuration Wizard, the first page of which gave the option to remove the MySQL service. I needed to do this so the wizard could then be rerun on a clean slate.

The installation page in wikihow seemed to think there would also be a menu item to Start MySQL in the command line, which there wasn't. However, the How to Send sql Queries to MySQL page had the syntax required to start mysql.exe straight from the command line.

In my case I was logging in as the root so the command was:

D:\Documents and Settings\Jonno>mysql -u root -p

During the setup I had opted to have the path to the MySQL binaries folder added as an environment variable, which is why I could run the command from my Windows home folder. The response came back:

Enter password: *******

I put in my password and got:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.5.9 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

I didn't want to enter any sql from the command line, so I entered:

mysql> exit

And got a very polite:

Bye

D:\Documents and Settings\Jonno>

Thus ended the lesson.


Comments

Post a Comment

Popular posts from this blog

A few notes on JavaScript

I am one the 99% of the world who has long nursed the misconception that JavaScript has something to do with Java. And why not? The name sort of implies it. It was only after I searched without success on the Java Tutorial site for some mention of JavaScript that I stumbled across the knowledge that JavaScript was in fact developed by Netscape, under the name LiveScript. Armed with that knowledge, it is not surprising to find the best reference information on Mozilla site. According to Wikipedia , the nonsensical name choice had something to do with Netscape wanting to cash in on the popularity and cachet of Java, and Sun wanting support for Java technology in the then popular Netscape browser. For a while only the Netscape family of browsers supported JavaScript. Microsoft later produced what it calls JScript to run in its browser. JScript is similar but not identical to Javascript. According to Foldoc JavaScript runs a hundred times slower than C , and ten
Read more

Forum Comments on Java Applets

It is so long since I last posted on the once was Sun/Java now is Oracle developer forum my account seems to have been ditched. While I wait to have it resurrected I've done a little searching in the Java Database Connectivity (JDBC) forum using the search term "Applet". My first search, using the default 3 month period, yielded nothing. No one had posted anything about or even mentioned Applets in the last three months. So either they are very easy to use and work very well, so hardly anyone has any problems with them, or maybe ... not very many people use them at all. My stomach was beginning to churn a bit, when I extended the search period to the current year - and with good reason. Somebody, a little bit like me I think, had written a game in an applet, and wanted to record top scores in a database. He described his connection problem in this thread , and the first reply began: Doing JDBC calls from an Applet is such a bad idea that I am glad y
Read more

Creating a Custom Swing Component

Image
I always return to my blog when I'm stuck, and I'm stuck right now. I want to create a custom Swing component. Specifically, I want something like a JProgressBar , with the following changes: In place of a flat Foreground color, I want a rainbow spectrum, showing only the red range for low Values, and the whole spectrum for values close to the Maximum value; Instead of a rectangular box, I want the progress "bar" to take the shape of a normal, or Gaussian, distribution curve; I want progress to be displayed by the area under the curve, rather than by a simple linear scale along the x axis. It's not that there isn't stuff out there. I have five tabs open in my browser, specifically addressing the creation of custom components in Swing, as well as the source code for the JProgressBar . It is that, like everything to do with Java, it is bloody difficult to read. I shall begin from the horse's mouth as it were, with an article on the Java
Read more