IT/Software/Database Applications/mysql command line/mysql commands

Here we will list helpful things to do on mysql

when we say mysql that means you are on a server and are running mysql

• From the command line type mysql -u root
  • Enter your password
  • It will not appear
• Now you are in mysql!

Deleting data older than a date

• Get into mysql as a root or otherwise privileged user
  • You can also login in as the user to the database you want to work on.
  • But if that use has global or high privileges you stand the cnace of breaking something
    • Don't be fooled by the above statement. You ALWAYS stand the chance of breaking something.
• Select the database you want
• use databasetoworkon

Restoring root access

• For some reason root access by password was removed from the defaults at some point
  • I first noticed this on Ubuntu Server 18.04
• There are many and varied ways to restore this.
  • Beware not all of them work.
  • The below one was derived from a Tutorial on Digital Ocean
    • Thanks guys!