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

...