Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Unlike the Apache web server and PHP, the mySQL database is not installed by default with Mac OS 10. So, if you want to use the database, you have to download and install it yourself. You can get the free community server edition of mySQL by going to www.mysql.com/downloads and click on mysql community server. Scroll down this screen and you'll see that there are a number of different installers for Mac OS X. There are different compression versions.
There are tar archives and dmg archives. But there are also 32 and 64 bit versions of the database. You should install the version that matches your version of Mac OSX. Now, if you have a relatively new Mac with an Intel chip, You're almost certainly running 64-bit Mac, but if you want to make absolutely sure, here's a little trick. Go to Terminal and then type in the following command. Type it in exactly shown here. It is case sensitive.
ioreg–l–p, space, then IO device tree, then the pipe character, which is the character on the same key as the backslash. Then grep, space, and then finally, firmware dash ABI. You're executing a command that will tell you which version of Mac OS ten you're running. Press return. If the output includes the string EFI 64, then you're running 64 bit Mac.
I'm running 64 bit Mac OS X, so I'm going to use this version of the database server. Mac OS X version 10.6, x86, 64 bit, DMG archive. If you're running an older version of Mac OS X such as Leopard, use the appropriate version of MySQL. Now, I've already downloaded this DMG file to my desktop, and I'll run through the installation. I'll double-click the DMG file to open it, and I'll find three installers, one for the database One for an item that will go into the system preferences pane, and one for something called the MySQL startup item.
I'm going to install the first two. I'll start with the database. I double-click the dmg file, and click Continue. I'll click Continue again. I'll review the license agreement, and if I agree with its terms, I'll click Continue, and then Agree. I'll click Continue and click Install. If prompted for a password, type your administrative password in. It takes just a few minutes to write the files to your disc and execute a few simple configurations.
After the installation is complete, close the application and go back to your virtual disk. Next, I'll install the item for the system preferences. I'll double-click. And then at the prompt, I'll choose Install for all users of this computer, and then click Install. When prompted, I once again type in my administrator password. This adds an item to the system preferences pane that will let you easily start and stop your MySQL server.
I'll click the Start button. Once again, type in my password. And, after a few moments, MySQL server is running. If I later want to stop the server, I just click the button again. To get back to this panel, go to the System Preferences item on the Apple menu. And you'll find MySQL in the Other section of the System preferences. So that's a look at how to determine which version of MySQL. You should install, how to get and install the software from MySQL, and then how to use the System preferences pane to stop and start the server.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 76801 Viewers
80 Video lessons · 130937 Viewers
52 Video lessons · 64824 Viewers
59 Video lessons · 50649 Viewers
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.
Your file was successfully uploaded.