OH2
Ubuntu 16.04
trying to get mysql Working
setup is OK I think only cause I can see items table in MYSQL but no data
even if i delete DROP the table and do a restart the table come back
in services folder I have mysql.cfg
# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)
url=jdbc:mySQL://localhost:3306/openHAB
# the database user
user=openhab
when I look at the log i see
2017-06-23 20:06:37.801 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mySQL://localhost:3306/openHAB, user=openhab, password=Blabla
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
my question is
where else should i be looking
did find this folder userdata\config\org\openhab
with a mysql.config in it which have the content of
localtime="true"
password="Blabla"
reconnectCnt="1"
service.pid="org.openhab.mysql"
url="jdbc:mySQL://localhost:3306/openHAB"
user="openhab"
waitTimeout="3000"
if i delete above file and do a restart the mysql.config come back into the userdata\config\org\openhab
but i still get the
mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mySQL://localhost:3306/openHAB, user=openhab, password=Blabla
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
What am i Missing