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.