MySQL 5 Development (Part 1) Tutorials
Installation / Installation Basics
Subtitles of the Movie (MySQL 5 Development (Part 1) / Installation / Installation Basics)
Before we can get very far in this course, especially if you want to play along with me, we're going to have to Install the MySQL Software. Now if you already have a relatively modern version of MySQL one of the 5.Xs installed on your computer then that's fine but you'll still want to pay some attention when we talk about configuration in the next chapter. But if you don't, or if you want to get the most recent version, this is where we're going to be doing that operation, so you'll need to do some installation here. So we're not going to go through all of the details because there are so many different variations depending upon the platform that you're using, but we'll be talking about the very basics of doing this installation and then later in the chapter I will have lessons on each of the main operating systems, Windows, Mac OS X and the various Linux's to give you a little bit more detail, but ultimately you're going to have to read the manual and follow the instructions there. So, first thing that we have to do is get a copy of the Installer in the first place and figure out which Installer or Installers we need to use because we may have to use more than one. All of these things are available for free from the MySQL community website, now remember that's dev.MySQL.com, however, if we want to go directly to the downloads here we do dev.MySQL.com followed by a forward slash then downloads then another forward slash and MySQL, that will take us to the page that has the downloads on it. However there's also an anchor tag on that page if you want to take advantage of that so you can follow that with hash downloads and that will take you directly to the place that I'm going to show you an illustration of here on the next slide. And that's where we would begin the downloading process for getting our Installer. Now we need to make sure that both the Server and the Client Software are installed, the Server is the thing that manages the data, the Client is what we use to communicate with the server, so we need both of those. In most and I don't really mean most here because there are so many Linux's, so in Windows and Mac OS 10 in the server and the client software are all installed with the same installer. On all of the Linux's you have a separate server installer and a client installer so that's something to be aware of depending upon what platform you're using. So we have it for all of these different things and I use just the generic thing for UNIX platforms because we have not only Linux but also FreeBSD and Solaris and those are also UNIX type platforms, so there are many different choices for us to make. There are also Scripted and Unscripted Installers, now what do we mean by that? Well an Unscripted Installer would be something like a zip archive or a tar ball or something like that, whereas a Scripted Installer would be something like a Mac OS X package file, Microsoft Installer for Windows, an RPM on many of the Linux's and so on, there are different kinds of packaging software for the different platforms. The scripted ones have a script inside of it that not only unpacks these things and installs them in the appropriate location for us, so we don't have to make any real decisions there, but they also perform some other operations, adding things to the configuration file, creating and populating the MySQL database inside of the data directory, things of that nature. So we're going to use the Scripted Installers here because this is supposed to be an elementary level developer course, if we get into the administration course then we'll talk a little bit more about installation, we'll have an entire chapter that's a lot more thorough than this in that course. But here we just want to get the stuff installed so we can start working with it. So these things install the programs that we need both the Server and the Client programs and it establishes the data directory including the all-important MySQL database which has all of the administrative information for running the serverin the first place. You're going to have to read the manual though for all the specific things about your operating system, I can't possibly go through all of those things here. OK, here's what it looks like on that page, so when we come to this page the page itself will auto recognize whatever platform we're on. Now I was on a Mac when I did this you can kind of tell by the kind of drop-down list that I have here but I had already selected Windows just to take a screenshot and it recognized that I was on a Mac so it took me first to the Mac list, it just showed me that list of things. But there's a drop-down list here that I have open in this illustration that allows me to choose the other platforms and so I chose Microsoft Windows and we see that being reflected here. Now notice how this is laid out, there's a list of things, on the left side is the name of the installer it describes the operating system that we're going to be installing on, notice that there are 32-bit and 64-bit things, be aware of which of those is appropriate for you. When in doubt choose the 32-bit because that'll still run on a 64-bit machine. And it's showing version numbers and how big the installer is and all of that and then over on the right there is a download button, so that's where we begin is on this page. But there are steps to the download process even then, once we found the thing in list that we want, we click that download button on the right-hand side, that's going to take us to another page that looks like we have to first sign in with a user account or create a user account. Well that's not really true, just below that if you scroll down just a little bit there's a nice link in bold kind of bluish letters that says, No thanks just take me to the downloads. If you want you can sign up and get an account and they'll start sending the monthly newsletter to you and all kinds of other things but you don't have to do that, they don't want you to muck up their database if you're not interested in what they're sending you so just click this link and everything will be fine. Then you choose the appropriate mirror site and choose whether you want to use HTTP or FTP as your file transfer protocol and sometimes you have both choices, sometimes only one, click that and it will begin the process. So from there on you want to follow the manual instructions to follow through on the installation, this is just for downloading the installer. OK, in the next lesson we're going to look at the Windows process, and this is an important one because it's the only one that actually has a GUI interface, a Wizard that we walk through, actually two Wizards, and it helps us to make certain configuration decisions as well. So please watch the Windows one even if you're not on the Windows platform, because you will learn a few things that will be important once you get into the configuration process in the next chapter. OK, on to Windows Installation.
Tutorial Information
| Course: | MySQL 5 Development (Part 1) |
| Author: | David Swain |
| SKU: | 34225 |
| ISBN: | 1-936334-93-3 |
| Release Date: | 2011-05-27 |
| Duration: | 11 hrs / 129 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
