How do I connect remotely to mysql server which Nextcloud is under jails

stanamas · March 22, 2021, 4:14am

Hi all,

I am installing Nextcloud under jails in Truenas 12 with an IP address of 192.168.88.6
Now, how can I connect to it’s mysql server remotely? I can’t even connect locally using localhost or it’s IP address.

Thanks

kerberos · March 22, 2021, 6:40am

during installation of MySQL did you perform the security settings?
The default of these are “disallow remote access”, so you can do this only from localhost

stanamas · March 22, 2021, 9:30am

Hi

I didn’t notice such an option during installation. Is there anything that user can do now to change it to ‘allowed remote access’?

Thanks

kerberos · March 24, 2021, 6:22am

as far as i know per default MySQL doesn’t allow remote access, only from localhost. Did you check your mysql.cnf?

stanamas · March 24, 2021, 7:50am

Hi

Thanks. You pointed me to the right direction. I have been able to change the bind address to 0.0.0.0 (/usr/local/etc/mysql/my.cnf) and connect locally before granted the user to connect remotely by mysql command line.

***GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;***

*** FLUSH PRIVILEGES;***

Thanks!