Set this in both your admin/includes/configure.php and catalog/includes/configure.php files:

From:
define('STORE_SESSIONS', '');

To this:
define('STORE_SESSIONS', 'mysql');

When you create your MySQL database, first you need create a database by giving it a name. Then you create a user by entering a username and password. For best results keep your database name, database username, and database password at no fewer than 6 and no more than 7 letters or numbers. Then you make sure that you have added the user to the database.

In your script, your database name and your database username must be prefaced by your hosting account username_. Your password, however, stands alone without any prefaces.

For example: If your hosting account username is "blue5", your database name is "testdb", your database username is "dbuser", and your database password is "passwd", this is how you need to put them in your script:

database server should be: localhost
database name should be written as: blue5_testdb
database username should be written as: blue5_dbuser
database password should be written simply as: passwd

We do not allow database connections to the MySQL server from remote computers. We closed our database server remote access port due to security reasons.

So unfortunately you cannot connect from ODBC/JDBC/Macromedia DreamWeaver applications. You have to connect to your databases from your website through scripts or the cpanel phpmyadmin tool for managing your databases.

This is the reason that our MySQL server name is always: localhost