[asterisk-users] How to use phpmyadmin to remotely access asterisk mysql database?

[A J Stiles]

On Thursday 11 Sep 2014, rafa alfurqan wrote:
> Hi,
> 
> thank you for your repplied,
> 
> > As you're on Ubuntu, you can begin with
> > $ sudo apt-get install phpmyadmin
> 
> i did that, so what i have to do for the configuration in asterisk so i
> could remote to asterisk database from phpmyadmin?

If you installed PHPMyAdmin on the same server as Asterisk, then it should 
Just Work because as far as PHPMyAdmin is concerned, the MySQL server is 
local.  What do you get when you point a web browser at /phpmyadmin on 
server's IP address?


All PHPMyAdmin is, is a tool for building up database queries and displaying 
the results.  Anything you can do using the MySQL command line, you can do 
with PHPMyAdmin.


If you can get a query such as

SELECT * FROM cdr ORDER BY calldate DESC LIMIT 1;

to work from the command line, then it will work through PHPMyAdmin.  
Conversely, if it *doesn't* work from the command line, then you need to sort 
that *first*.

-- 
AJS

Note:  Originating address only accepts e-mail from list!  If replying off-
list, change address to asterisk1list at earthshod dot co dot uk .