...
Don't forget we have release notes available for every version so you'll know exactly what has changed.
Database Creation
Open-AudIT requires a database to store its information in. If you ever need to manually create this database, the commands to do so are below. You should have already set a root password.
Linux
Create the database.
| Code Block |
|---|
mysql -u root -p -e "CREATE DATABASE openaudit;" |
Create the database user.
| Code Block |
|---|
mysql -u root -p -e "CREATE USER openaudit@localhost IDENTIFIED BY 'openauditpassword';" |
Give the user access tot he database.
| Code Block |
|---|
mysql -u root -p -e "GRANT ALL PRIVILEGES ON openaudit.* TO openaudit@localhost IDENTIFIED BY 'openauditpassword'; FLUSH PRIVILEGES;" |
Populate the database schema.
| Code Block |
|---|
mysql -u root -p openaudit -e "/usr/local/open-audit/other/openaudit_mysql.sql" |
Windows
Create the database.
| Code Block |
|---|
c:\xampp\mysql\bin\mysql.exe -u root -p -e "CREATE DATABASE openaudit;" |
Create the database user.
| Code Block |
|---|
c:\xampp\mysql\bin\mysql -u root -p -e "CREATE USER openaudit@localhost IDENTIFIED BY 'openauditpassword';" |
Give the user access tot he database.
| Code Block |
|---|
c:\xampp\mysql\bin\mysql -u root -p -e "GRANT ALL PRIVILEGES ON openaudit.* TO openaudit@localhost IDENTIFIED BY 'openauditpassword'; FLUSH PRIVILEGES;" |
Populate the database schema.
| Code Block |
|---|
c:\xampp\mysql\bin\mysql -u root -p openaudit -e "c:\xampp\open-audit\other\openaudit_mysql.sql" |