Some handy commands for MySQL:

  • mysql -u root -p
    • will login to mysql as root and prompt for the password
  • show databases;
    • will list the databases that exist
  • use databasename;
    • Switches to the database name
  • show tables;
    • lists the tables in the database
  • quit;
    • exit
  • mysqldump -u root -p --opt > /tmp/databases.sql
    • Dump all databases to a file which can be imported later
  • mysqldump -u root -p --databases databasename > /tmp/databasename.sql
    • Dump a certain database to a file to be imported later
  • mysql -u root -p -h localhost databasename < “/tmp/databasebackup.sql”
    • Import a file into a database
  • UPDATE user SET password=PASSWORD(‘YourPasswordHere’) WHERE User=’root’ AND Host = ‘localhost’;
    • change password