In this course we will use MySQL.
If you do plan to use MySQL, please use only following release:
MySQL Community Server 5.7.21
Installation
- Use the following link to download the MySQL server.
- The following document steps you through the installation process on Windows. Keep in mind the guide uses a previous version of MySQL. Make sure you use the version specified above.
- For Ubuntu users, you can install the GUI-based workbench through Software Center. The following image shows you the installation options.
Creating the database
- Create and use your database.
Basic command to create your database: create database foo;
Basic command to use your database: use foo;
Basic command to create a new user:
CREATE USER jenn IDENTIFIED BY 'jennspassword';
grant usage on *.* to jenn@localhost identified by 'jennspassword';
grant all privileges on foo.* to jenn@localhost;
Test it: mysql -u jenn -p