Connection to JSS Database error

[kerouak]

Hi all, tearing my hair out trying to figure this one.

So, Create a local database = All fine.

When connecting to a database on another server, I get the following error: See attached

JSS running on RHEL vm

[sdagley]

@kerouak Since the access to your MySQL Server is now coming from a non-local account, did you do a GRANT ALL on the JSS database for the user@<ipaddressofjsstomcathost>?

[kerouak]

Yep, did that, also used mysql on the database server using u/n and password

[sdagley]

@kerouak Did you comment out the bind-address line in the MySQL my.conf file so external connections are allowed?

[kerouak]

Yep! Previously connected fine but built new jss and get the error

[sdagley]

@kerouak Can you try manually connecting to MySQL on your database server from a different machine to verify it is accepting remote connections (if that isn’t what you meant by your post on 11/06 at 10:58AM)? Connect to a MySQL database remotely