How do I create a new user account?

• the database user account (typically done by the database administrator)
• the application user account

MySQL user creation

• Start MySQL as database administrator
  
  mysql -user=<database_admin_name> -p=<database_admin_password>
  
  
• Now execute one of the grant commands to create the new database user
  
  for a new application administator user:
  GRANT ALL ON jeremia_db.* TO a_username@"%" IDENTIFIED BY 'a_password';
  
  for a new general application user:
  GRANT ALL ON jeremia_db.* TO a_username@"%" IDENTIFIED BY 'a_password';
  
  for a guest (read only) user
  GRANT USAGE, SELECT ON jeremia_db.* TO a_username@"%" IDENTIFIED BY 'a_password';
  
  Please change a_username to your new user name and a_password to this users password!
  
  
• Exit MySQL
  
  exit;
  

JEREMIA application user creation

• Start JEREMIA
• Login as administrator user. The user theadmin with password theadmin is preinstalled.
• Select menu itemOptions/EditUser
• The following dialog window is shown:
  
  
  
  
• Press the New-Button
• Enter the user name. Remember it must be written exactly like the database name.
• Press the Update-Button. The user name is now read only.
• Select the AccessRight-Tab
  
  
  
  
• Press the Edit access rights-Button to select the access rights
  
  
  
  
• Select the access rights
• Press the OK-Button. The selection dialog closes.
• Press the Update-Button. The access right assignment is stored.
• Press the Close-Button to leave the dialog.