Child pages
  • How To Install or Upgrade Open-AudIT (Windows)

Versions Compared

Key

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

...

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. If you have not, the default root password set by an Open-AudIT installation is openauditrootuserpassword.

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"

 

 


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"