You are here: Home » VPS Hosting » MySQL DB Management SSH command line

MySQL Basics

Creating a new MySQL Database on Debian

  • Login via SSH
  • Run: mysql -u root [note: if you have changed and/or set the password, use the -p option at the end]
  • Run: create databases DATABASE;
  • Run: exit;

Creating a MySQL User and Attaching It to a Database on Debian

  • Login via SSH
  • Run: mysql -u root [note: if you have changed and/or set the password, use the -p option at the end]
  • Run: grant ALL on DATABASE.* to 'user'@'localhost' IDENTIFIED BY 'password';
  • Run: flush privileges;
  • Run: exit;

Importing a MySQL Backup

  • Login via SSH
  • Run: mysql -u root DATABASE < /home/path/to/backup.sql [note: if you have changed and/or set the password, use the -p option at the end after root]

Exporting a MySQL Backup

  • Login via SSH
  • Run: mysql -u root DATABASE > /home/path/to/save.sql [note: if you have changed and/or set the password, use the -p option at the end after root]

^ Top