Local Network Access to FreePBX MYSQL Server


FreePBX pretty much stripped the my.cnf file to the secure bones.
My problem, Need to query the cdr data from other hosts on local network.
I see there is no phpMyadmin available in the repository.

I’ve seen the other horror stories out there.
Anyone have any suggestions?

here’s how I got access.

I added these lines to my.cnf
user = mysql
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
key_buffer = 16M
max_allowed_packet = 32M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
;collation_server = utf8_unicode_ci
;character_set_server = utf8

Next I logged in to mysql and issued,
grant all privileges on cdr to root identified by ‘passw0rd’ with grant option;

Then I restarted mysql
service mysqld restart

Of course I will now be changing my default passwords.

freepbx doesn’t touch my.cnf

Look at this thread, it has some notes on how to use phpMyAdmin with the Freepbx Distro.