The World of MySQL

I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking for some query help, and one was from the Boy Scouts of America, also asking for some query help for a few reports. Strange that both requests came on the same day.

I didn’t have a MySQL install on the latest incarnation of my desktop or laptop. I did pop MySQL Workbench on a laptop last year, playing with Azure deployments, but no server. I deployed a MySQL instance on an Azure VM, but I had trouble connecting. Either the Ubuntu instance didn’t have the MySQL ports open (should have in the template), or I typed the password wrong. Either way, I just decided to delete that resource group (I love resource groups) and download the MariaDB server.

It’s a standard download from Mariadb.org and it’s not too large. In fact, it took longer to download than install.  The install was a standard msi installer, and ran in a minute or two.

2017-07-26 19_56_54-MariaDB 10.2 (x64) Setup

From there, I started up MySQL Workbench, which I’d downloaded and installed. I entered my user and password, using the default ports for the server.

2017-07-26 19_57_13-Setup New Connection

And things worked, as they should in 2017.

2017-07-26 19_57_29-MySQL Workbench

From there, I selected the data import and chose the file I’d been sent. It was (supposedly) a MariaDB dump, but listed as a .sql file. Looking through it, it has SQL and data inserts, so I ran it with the Data Import.

2017-07-26 19_59_06-MySQL Workbench

This ran for less than a minute and things were complete.

2017-07-26 20_03_19-MySQL Workbench

And sure enough, some MySQL syntax (googled to remember) works.

2017-07-26 20_04_53-MySQL Workbench

Now to debug some queries for a friend.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

3 Responses to The World of MySQL

  1. rsterbal says:

    I hope you check out one of the many Bitnami stacks that let you deploy a working open source application, often including mysql and apache with minimal effort: https://bitnami.com/stacks

  2. Piotr Rodak says:

    Thanks for this Steve. Indeed, setting up MySQL on Azure is a bit of a mission, I have impression.

Comments are closed.