Enable remote connection to asteriskcdrdb on freepbx
mysql
show databases;
use asteriskcdrdb;
SELECT User, Host, Password FROM mysql.user; ( if new user already created)
CREATE USER 'someuser' IDENTIFIED BY 'somepassword';
GRANT USAGE ON *.* TO 'someuser'@'someipaddress' IDENTIFIED BY 'somepassword';
GRANT SELECT ON asteriskcdrdb.* TO 'someuser'@'someipaddress' identified by 'somepassword';
FLUSH PRIVILEGES;
Code Block SELECT User, Host, Password FROM mysql.user; ( to show all MySQL/mariadb Users)
quit
...
