JVerein

Code: Alles auswählen

user@hostname:/var/log/mysql$ less mysql.log
117 Connect   datenbankuser@localhost on datenbankname
117 Init DB   Access denied for user 'datenbankuser'@'localhost' to database 'datenbankname'
118 Connect   datenbankuser@localhost on datenbankname
118 Init DB   Access denied for user 'datenbankuser'@'localhost' to database 'datenbankname'
119 Connect   datenbankuser@localhost on datenbankname
119 Init DB   Access denied for user 'datenbankuser'@'localhost' to database 'datenbankname'
120 Connect   datenbankuser@localhost on datenbankname
120 Init DB   Access denied for user 'datenbankuser'@'localhost' to database 'datenbankname'

Code: Alles auswählen

user@hostname:/pfad/zu/konfigdateien_jameica/cfg$ less de.jost_net.JVerein.rmi.JVereinDBService.properties
database.driver=de.jost_net.JVerein.server.DBSupportMySqlImpl
database.driver.mysql.jdbcurl=jdbc\:mysql\://localhost\:3306/datenbankname?useUnicode\=Yes&characterEncoding\=ISO8859_1
database.driver.mysql.username=datenbankuser
database.driver.mysql.password=passwort
database.driver.mysql.scriptprefix=mysql-

Code: Alles auswählen

mysql -u root -p
mysql> create database jverein;
mysql> CREATE USER 'jverein'@'localhost' IDENTIFIED BY '<passwort>';
mysql> GRANT ALL PRIVILEGES ON jverein.* TO 'jverein'@'localhost';