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.
vBulletin® v3.6.10, Copyright ©2000-2009, Jelsoft Enterprises Ltd.