rookie with databases struggling with connection

[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?

[RRobert]

I dont use On-Rev but which address is shown in phpMyAdmin?

Robert

[bangkok]

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

[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!