Updated – MySQL Installation Guide
I still get a bazillion hits on the MySQL install guide part of this blog, so I thought it would be a good idea to revisit that and true it up a little. Lets get started, shall we?
Fire up your favorite browser and go to the following URL:
If that fails because they’ve re-done the site for some reason, then hit the main page here, and navigate to their downloads section for “MySQL Community Server”
You’ll see a page load listing the “Generally Available (GA) Releases” – keep in mind that if you haven’t gotten adobe flash player installed, or are blocking this for some reason – the download list won’t appear properly.
You’ll see a box that has a drop-down menu for different OSes, but we’re sticking with “Microsoft Windows” so you don’t need to change anything.
Versions change of course, but the one we’re after as of this posting is the Windows (x86, 32-bit) MSI Installer.
Click on the download button, which will load another page.
You’ll see a page asking you to register or login if you are a returning user. You can skip all that by clicking on ” >> No thanks, just take me to the downloads!” link at the bottom.
Select a mirror that makes sense geographically, and click on either the HTTP or FTP link on the right hand side.
This will take a bit, so get up and grab a snack or something while it downloads.
Navigate to where you saved the installer, and double-click it to begin.
Hit the “Next >” button to continue.
You’ll be presented with some choices about setup type. “Typical” is already selected, and will work for what we want, so click on the “Next >” button to continue.
Now it will change to “Ready to Install the Program” with a summary of the setup type, destination (install) folder and such. Click on the “Install” button to continue.
Depending on how fast your machine is, you’ll see a progress bar for a bit as it unpacks the files and other tasks.
After that has completed, you’ll see an advert about MySQL Enterprise subscription. We don’t need this for personal use, so just click on the “Next >” button to continue.
Another advert for MySQL Enterprise Monitor Service will be displayed, but we’re not interested in that either. Click the “Next >” button to continue.
The “Setup Wizard Completed” will be displayed, along with two checkboxes, one for “Configure the MySQL Server now” (which we want), and “Register the MySQL Server now” (which isn’t really necessary for our uses.) Uncheck the Register checkbox, and click on the “Finish” button to continue.
Now you’ll see the “MySQL Server Instance Configuration Wizard”. Nothing to do here, so click the “Next >” button to continue.
You’ll be presented with a choice here for configuration type. We’ll go with the default selected “Detailed Configuration” here. Click on the “Next >” button to continue.
Now we’re going to select a server type so the installer will tune the installation properly. Since I have a decent amount of on-board memory in my machine, I selected “Server Machine” so it will be tuned for more memory. When in doubt, just go with the “Developer Machine” which is selected by default, and click on the “Next >” button to continue.
Yet another window, this time we’re selecting the database engine being used. You’ll want to go with the default “Multifunctional Database” here, unless you have a compelling reason to do otherwise. Click the “Next >” button to continue.
Now you’ll see the drive where the tables will be installed, and a usage bar indicating how much space will be used and the amount free. Leave the drive and install path at their defaults, unless you really need to change this because of space reasons. Click on the “Next >” button to continue.
They weren’t kidding about ‘Detailed’, were they? Here’s another window asking you to select the number of concurrent connections. I’m going to go with the default, which is 20. If you need more, then use the higher options in the window. Click the “Next >” button to continue.
Now we’re at the networking option window. By default, “Enable TCP/IP Networking” is checked. This makes sense for us, since if you are going to use this for opensim and eventually transition to grid mode, you may want your database server to be able to talk to the other grid components. Leave the port number set to 3306. Leave the “Add firewall exception for this port” unchecked, as we’re not interested in remote connections to this database right now. Leave “Enable Strict Mode” checked, and click the “Next >” button to continue.
You’ll now see a character set selection window. Leave the default radio button “Standard Character Set” selected, and click the “Next >” button to continue.
Now a window appears to set Windows options. “Install As Windows Service” will be checked by default, as well as “Launch the MySQL Server automatically”. Leave these the way they are, and check the box next to “Include Bin Directory in Windows PATH”. This is helpful later on when you want to issue commands to the server directly. Click on the “Next >” button to continue.
We are now at a very important section, setting the security options. Remember what you put in here! It will be important not only to administer the database, but to access it with other applications, like opensim. Type in your preferred root password, and retyping it for accuracy. Leave “Enable root access from remote machines” unchecked. Click on the “Next >” button to continue.
Now we’re finally at the part where all of your selections get implemented. All you need to do here is click on the “Execute” button, and watch it all fly by as the server gets installed and tweaked.
After it completes, you’ll see a new message in the window, asking you to click “Finish” to close the wizard. Go and do that now.
Get up, stretch your legs – time to do a reboot so the service can be started properly. We’ll be doing a few more things to verify it is all okay.
The database is installed, but it would be nice to have something to query it with. Sure, you could use the command line, but lets download the MySQL Workbench and install it.
Open up your web browser and go the following:
Look familiar? The same navigation is used to download this application like the server previously. Scroll down, until you see “Windows (x86, 32-bit) MSI Installer”. Click the “Download” button.
The same page as before will ask if you want to log in or register. Skip this like last time by clicking on the “>> No thanks, just take me to the downloads!” link underneath.
Select a mirror that makes sense, like before. Save the file where you can find it again easily.
Double-click on the workbench installer.
This will launch the usual installer window, click on the “Next >” button to continue.
Setup type by default is “Complete”. Keep this the way it is, and click the “Next >” button to continue.
You’ll now see a summary window like before, showing the type and destination folder for the install. Click on the “Install” button to continue.
A progress bar will appear while the installation takes place.
Once it is finished, you’ll see “Wizard Completed” now appears. Click on the “Finish” button to exit the installer.
Now, you can navigate to Start -> Programs -> MySQL and select “MySQL Workbench” to run the program.
After a quick splash screen, the main program window will appear. We’re interested in this bit right here on the left hand side. Click on “New Connection”.
A smaller window will pop up, with a bunch of options.
Type in the connection name up top, such as “Opensim Database”.
The default schema will be blank for now, but later on you’ll want to change this to the name of the database we’ll be creating, which will be “opensim”.
Click on “Store in Vault” button, to enter the password for the database. This will make managing it a bit easier when you use MySQL Workbench again.
Enter the password, and click the “OK” button.
Now click the “Test Connection” button on the lower right hand side.
If all went well, you should see a window pop up saying “Connection parameters are correct.”
Click on the “OK” button, and then on the “OK” button on the lower right-hand side of the “Manage DB Connections” window.
The window will close, and you’ll see that “Opensim Database” is now listed in the query window.
Great! Now lets click on “Open Connection to start Querying”.
You’ll see the “Connect to Database” window again, and now you can use the “Stored Connection” dropdown menu to select “Opensim Database”.
Click on the “OK” button on the lower right-hand side, and a new window will appear with a bunch of folders on the left hand side, a SQL Statements window, and below that a few tabs.
We now need to create the opensim database. Go to the “SQL Statements” window and type “CREATE DATABASE opensim” like so:
Hit enter, and then from the top toolbar, select Query -> Execute.
Now, right-click on “information_schema” and select “Refresh All”.
The database “opensim” now exists!
Now click on the small ‘x’ right below the tiny dos-window icon. (Not the main window ‘x’.)
If you feel like it, you can repeat the steps to connect to the database, select “Opensim Database” from the dropdown, and make the Default Schema on the connection the “opensim” database.
Close the workbench program. You are all set to install Opensimulator!
(Which I’ll continue in another tutorial.)
About this entry
You’re currently reading “Updated – MySQL Installation Guide,” an entry on OpenSim Easy User Guide
- March 4, 2010 / 8:36 pm