MySQL Tools

[amfonline]

I use MySQL Tools like MySQL Query, MySQL Migration and MySQL Admin on other sites and I want to use it on my POWWEB based sites. Anyone out there done the installs? Does it work? Any clues for me - which of the downloads do I need, where on the POWWEB server does it have to be installed, etc. Or is this something I need to have POWWEB install for me?

Thanks much!
Angela.

[omatic]

If you can get by with PHPMyAdmin, which most of us do, you won't need to install anything. Powweb has a common copy installed already. Simply browse to http://phpmyadmin.powweb.com and log in. You will need your MySQL username, password, database name, and hostname (which can be found in Ops).

If any of the tools you prefer use ODBC to access your MySQL database, you are probably out of luck, as Powweb does not permit remote access. All MySQL connections must originate from their network (e.g., from PHP or CGI scripts, etc.).

Good luck,
omatic

[amfonline]

I have been trying to work with myPHPAdmin, and I just prefer the MySQL stuff.

I know this is a sore point for a lot of people out there (yes, I did look at some of the old posts from the days when remote access was terminated - too bad. I - like you did at the time - have extensive automations tied in on some of my sites that I would love to put on POWWEB with out the re-scripting ;) ) but I also saw several posts alluding to installation of different admin tools at that time.

Just testing to find out the the MySQL products are usable if installed from the POWWEB host, and IF they even can be installed on the POWWEB host...

Thanks omatic!
Angela.

[omatic]

Well, you're welcome, and I do hope it works out for you.

Actually I even tried adding "restore MySQL remote access" to the Powweb Wishlist, but I just got some canned answer about it not being possible on a Unix platform. Oh, brother. :confused:

[IanS]

Well, you're welcome, and I do hope it works out for you.

Actually I even tried adding "restore MySQL remote access" to the Powweb Wishlist, but I just got some canned answer about it not being possible on a Unix platform. Oh, brother. :confused:Despite 'it not being possible' - send it and the ticket # to Joshua and add it in the wishlist thread (with the ticket #).(You never know, an option for something similar may become available - for all I know.)

[HalfaBee]

Well, you're welcome, and I do hope it works out for you.

Actually I even tried adding "restore MySQL remote access" to the Powweb Wishlist, but I just got some canned answer about it not being possible on a Unix platform. Oh, brother. :confused:

That must have been one of the Windoze based support members.

[omatic]

That must have been one of the Windoze based support members.

Quite possibly the case, 0.5xBee. Even if so, though, I believe that's an inaccurate reason, since I strongly suspect remote access is possible under Windows as well as *nix. Can't prove that at the moment, though - never tried it myself.

Either way, it's not a valid excuse here. Heck, we used to have the ability a couple of years ago right here on PowWeb, until it became deemed a security risk. THAT reason I can understand, but "not possible" I don't buy.

[HalfaBee]

MYSQL was designed for UNIX and has all the options for remote access.

[dmacminn]

hmmm... yes, the remote access is definitely in the MySQL system design -- you can setup a local copy of the MySQL tools and your own dedicated server to test that!

.... but, not possible on Powweb, as the servers reside inside a protected subnet that you can't connect to from outside the network.

The copy of myPHPAdmin supplied in OPS, of course, knows how to manage the databases inside that secure area ... but, that's the only route available currently.

[satis]

just fyi, MySQL Windows DOES allow remote access. :) I have several test databases running on WinXP/Win2k that I connect to using ODBC (mainly).