Child pages
  • Setup MySQL on Linux

Versions Compared

Key

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

...

Section


Column

Install MySQL

To install MySQL use your Linux's package system or install it manually by downloading it from http://www.mysql.com/downloads/mysql/ 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


Info

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