MySQL Problems


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)

# the database user

# the database password
  • 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.


Its able to connect but the password you’ve provided is incorrect. I would change the password for the openhab user.

Thanks. This was the correct answer.