Category Archives: mariadb

Top Five MySQL Commands

As Sys admins we are often tasks with working on multiple and disparate systems we need to know a little about everything to allow use to do our jobs effectively. This post will detail my top five MySQL commands to know – with one bonus command! The commands are:

  1. Create database wordpress;
    1. This command creates a database call wordpress.
  2. Show databases;
    1. The Command shows all databases that reside on the server.
  3. Use wordpress;
    1. Selects the wordpress database for use – all subsequent commands will run the wordpress database.
  4. show tables;
    1. Shows all tables within the current selected database.
  5. select * from courses;
    1. Displays all information from the courses table.
  6. Bonus Command! grant all on WordPress.* to ‘wordpressuser’@’localhost’ identified by ‘wordpresspass’;
    1. Grants all permissions on the WordPress database from the user wordpressuser from the local machine with the password wordpresspass

If you want to see these commands in action check out the youtube video here:

Also be sure to download the cheetsheet here which you can save and print out:

 

Top Five MySQL Commands

How to install MariaDB on Windows

This MariaDB tutorial will show you how to install MariaDB on windows 10. By the end of the tutorial you will know how to install MariaDB as a service on Windows. This tutorial will show you how to install MariaDB server on windows.

You will first see how to download MariaDB to Windows. Next you will see how to run the MariaDB installer. You will next see how to configure the MariaDB server on Windows. Finally you will see how to test if MariaDB is working.

How to check MariaDB version

“MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation”

This short MariaDB tutorial will show you how to check the version of MariaDB you are running. We are running MariaDB on CentOS 7 but the process should be much the same for other operating systems.

Step 1 

Log into your MariaDB instance, in our case we log in using the command:

mysql -u root -p

Step 2

After you log in you can see your version in the welcome text – highlighted in the screen-grab below:

Step 3

If you cannot see your version here you can also run the following command to see it:

SELECT VERSION();

A full video tutorial on the process can be found here: