Database Foundations: Stage 2 - Installing MySQL Server and MySQL Workbench Launched

That's some impressive turn around under 20 hours.

I'm so excited you are covering MySQL Workbench, not enough tutorials on MySQL cover that awesome tool.

I've been looking for something just like this! I'm in software quality assurance and work with databases frequently. Unfortunately, I haven't had much training with databases so I occasionally struggle when working with them. These modules will definitely help me understand the basics and become more proficient in my job. Thanks!

Andrew,

On this section - http://teamtreehouse.com/library/programming/database-foundations/installing-mysql-server-and-mysql-workbench/installing-mysql-server-and-workbench-on-os-x

Having some trouble with setting up the config file.

When I type in this: "sudo cp /usr/local/mysql/support-files/m"

This is what I see:

usage: cp [-R [-H | -L | -P]] [-fi | -n] [-apvX] source_file target_file cp [-R [-H | -L | -P]] [-fi | -n] [-apvX] source_file ... target_director

I'm wondering if I made an error during the installation.

The command is sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

sudo cp is the command /usr/local/mysql/support-files/my-default.cnf is the source_file and /etc/my.cnf` is the target_file.

You're only typing part of the source_file after the command.

You can copy and paste the command in to your terminal.

Thanks!

You make an excellent teacher, Andrew! I'm new to Treehouse, having started out in database foundations, and I'm not sure what to expect regarding scheduled roll-out of the full course. Is there an ETA for stage 3, and/or what is a typical timeline for stage releases at Treehouse?

Thanks Chris and welcome to Treehouse!

Stage 3 is in post-production (video editing) at the moment. Then it'll go over to QA.

In general we aim to get new stages out every 2 weeks or ~2 a month.

We update our Roadmap here with approximations.

Hey Andrew, your videos have already been a huge help to me so far, you make it all very easy to understand. The one problem I'm having is that when I try to create a server instance it tells me that there is no connection to the MySQL server. I followed all the installation instructions precisely but I can't seem to get it to connect. I also ran the sudo command and double checked in Terminal to make sure that the "my.cnf" file was copied properly into the etc directory. My startup message log shows me this:

2013-05-28 22:50:54 - Checked server status: Server is stopped. 2013-05-28 22:50:58 - Starting server... 2013-05-28 22:50:58 - Start server: usage: sudo [-n] -h | -K | -k | -L | -V | -v usage: sudo -l[l] [-AnS] [-g groupname|#gid] [-U username] [-u username|#uid] [-g groupname|#gid] [command] usage: sudo [-AbEHnPS] [-C fd] [-g groupname|#gid] [-p prompt] [-u username|#uid] [-g groupname|#gid] [VAR=value] [-i|-s] [<command>] usage: sudo -e [-AnS] [-C fd] [-g groupname|#gid] [-p prompt] [-u username|#uid] file ...

2013-05-28 22:50:59 - Checked server status: Server is stopped. 2013-05-28 22:50:59 - Server start done.

Thanks so much for all of your help so far (in the videos) and for any help you can provide me with this issue.

Hi Guru,

I'm guessing you're on Mac OS X.

Are you getting this is the WorkBench client? Have you tried rebooting your system?

If you type cat /etc/my.cnf in your terminal do you get a stream of output in your terminal like:

...
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Hey Andrew,

Thank you very much for the quick response. Yep I'm on OS X, sorry for not specifying before. I figured it out and embarrassingly for myself the problem was simply that the server wasn't running. I am very new to MySQL Workbench and didn't quite understand how the server instances work. I thought that maybe they were supposed to run the server as part of the process. In the video there isn't a specific step that tells you to run the server before creating a server instance, but maybe that's supposed to happen automatically when you install MySQL Community Server and my computer just didn't do it for some reason. Anyway I ran the server from Terminal and that fixed the problem, and then I remembered the MySQL server utility that you helped me install into the System Preferences. I tried running and stopping the server from there and it worked as well. Thank you so much for all of your help and I look forward to finishing the series and finally understanding databases. Thanks again!

Hey Andrew,

I think Guru has a point. Where in the Introduction to Installation of MySQL videos does it tell you to initialize or execute mySQL and how do you go about doing it? Thanks!

-Robert

Hi Guru Khalsa and Robert Ho,

I'll see if I can corner a video pro tomorrow to see if there was an error in editing.

I'll report my findings :)

Regards Andrew

I double checked the footage and it wasn't edited, it seems that the optional step of installing the preference pane started it.

But I think if it's not running, when creating an "Instance" to manage it will prompt you to start it. You need to create an "Instance" that's running before you run your queries with the Query Browser.

Andrew, at what point does the mySQL "start?" Like at what point during the video, installation of the software, etc etc.

hello Andrew, im loving your video,, i installed both the server and workbench but the later is not showing any thing other than the shortcuts and that one model and and to add connection , what should i do ?

I'm running Mavericks on OS X and when I type the sudo command (copied from above) to copy the config file, it says "No such file or directory." Could it be a problem with Mavericks?

Sorry, it was a stupid mistake. I already had MAMP installed and I intended to use it for MySQL, so naturally there wouldn't be a config file in a location that didn't exist. I did get it working though. Thanks, and sorry for the hassle!