connecting to database

[GearHead]

How can I test that I truely have a database, and how can I test connect to it?

[alphadesk]

You can dowload this free program to connect to your DB and admin DB.
http://mysqlfront.sstienemann.de/

[GearHead]

Ok.. I downloaded the software and can't connect to my database.. Am I doing this right?

Host/IP : Asteroid.powweb.com
user : username
password: password
port : 3306
Datebase: databasename

I get :
1045 - Access denied for user: 'gearhead@12-253-212-132.client.attbi.com' (Using password: YES)

[alphadesk]

Gear,try

Host/IP : asteroid.powweb.com --- not Asteroid.powweb.com
user : username
password: password
port : use default
Datebase: databasename

[GearHead]

typo in the thread.. I have been tryin asteroid.powweb.com
still cant access the DB.. I have an email into PW for assistances as well.. If ya have any more ideas, please share them..

[feilmeier]

Hello,

I'm having the same problem where I cannot connect using MySQL-Front or Mascon. I used the same settings as gearhead. I'm just wondering what gearhead had to do to solve this problem.

Thanks for the help!

Brad

[GearHead]

Not solved.. I still cant connect.. I've tried everything thats in my power.. I sent an email to powweb for some support but my email was also down, so I dont know if they replied.. HELP!!!

[feilmeier]

Hi Gearhead,

I'll see what I can do. I'll be sure to let you know if I figure something out.

Brad

[RocketJeff]

Just a point of reference, last night I downloaded/installed mySQL-Front and it connected no problem.

Make sure you have the correct username & password that you assigned to the database in OPS (and the corret database name, too). Remember, the username and password are case sensitive.

alphadesk: thanks for pointing out this excellent tool!

[GearHead]

AAHHHHHH!! Presto!!! Everything is cap sensitive!! Even the database name!! thank you RocketJeff

Anthony

[feilmeier]

Hello All,

Glad to see you got connected, Gearhead. My problem was the firewall. I was trying to connect at work. My company has a firewall that doesn't allow you to use port 3306 to connect. I came home and installed the software and had no problem connecting.

Sounds like we're all happy people.

Take care.

Brad

[hobshack]

Originally posted by GearHead
Ok.. I downloaded the software and can't connect to my database.. Am I doing this right?

Host/IP : Asteroid.powweb.com
user : username
password: password
port : 3306
Datebase: databasename

I get :
1045 - Access denied for user: 'gearhead@12-253-212-132.client.attbi.com' (Using password: YES)

Is the port 3306 the same for everyone or do different hosts (Im on calisto) have different ports? If different how would you find out what port you shoud be using?

[feilmeier]

make sure you are not capitalizing Asteroid. The logon is case sensitive. The port will always be the same on all the powweb servers. You're problem is likely the capitalization.

Brad