Versions Compared

Old Version 5

changes.mady.by.user Marius Kruger

Saved on

compared with

New Version 6

changes.mady.by.user Unknown User (muku)

Saved on

Key

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

...

  • Create the two needed databases:
    CREATE DATABASE users;
    CREATE DATABASE archiva;
  • Create account to access them:
    GRANT ALL PRIVILEGES ON users.* TO 'users'@'*' IDENTIFIED BY 'users' WITH GRANT OPTION;
    GRANT ALL PRIVILEGES ON archiva.* TO 'archiva'@'*' IDENTIFIED BY 'archiva' WITH GRANT OPTION;

Note: the tables should be latin1 character set. If you use UTF8 you ran out of max key length:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

Glassfish file configuration

...