Monthly Archives: January 2021

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 Ubuntu on AWS

This Ubuntu Linux AWS tutorial will show you how to install Ubuntu on AWS. First you will open EC2 and search for the Ubuntu AMI. You will then step through the wizard to configure connectivity options ensuring that the Ubuntu server has a public IP allowing you to access. You will then generate a key to access your server. Next you will convert that key from pem to ppk using puttygen. Finally you will connect to your Ubuntu instance on AWS using putty Putty & Puttygen are available from:

https://putty.org 

If you found this tutorial useful please consider supporting on patreon:

https://www.patreon.com/darrenstechtutorials