Local Network Access to FreePBX MYSQL Server

General Help
1

FreePBX 2.9.0.5

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?

2

here’s how I got access.

I added these lines to my.cnf
[mysqld]
user = mysql
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
skip-external-locking
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
bind-address=192.168.1.250

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.

3

freepbx doesn’t touch my.cnf

4

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

http://www.freepbx.org/forum/freepbx-distro/distro-discussion-help/very-minor-things