Hi, I have a non local MYSQL server
IP ending with .160 is my openhab box
IP ending with .180 is mySQL server
[ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mysql://xxx.xxx.xxx.180:3306/OpenHAB, user=openhab java.sql.SQLException: Access denied for user 'openhab'@'xxx.xxx.xxx.160' (using password: YES)
url=jdbc:mysql://xxx.xxx.xxx.180:3306/OpenHAB # the database user user=openhab # the database password password=xxxxxxxxxxxxxxxxxxxxxxxxxx
I added in my cfg file user=openhab @xxx.xxx.xxx.180
that is not working.