↓ Skip to main content
Terminal Wars
Terminal Wars
  1. Posts/

MySQL: Lesson 1, What is MySQL and Where do I start?

·
Blog - Ender's Endeavors Databases MySQL
Ender
Author
Ender
Cybersecurity pro by day, gamer and storyteller by night. I write about breaking systems, exploring worlds, and the tech that powers it all.
Table of Contents

MySQL: Lesson 1, What is MySQL and Where do I start?
#

The Basics:
#

Before we get to MySQL, what is exactly is SQL?

SQL stands for Structured Query Language. It is a language designed to communicate with databases.

SQL is a non-proprietary language, there is a standard committee (ISO) that established the common SQL syntax but the SQL implementation you are learning here is called MySQL which happens to be open-source and free to use.

MySQL is a client-server software, meaning that to use MySQL you need both a MySQL Server and MySQL client. The server handles all the database operations, while the client is what you, the end-user, uses to interact with the database. If it helps to visualize this take a look the featured image above, the large central gold stack is analogous to the SQL server and the smaller blue stacks are the SQL clients used to interact with the server.

Tools: MySQL Workbench & MySQL Utilities.
#

MySQL Workbench (recommended for beginners)

MySQL Workbench

MySQL workbench is suite of GUI tools designed for Database Administrators (DBAs) and developers an integrated tools environment for:

Database Design & Modeling SQL Development (replacing MySQL Query Browser) Database Administration (replacing MySQL Administrator) Database Migration

SQL Development is a client used to write and execute MySQL commands. Database Administration, as the name implies, is used to simplify the administration of the MySQL servers.

MySQL Utilities is a collection of command line tools for maintaining and administering MySQL servers

Both MySQL Workbench and MySQL Utilities are available for download on the MySQL website here.

Related

Jetpack and the Admin Area

Blog - Ender's Endeavors MySQL Databases Wordpress Jetpack
So I wanted to install Jetpack but once I activated the plugin I was no longer able to reach the WordPress admin area. My obvious conclusion was that something about the plugin wasn’t agreeing with my server. After a quick once over the logs and finding nothing useful I needed to manually disable the plug-in. This can be done easily by deleting the value from ‘active_plugins’ row in the ‘wp_options’ table in your wordpress database. For most people with managed servers you can use phpMyAdmin to quickly navigate and edit to value. However seeing as I do not have it installed I needed to manually edit my database.

Automate My Life

Lifestyle Blog - Ender's Endeavors Automate Burned Out
I’m going to honest, I’m burned out. Dead as a door nail, stick a fork in me, I’m done. # I’m stressed out, but not from one particular task or subject. I come home mentally exhausted, and usually with a headache. This isn’t anything new, everyone gets burned out from time to time, but my usual management techniques just don’t work anymore. Don’t get me wrong, I put on a good face but I’m dead inside. I get accolades and awards for my work. I make time for my hobbies every other weekend yet I feel unfulfilled. This isn’t depression, depression is an old companion of mine. Depression I could handle, mange, and live with. I’ve always been a self-starter, but what I lack is a more important, a goal. I’m fighting complacency, I’m satisfied with what I have accomplished thus far and I struggle to want more.

Hello world!

Blog - Ender's Endeavors Hello
Hello everyone, so this is my first post to what I guess will be my blog. I guess my current focus is mostly just getting this site up and running completely I’m still working out the page layouts and sections I want. This blog section will be my place to write down my thoughts and ramblings on various topics. These topics will probably be very broad in scope as I am interested in many things so I hope you check back often for new content. My interests include but are not limited to: Snowsports, Cyber Security, Sci-Fi and Fantasy novels, gadgets & gizmos, and much much more.