Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.
In this movie, we're going to learn to install MySQL. MySQL is a free and open source database that we're going to be using to connect to, from PHP. PHP will connect to the MySQL database and then either store data in the database or retrieve data back from the database to work with in PHP. Installing is pretty simple. We just go to the MySQL website, download it, and then run the installer. The URL for downloading is going to be http://dev.mysql.com/downloads/mysql. Let's go there now. So, here I am at the MySQL download page.
And the version that we're going to be using is refered to as the community server. That's the free and open source version. There are some of mySQL that have some additional features, some that are paid. The one that we want is the community server. If you scroll down this page, you'll see that this is the actual download area right here. And the newest version, right now, is 5.6.10. By the time that you watch this tutorial, that number very well may have changed. Don't worry about it, go ahead and get whatever the latest version is. MySQL has not changed significantly over many versions.
The basic features are still the same, and that's what we're going to be using, is just the basic features. So, you can feel comfortable using version 5.7, 5.8, maybe 6.0. don't worry about it, go ahead and get the latest version. You can see also it's preselected Mac OSX as our platform of choice. So, we're seeing only Mac OSX versions in this list. But you'll notice that the OSX version that list right now, is 10.7. That's the newest one. There are some 10.6 versions down here, but there's nothing that says, 10.8. That's okay as well. Go ahead and download the 10.7 version for working on 10.8. It works just fine.
There's also another choice we need to make which is, what format do we want to download it in, either compressed TAR archive, or DMG archive? This is a disk image, and this is the one that has the clickable installer in it that we want. So, we're going to want to have the DMG archive version. And then we have one more choice to make. Do we want the 32 bit version, or do we want the 64 bit version? Chances are, you want the 64 bit version. All modern Macs use the 64 bit. Now if you have an older Mac, you may want to actually check and look on Apple's site. Apple offers some information about how you can determine whether you have a 32 bit or a 64 bit processor.
But almost all Macs from the last couple of years are going to be 64 bit. So, this is the one we want. Mac OSX Version 10.7 with the Intel processor, x86, 64-bit and in the DMG Archived format. So, once we have that, we can click download. It'll come up and ask us to either login or sign-up, but we don't have to do either. If you scroll down past that, you'll see that there's a little link here that says, no thanks, just start my download. That's the one that we want Firefox is going to ask me what it wants me to do with this installer.
We can just save it to our desktop. For Firefox, I can say Open with Image Mounter, and that will do it for me. You can also just save it to desktop, but then double-click on the resulting file. So once it's downloaded, Firefox will open up this window for you. Or you can double-click on the disk image to be able to see this window. And there's three things in here. There's MySQL. The MySQL Preference Pane, that's going to go in your system preferences. And then, MySQL Startup Item, that's going to start up MySQL for you. You're going to want all three of those, and you're going to do them in this order. So, we're going to start with the one over here on the far left, that's going to install MySQL itself. Now by default, Apple has something set up on your Mac called Gatekeeper that makes sure that malicious programs aren't run.
And they've gone ahead and said, don't let it run at all. Go ahead and refuse to let this program run because it didn't come from the App Store or a list of approved developers. We want to turn that off. There's a couple of ways to do that, you can either use the Ctrl key and click on this and click Open. Or, we can go ahead and go to system preferences and just turn off the feature, which is what I like to do. You could turn it back on if you feel uncomfortable with that. We're going to click the lock to make changes, under Security and Privacy, and then we're going to need to put in our password. And then, instead of just having Mac store and identify developers, allow applications downloaded from anywhere. Choose from anywhere, and then you can close that Control panel. Now, we can launch it and we'll go past Gatekeeper and we'll be able to run the installer.
Click Continue, Continue, Continue, we'll agree to the license and then it says, where do you want to install? We'll install on my hard drive here, and it's going to want my password. Okay, so now my software has been successfully installed. We can click Close. We now have My SQL. Before we can go and try that out though, let's run the Preference pane and install that. We'll install it for this user only or all user of this computer we'll go and say all users. It's going to ask for my password again.
And there it was. Did you see it there? Let me just go back to Show All. Here is the Preference pane, so this is now going to give me a way to start and stop MySQL. For now, I'm going to just hold off on that, we'll come back to that. I'm going to do and do the MySQL start up item package, and let's run that one. Is a very small little program. And there down that's installed. So now, let's go back and lets actually start up MySQL. And I've got it set to automatically start MySQL surround startup.
That's an option for you, you don't have to, but I'm going to go ahead and have it do that, so it's always running for me. Doesn't take up a lot of processing power, so for most cases, you won't even notice that it's running. And let's tell it to start up the server. Says it's now running, so there it is. And if we want to stop it, we have that Preference pane right there to stop it as well. Nice and easy. So, now that we have MySQL installed, we can go ahead and close up these windows, and we can throw this disk image in the trash. Before we start using MySQL, there are two small configuration changes we need to make. And we'll see how to do those in the next movie.
Find answers to the most frequently asked questions about PHP with MySQL Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.