Before attempting to access the Mysql console make sure that it is running. To check that:
Open terminal/shell and login your Mysql with the following command:
mysql -u root
Remember, if you are using a different user or password, using the following command and replace
youruser
andyourpassword
for your own credentials:mysql -u youruser -p yourpassword
Now let's create our database, type the following command:
CREATE DATABASE mvc_mysql_app;
The result after the command will be the following line:
Query OK, 1 row affected (0,04 sec)
This confirms that the operation was successful, and we are ready to go forward.
Now is the time to do the migration of the schemes to the database. Again we use the sequelize-cli
for this migration. Before we proceed, we need to install a Mysql module manually.