Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines. Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.
In this movie I'm going to show you how to install XAMPP on a Mac. XAMPP is spelled X A M P P. It's a package that includes the Apache web server and MySQL and PHP and a bunch of other things. And we're going to be using it for running the examples in this course. So you need to install it on your machine if you want to follow along with the examples in this course. Before you install XAMPP there's a couple of things you'll need to do. One is to check your system preferences and you want to make sure that you're not already running a web server.
So under Sharing here, if you see Web Sharing you want to make sure it's unchecked. If you have the very latest version of OS X you probably will not see web sharing here and that's fine, that means that you're probably not already running a web server. But if you're using a version of OS10 earlier than 10.8, I believe it is, you might have web sharing here and it might be checked. And that means that Apache is already running on your machine. You want to uncheck that and quit that version of Apache before installing and running this other one.
So I'm going to quit system preferences with cmd+q. And next I want to install a text editor so I'm going to come up here to the app store and I'm just going to search for Text Wrangler. There it is Text Wrangler is free, you see it's already installed on this Mac. If it's not already installed on yours, you'll want to just click the free installation button there. It's an excellent text editor. You see it gets great reviews and we'll be using it in this course.
Just want to press command Q to quit the app store. And now here on the Apachefriends.org website. This is where you would get ZAMP from and there's a download button here for Apple. I'm going to ask you though to download it from my website instead and the reason for this is explained on this page. But basically. Because they update the Xampp package frequently, the way you install it and the way that it works tends to change frequently. And if you really want to follow along with my installation and follow along with the examples, then you probably want to be running the exact same version that I'm running today as I do this recording.
And you can download that right here under the Mac section here for ZAMP for SQL or MySQL 2014 current version, that's this course and you would download this version 1.8.3-3. You would download that and install that one. It's probably okay if you install this other one from the example web site from apachefriends.org. It just, it might look different on the screen and some of the installation steps might be different and you might need to figure some of that out yourself. You really just want to follow along with me when I suggest you download it from my website.
Now I've already downloaded it. Here, and I have it here on my desktop. And I'm going to double-click on this DMG Package. And it brings up this installer, and I just double-click on this installer. And you get this standard warning that I downloaded from the Internet, and I say okay. Go ahead, and open it. And type in my password. And we'll just press next. And we'll leave all these things checked, press next and press next again. Just to install it to the default location. I'll uncheck this because all it does is bring up a webpage, which you can bring up at any time.
Provides the installer for XAMPP and they also allow you to install some other packages. If you want information about that then leave it checked. I'm just checking it and pressing next. And next one more time to go ahead and run the installation. And you'll see some adds up here about BitNami. The actual software does not have ads. It does not install anything unnecessary on your computer. It's actually a pretty good package and I've been using it for a number of courses over the years. Alright, so setup is complete. All this launch XAMPP button does is it starts up Safari.
And since I'm not using Safari I'm not going to leave that checked. So I'm going to click finish, and I'm going to go ahead and unmount the installer here. Just click on my desktop and press command N to bring up a new finder window, and go to applications. And XAMPP and I see here this manager OS10 app. I'm going to drag that down here into my dock and let's just put it on the other side of Safari there. And I'm going to go ahead and click on that. It calls itself application manager from the inside.
From the outside, it's manager OS10. I'm just going to type in my password. This is my system password because it needs administrator privileges. And select manage servers. And you notice that it already started Apache because we just installed. That won't always be the case though, so. You may have to select that and press Start like I'm going to do with MySQL. I'm going to start MySQL. I select it over here and I press Start. And it says Starting for a moment. And then it will say running and we'll get a little green light here.
And there we have it. Now I can Command + Q, quit. It'll always ask me. If I'm sure the manager application does not need o keep running, those servers are now started and they're running in the background. And so, I don't need that manager app again unless I want to stop them. For example, if I wanted to stop them I could click on the manager app, type in my password. And go to Managed Servers, and then I could stop them. I could press stop here. I could select that one. I could stop there. Most of the time, you're not really going to need to stop them. Pressing Command + Q here to quit.
Running them all the time doesn't take much CPU, or much energy. So, I'm going to bring up Google Chrome here, and I'm going to open a new tab, and type in local host. And there we have it. We're running xampp, and if I click on English, I can look at the status here. It says MySQL is running, php, perl, all these things. And if I come down here to php MyAdmin. It opens it in a new tab here. And we can see that My SQL is running because it's finding all these databases here.
And so we have now successfully installed Zan. Now you can use whatever Web browser you want. I'm using Google Chrome. There's no reason you have to do that. You just need to come back up here and open a new tab and type local host again. Anytime you type local host it will bring you up to this XAMPP page. You can check the status and documentation and what have you. And php MyAdmin is right there. And that's how you get into PHP admin. So, now you've successfully installed ZAMP on your Mac.
In the next movie, I'll show you how to set up your MySQL users.
There are currently no FAQs about MySQL Essential Training.
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.