unable to connect to mysql in jail

[jordanthompson]

I am able to:

root@mysql:~ # telnet localhost 3306 Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'.




but I cannot either logged into TrueNAS or from another (remote) host

I'm not that familiar with freebsd, but from what I have read, at least the TrueNAS version doesn't come stock with a firewall, so I don't believe that is the problem... Suggestions?

 

[jordanthompson]

Not sure how to edit the previous post... I meant to say that I can telnet to the mysql instance from the jail shell, but not from a ssh session into the FreeNAS server or from my laptop

 

[jordanthompson]

Solved... I had several issues going on:

create user 'joe'@'%' identified by 'password'

I had a star (*) instead of percent (%). My eyes are getting tired...

the other issue was that

bind-address = 0.0.0.0

was set in the wrong file... Should be in:

/usr/local/etc/mysql/conf.d/server.cnf