MIDAS KnowledgebaseMIDAS Knowledgebase

How to install MIDAS - Manually create a new MySQL Database

Before you install your self-hosted MIDAS scheduling system, you will need to create a blank MySQL database on your server. The following instructions describe how to manually create MySQL database from the command line.

If your server runs cPanel, follow this tutorial instead, otherwise carry on reading...

Note: Text in red below denotes information you may need to change/customize for your particular server.

Step 1: Login to your MySQL server

From your server's command line, login to your MySQL server by executing the following command:
$ mysql -u root
NOTE: If you're running MySQL on a Windows machine, you can skip this step and access the MySQL command line via the "MySQL Command Line Client" shortcut in your Start Menu → Programs → MySQL folder instead

Step 2: Create a Database

Enter a desired name for your MIDAS database:
mysql> CREATE DATABASE `MIDAS`;
NOTE: You will need the name of this database when installing MIDAS - also, please note that MySQL queries outlined here may contain "backtick" characters ( ` ) which are not the same as regular apostrophes ( ' )

Step 3: Create a User

Once you've created a database, create a new MySQL user:
mysql> CREATE USER `newuser`@`localhost` IDENTIFIED BY 'password';
NOTE: You will need this username/password when installing MIDAS

Step 4: Add The User To The Database & Set User Privileges

Once you've created a database and a MySQL user, you will need to associate the user with the database:
mysql> GRANT ALTER, CREATE, DELETE, DROP, INSERT, SELECT, UPDATE ON `MIDAS`.* TO `newuser`@`localhost`;

Step 5: Flush Privileges

Finally, to ensure that the privileges you set in the previous step are applied, issue the following command:
mysql> FLUSH PRIVILEGES;

Once you've setup your MySQL database, you're ready to install MIDAS

You might also be interested in...
» » »

← Return to Knowledgebase