MYSQL pulling my hair out

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 :slight_smile:

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

Have you tried to use IP: 127.0.0.1 ?

bugger didnt think of that one thanks will give it a go to nite

Tryed the 127. Thing donโ€™t work :frowning:

What does the following give you?

nestat -nl |grep 3306