Currently our on-premise freepbx server has its my.cnf set to bind to it’s LAN IP and has worked quite well over the decades in allowing all users on the LAN to query the CDR records without issues as part of our customer billing system.
We now moved to the hosted sangoma freepbx in the cloud.
I tried setting the bind-address = After setting root password and creating a user for asteriskcdrdb
restarting mysql I still cannot connect from local LAN.
Access denied for user ‘callerid’@‘cpe-66-68-86-230.austin.res.rr.com’ (using password: YES)
How do I get a safe remote mysql connection set up so we can get our custom CallerID app running?
Thanks,
I added a user on the cloud server
grant all priveleges on asteriskcdrdb.* to ‘callerid’@’%’ identified by ‘’ with grant option;
then on my local pc for testing I do
mysql -ucallerid -p -h asteriskcdrb
The problem is not with my local firewall. I can connect to other mysql servers.
perhhaps I should create the mysql user on the remotepbx using my specific IP instead of the ‘%’
I added user like this
grant all privileges on asteriskcdrdb.* to ‘asset’@‘xxx.xxx.xxx.xxx’ identified by ‘’ with grant option;
then I changed the bind address=0.0.0.0
restarted mariadb
back on the local machine
mysql -uasset -p -h asteriskcdrdb
ERROR 1045 (28000): Access denied for user ‘asset’@‘24-155-92-212.static.grandenetworks.net’ (using password: YES)