Create and Select a Database

Learn about basic SQL commands to create and use databases.

Start MySQL client

Let’s start by creating the CRM database. Click on the widget at the end of the lesson to connect the terminal. Start the MySQL client with the command mysql -u root to start the command-line interface to access the MySQL server.

Note: If our root user has a password, we need to start MySQL with the command mysql -u root -p and type the password when prompted. Keep in mind that “root” is a username.

Get hands-on with 1400+ tech skills courses.