FAQ

MORE FAQ items will be added as the semester progresses…

Answers to common questions:

1. I am a Mac user and MySQL Workbench crashes unexpectedly.  What should I do?

   You probably have version 8.0.32 of workbench (the latest one.) It is buggy on the MacOs.  Check your version of workbench.  If it is 8.0.32 then your fix is to uninstall/trash that and go get version 8.0.31 from the MySQL Workbench download archive page: https://downloads.mysql.com/archives/workbench 

2. I am getting

   {"message":"Missing Authentication Token"}

   Watch this: https://youtu.be/ytHlMpFN44s (5 mins)

3. I am getting

   {"message": "Internal server error"}

   Watch this: https://youtu.be/s_f6OJ5NEsM (14 mins)

   Tips: test your API with either a browser or a REST client, isolate the problematic code (it is usually the last thing you worked on!), edit your lambda’s event handler and test one specific function using the blue Test button in AWS. This is probably the easiest way for you a specific error message and line number.

4. I uncovered an error that looks something like this “ER_ACCESS_DENIED_ERROR: Access denied for user ‘misXXX’@‘ec2-54-99-99-99.compute-1.amazonaws.com’ (using password: YES)”

   This usually means that you have made one of these mistakes

   • Your MySQL username and/or password are typed incorrectly
   • You have misspelled the name of a table in your query