Hello,
I’ve got a problem with MySQL (not JBDC) and need some help from the community.
This is my acutal status:
- I’ve installed the binding of mysql
- I’ve edited mysql.cfg with the following structure
# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)
#url=
url=jdbc:mysql://127.0.0.1:3306/openhab
# the database user
#user=
user=openhab
# the database password
#password=
password=habopen
- I’ve edited mysql.persist with the following structure
Strategies {
everyMinute : "0 * * * * ?"
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
default = everyChange
}
Items {
RM_EG_Flur_Temp : strategy = everyMinute, restoreOnStartup
Yahoo_TemperatureMYSQL : strategy = everyMinute, restoreOnStartup
Yahoo_HumidityMYSQL : strategy = everyMinute, restoreOnStartup
Yahoo_PressureMYSQL : strategy = everyMinute, restoreOnStartup
}
- I’ve also grand all privileges to my openhab user and created a database.
The database is still there but no tables were found. I used some tutorials like Link but it doesen’t help.
In my openhab.log I found following statements
mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver
SQLException: Access denied for user ‘openhab’@‘localhost’ (using password: YES)
mySQL: No connection to database. Can not persist item 'Yahoo_HumidityMYSQL
What’s the failure? What is missing in my code or the tutorial? I need some hints thanks.
If you need some extra logs please tell me the path to the files.
Thanks