As a continuation of Part 1 in this tutorial, we’ll work through some basic interaction with our test database using MySQL Workbench. Some things we’ll cover include:
- Setting our current database
- Creating a new table
- Inserting rows into a table
- Selecting rows from a table
- Basic UI review of Workbench
Without further adieu, lets get started using MySQL!
At long last… the first real post of the intro series on getting started with MySQL! (Better late than never, right?)
There are a few ways you can go about setting up a test instance that are generally shared across Operating Systems:
- Install locally on your machine (Windows, OSX, Linux)
- Set up a local Virtual Machine, then install MySQL on the VM
- This is my preference as it also allows me to get familiar with the OS (preferably Linux)
- Set up a quick Amazon EC2 Instance
- This is easiest if you are comfortable with EC2, but can also be costly if you forget to turn off an instance or want to spend lots of time testing and experimenting
For the sake of folks getting their feet wet, I’ve setup a Virtual Appliance that you can import and start using right away:
The rest of this post and Part 2 will be a step-by-step guide on getting starting with the above appliance. So lets get started!
As I start to work through some various tutorials and other instructional guides, I want to get a feel for what people are using. Please let me know what OS you are currently using and which OS(s) you feel comfortable with.
Ideally, I’m planning to provide a VirtualBox appliance built out with CentOS (linux) that you can run on any machine. Depending on your comfort level, you can interact with MySQL using:
- MySQL UI Tools (workbench)
- VM command line (ssh into VM, then work locally)
- Local command line client
Check back for a post discussing Virtual Box as it should prove to be a great tool for experimenting with and learning MySQL, regardless of the OS you are used to using. It will also allow you to experiment, make changes, etc and not worry about impacting your actual system.
To complement the theme of “Getting Started with MySQL”, we’ll also be starting a series of blog posts with similar topics:
- Installing MySQL
- Some basic SQL
- Operating System differences
- and more
Check back soon to see the first post in hopefully a helpful series for those wanting to get started with MySQL!