Child pages
  • Setup MySQL on Linux

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.




Install MySQL

To install MySQL use your Linux's package system or install it manually by downloading it from and following their instructions.

Create database

With MySQL installed and started create a MySQL database named eHour by executing the following command and replacing user with a database <user> that has enough priviliges to create a new database:

Code Block
mysqladmin create ehour -u <user> -p
Install eHour database

With the ehour database created the next step is to create and initialize the datamodel.

In eHour's sql/mysql/install directory there's a fresh.mysql.sql script which contains the datamodel and default data.
Execute it by running the following command - replacing <user> with your database user:

Code Block
mysql ehour -u <user> -p < fresh.mysql.sql


The standalone distribution does not contain the fresh.mysql.sql, it's available at this location.