I've been struggling with Chapter 2 for about 4 days, an embarrassment really.
First, MySQL 6.0 was not available, so as directed by another question/answer on this board I went ahead and installed MySQL 5.7 - but I'm not sure I installed the correct instance as there was no "Windows Essentials (x86)" package (Step 2), no "Typical Install" option (Step 5), and it was never refereed to as "MySQL Enterprise" (Step 7). MySQL Enterprise is a paid tool, and the book indicated that the MySQL I could use would be free. I downloaded and ran "MySQL Installer Community Server 22.214.171.124.msi"
Second, I initially installed using "Developer Default" even though it looked like it had many more tools than "only the commonly used tools" - but when the syntaxs in Table 2-1 didn't work, I uninstalled all MySQL components (minus the 3rd party software prerequisites) and went with the "Server Only" option. Syntax still didn't work.
So, I'm not quite sure what I'm missing but I'd like some help. I've confirmed that the service is running, and by using the MySQL Client Command Line tool I was able to create a database for the sample data. So the Server was installed correctly - or at least enough to where the Troubleshooting guide available on the MySQL site for server install is not helpful. But the commands in Table 2-1 for steps 3, 5, 7, or 8 are not working in either the Windows Command Line or the MySQL Client Command Line. I've used command line before, so I feel I should be able to do this but it's not working.
Really frustrated that this book is *just* detailed enough to make me second guess everything I'm doing. Any other situation and I would just be problem solving as I go, but I'm a complete novice with SQL (didn't even have a server available!) so I was relying on O'Riley to walk me through this.
Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I can help you with this.
If you'll send me a screenshot of the errors you are getting when you try to go through those steps in the table, or at least provide the error messages, that will give me a lot of information about your problem.
You can either post it here, or send a message to firstname.lastname@example.org
O'Reilly Customer Service
This reply was removed on 2016-02-04.
see the change log