Page 1 of 1

rookie with databases struggling with connection

Posted: Fri Feb 12, 2010 8:31 pm
by Wally
I have an account on on-rev and have successfully created a database with 1 Table using the cpanel and phpMyAdmin.

I have added myself as a user with a password. I used the cpanel's Remote MySQL to set the access priveledges to "%" so "any" body is supposed to connect remotely? I'm using Sarah's TrozWare to make a connection to my database with no luck.

I connect using the TrozWare to the runrev site:
database name : "test"
login : "example"
pwd : "example"
address : "runrev.com"

but I can't connect to my database after having tried every address imaginable. The error message says access denied for me@cpe-.... (using password: Yes.) What is a typical address for a database on on_Rev?

Re: rookie with databases struggling with connection

Posted: Fri Feb 12, 2010 11:38 pm
by RRobert
I dont use On-Rev but which address is shown in phpMyAdmin?

Robert

Re: rookie with databases struggling with connection

Posted: Sat Feb 13, 2010 1:32 am
by bangkok
Wally wrote:I have an account on on-rev and have successfully created a database with 1 Table using the cpanel and phpMyAdmin.

but I can't connect to my database after having tried every address imaginable. The error message says access denied for me@cpe-.... (using password: Yes.) What is a typical address for a database on on_Rev?
First check the revOpenDatabase, and use the IP address of your on-rev site.

put revOpenDatabase("MySQL","75.xx.xx.xx",dbName,dbUser,password) into dbID

Then be sure in cpanel to create the dbUser and then to add the dbUser... to your database.

https://odin.on-rev.com:2083/frontend/x3/sql/index.html

Re: rookie with databases struggling with connection

Posted: Sat Feb 13, 2010 1:45 am
by Wally
Thanks everybody! I got a connection.

The cpanel tripped me up and added additional text to my username after I clicked create user. There is a field saying "*Seven characters max" next to the field where one creates the username so I continued to use the username which obeyed the 7 chars limit, not the one cpanel created.

My fault!