11 thoughts on - How To Use Phpmyadmin To Remotely Access Asterisk Mysql Database?

• As you’re on Ubuntu, you can begin with

  $ sudo apt-get install phpmyadmin

  If you have any more questions about PHPMyAdmin, you would do better to ask them on a MySQL or PHPMyAdmin forum.

  Also, 10.04 is a really old Ubuntu release now, even although it is a Long Term Support one. Consider upgrading to 14.04. You can apt-get dist-upgrade straight from an LTS release to the next LTS release, without needing to go through all the intermediate releases.

• Hi,

  thank you for your repplied,

  i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

  dist-upgrade go

  really appreciate for the advice, i’ll do that after i could remote to asterisk database from phpmyadmin.

  actually i have installed freeradius-server on my ubuntu too, and i could remote the database freeradius from phpmyadmin. is it possible if same phpmyadmin could remote database from freeradius-server and asterisk (they are on same server)?

  thank you

• Am 11.09.2014 um 10:36 schrieb rafa alfurqan:
  are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

  I suggest HeidiSQL Client at your Home PC
  connecting via SSH Tunnel to your remote mySQL listening at localhost only.

  link to heidiSQL -> http://www.heidisql.com/

• yes u can access form same phpmyadmin both database, depends, for which database u entered userid and password on phpmyadmin login page.

• Hi Rainer,

  security first !!!

  yes i’m sure coz it’s not for commercial, just for my research.

  only.

  i just heard HeidiSQL from here, it’s like a tool? actually i have no basic for anything about database or voip. if you mind, would you give me a tutorial or anything to configure that?

  thank you so much

• Hi Alok,

  database u entered userid and password on phpmyadmin login page.

  it’s there anything i have to configure in asterisk file so the phpmyadmin could work for asterisk?
  coz in freeradius-server, i have to configure a few file so phpmyadmin could work.

  Thank you

• Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

  HeidiSQL is like phpmyadmin !!!!
  have a look at http://www.heidisql.com/

  Features

  * Free for everyone, OpenSource.
  * Connect to multiple servers in one window
  * Connect to servers via commandline
  <http://heidisql.googlecode.com/svn/trunk/out/readme.txt>
  * Connect via SSH tunnel, or pass SSL settings
  * Create and edit tables
  <http://www.heidisql.com/screenshots.php?which=table_editor>, views
  <http://www.heidisql.com/screenshots.php?which=view_editor>, stored
  routines
  <http://www.heidisql.com/screenshots.php?which=stored_routines>,
  triggers
  <http://www.heidisql.com/screenshots.php?which=trigger_editor> and
  scheduled events
  <http://www.heidisql.com/screenshots.php?which=event_editor>.
  * Generate nice SQL-exports
  <http://www.heidisql.com/screenshots.php?which=export_sql>, compress
  these afterwards, or put them on the clipboard.
  * Export from one server/database directly to another server/database
  * Manage user-privileges
  <http://www.heidisql.com/screenshots.php?which=usermanager>
  * Import text-files
  <http://www.heidisql.com/screenshots.php?which=import_textfile>
  * Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP
  Array <http://www.heidisql.com/screenshots.php?which=export_textfile>
  * Browse and edit table-data using a comfortable grid
  <http://www.heidisql.com/screenshots.php?which

• Am 11.09.2014 um 11:28 schrieb Rainer Piper:

  I use HeidiSQL to administrate my 9x Nodes MariaDB Galera 10.0
  Multimaster DB Cluster. 😉
  *SMILE*
  I just love this tool 😉

• Hi Rainer,

  okay, thanks for your advice. so i think it would work for freeradius too.

  Cheers

• Am 11.09.2014 um 11:39 schrieb rafa alfurqan:

  I think so … freeradius DB is mySQL or oracle.

• 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*.