We will use Slick with MySQL 5.6. However, Slick supports other relational databases like Oracle, SQL Server, DB2, and Postgres. First of all, we need to install MySQL in our machine. Open the console, and perform the following steps (for Ubuntu Linux, other OS (Windows/Mac), and distros, check out http://dev.mysql.com/downloads/mysql/):
$ sudo apt-get install mysql-server -y $ mysql --version $ service mysql status
After installation with apt-get
, when you run the other two commands, you should see an output like this:
Once the installation is done and the MySQL server is up and running, we can move on and create the database. In order to get this, we will need to open the MySQL console. For development reasons, I did not put a password for root. However, for production, it is strongly recommended that you do use a strong password.
Execute the following command:
$ mysql -u root -p
This will give output as follows:
Once you enter the MySQL console...