Versions Compared

Key

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

...

Run this and your schema will be upgraded and you can then continue to use Open-AudIT as normal.

Don't forget we have release notes available for every version so you'll know exactly what has changed.

...

Open-AudIT requires a database to store its information in. If The installer automatically does this for you, but 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.

...

.

...

Create the database.

Code Block
c:\xampp\mysql\bin\mysql.exe -u root -p -e "CREATE DATABASE openaudit;"

...