MySQL Remote Connection

[ashary]

My site, apoacme.net, is registered with Powweb. I bought a MySQL, then set a user name. Since powweb does not allow telnet access, they recommend using Mascon (from http://www.scibit.com/) to administer my MySQL.

Can anybody help me how to go about establishing a connection with my remote MySQL Server? What are the settings that I have to configure in order to access and administer MySQL? The program (Mascon) is asking the Hostname, Host/IP Address, and Port.

Please...

[sophiespo]

Ive never used macson (I use phpMyAdmin) but Ill try to help.

Hostname would probably be just the name, just put in powweb or something.

Host/IP Address Forget about the IP part, just put in the server that your database is on, i.e. venus.powweb.com or terra.powweb.com, etc.

Port is 3306 I believe.

If Ive gotten anything wrong, someone please let me know.

sophie

[ashary]

sophie, thanks for your prompt reply. it didn't help however. can you tell me where i can get phypMyAdmin?

[sophiespo]

http://phpwizard.net/projects/phpMyAdmin/
http://phpmyadmin.sourceforge.net/

sophie

[Bud]

My version of Mascon asks for the following:

- Connection Name: Can be anything you want to call it

- The Hostname: Would be your server, mine is pluto.powweb.com

- The Port: is 3306

- The Username: is your Powweb username

- The Password: is your Powweb password

That should do it, hope it helps :)

~bud

[ashary]

i am connecting, by the way, thru a LAN connection. i can establish a connection when using direct internet connection but not via a LAN.

is there a way i can connect to my database thru a LAN connection?

[Bud]

hmmm, I don't know, I only have Mascon on my main machine, I haven't tried to access it from any of my nodes.

Sorry Ashery, I wish I had a better answer for you :(

~bud