MySQL connection problems

[warrenize]

Hi All -

I'm stumped. I created a MySQL user (bruce) and database (calendar) under localhost.

When I browse to escalInstall.php on my server, I get error messages. I've modified everything in every conceivable way, but keep getting errors.

ERROR message from last attempt:

* There was an error connecting to the database.

Please check the settings in the 'escalDB.php' file and try again.

The error was reported as:
Access denied for user: 'amammoth_bruce@localhost' to database 'amammoth_calendar'


Here is my escalDB.php configuration:

// SET DATABASE CONNECTION IF USING SQL EVENTS
$dbHost = "localhost";
$dbUserLogin = "amammoth_bruce";
$dbPassword = "******";
$dbName = "amammoth_calendar";

ANY HELP is appreciated. I've run out of ideas.
Thanks
warren

PS: possibly I have to create a table for the DB??

[Brian]

Is this your server or are you on a shared server?

How did you create the user amammoth_bruce?

[warrenize]

It is a shared server.

In my domain control panel (CPanel) using the regular MySQL setup (Not PHPMyAdmin), I added the user first, then added the database by simply entering the name bruce and calendar respectively. The system added amammoth_ to the names automatically.

I also tried creating another host aside from localhost. I also created a second user without a password. Everything I tried came up with varing error messages.

warren

[warrenize]

I got it working! User error - I had the user and database created but I hadn't added the user to the db.
Sorry for the confusion and thanks for your help.
warren

[Brian]

Glad you got it working!