Connection to JSS Database error

kerouak
Valued Contributor

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 attachedfbeaa6f6e3d249419c3dc0f894855408

JSS running on RHEL vm

5 REPLIES 5

sdagley
Honored Contributor II

@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
Valued Contributor

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

sdagley
Honored Contributor II

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

kerouak
Valued Contributor

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

sdagley
Honored Contributor II

@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