MySQL Basic Commands

How to Connect to MySQL

To start working with MySQL, you’ll need to establish an active SSH session on your server.

mysql -u root -p

If you didn’t set a password for your MySQL root user, you omit the -p switch.

Create a new MySQL User Account

Next, you can create a new test user for practice. To do that, run the following command:

CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’;

If you need to delete a user later on you, use this command:

DROP USER ‘someuser’@’localhost’;

Create a New Database

To set up a new database use this line:

CREATE DATABASE yourdbname;