PDA

View Full Version : mysql database browsing




yagran
Jul 22, 2007, 06:57 PM
Hi, i have a non local mysql database which i need to browse.

i dont have and admin tools installed on the database.

is there anyway to do this?



cepler
Jul 22, 2007, 07:00 PM
Hi, i have a non local mysql database which i need to browse.

i dont have and admin tools installed on the database.

is there anyway to do this?

phpMyAdmin

SMM
Jul 22, 2007, 07:03 PM
You might try this (http://www.apple.com/downloads/macosx/development_tools/isqlviewer.html):

I seem to remember seeing other similar products out there as well.

Mitthrawnuruodo
Jul 22, 2007, 07:05 PM
iSQL viewer (http://www.apple.com/downloads/macosx/development_tools/isqlviewer.html)

Navicat (http://www.apple.com/downloads/macosx/development_tools/navicatdatabaseadministrationmysqlclient.html)

yagran
Jul 22, 2007, 07:10 PM
ok sounds great. let me give a you the bigger picture.

the details i have

<?php
define("HOST", "*****");
define("PORT", *****);
define("USER", "*****");
define("PASS", "*****");
define("DB", "*****");
?>

(but obviously i have the details where the stars are :P)

and i have the ip address of the server...

this isnt as dodgey as it must sound...

Mitthrawnuruodo
Jul 22, 2007, 07:21 PM
define("HOST", "*****");
...
and i have the ip address of the server...The HOST doesn't work...?

yagran
Jul 22, 2007, 07:27 PM
The HOST doesn't work...?

well as i said it is not local.

i am using the navicat program that you suggested and have filled in the connection details but get : Can't connect to MySQL server on XXXXXXXXXXX

i mean, the details i have is that the server ip is XXXXXXX and the host name is 'XXXX', navicat will not let me use both to establish a connection.

im new to all this by the way! :D

Blue Velvet
Jul 22, 2007, 07:33 PM
It is dodgy. And twenty minutes ago, I sent the details of your other post to Westfield. Serious.