Database connect with OScommerce

[mdoo]

I'm finally wading into the Ecommerce thing and have decided to try OScommerce 2.1. I'm also new to databases. I'm getting "Unable to connect to database server". Here's a section in the config file in OScomm:

// define our database connection
define('DB_SERVER', 'exchange');
define('DB_SERVER_USERNAME', 'myusername');
define('DB_SERVER_PASSWORD', 'password');
define('DB_DATABASE', 'markdoo_testcartdb');
define('USE_PCONNECT', 1);

I set up a MySql and created a new user and password and entered that info as well as the database name. I don't know what "DB_SERVER" or "USE_PCONNECT" is. What should I have there?

Is there a length limit on usernames as it appears to have cut mine off (it added "markdoo_" to the username I input and then dropped the last two letters. Or so it appears.)

Mark-

[mdoo]

Thanks for the help. That did get me a connection to the database but then all I got was a page loaded with error messages. Other messages here have revealed that no one knows how to fix those.

So I downloaded 2.2 and I'm trying to install it. It has an installer built in that's run from the directory via a browser. After filling in the necessary install info I get a message like this:

A test connection made to the database was NOT successful.
The error message returned is:
Access denied for user: 'markdoo_testuser@64.21.178.99' (Using password: YES)

I tried "localhost" and my IP for etomicpower: 64.21.178.96, and for callisto 64.21.178.99.

When I create a user such as testuser for the databae, it adds my root username "markdoo_" to the front. I've tried it with and without. No go.

The url to the install page:
http://www.etomicpower.com/catalog/install/install.php

It fills in everything except the database stuff correctly.

Database name: markdoo_testcart2
user: markdoo_testuser
Pass: testuser

Any Ideas here?

Also, there is this note: "If the catalog is to be imported (selected above), the account used to connect to the database server needs to have Create and Drop permissions."

Mark-