Could Not Connect to Database

[anne]

I installed CMSMS with no problem until I got to the page (4) - Database Information.   I have followed the instruction to install cms to the letter.  Everything was done correctly.  When I go to the install page I keep getting a
"Could not connect to database. Verify that username and password are correct, and that the user has access to the given database." message. 

I tried uninstalling my database and following the instructions to go into MySQL and create a new one, and did this at least twice, but got the same error not matter what.  I also tried to change address from "localhost" to 3306 as this is the way it is presented to me by my webhost but still got the same error.  I checked my username and password very carefully and numerous times but the errorr would not go away.

Here is the information associated with my webhosting.  (I am not real technical, so cant give exact versions of things - I couldn't find that info)    Any help would be much appreciated - I am stuck at not being able to connect to the db.

The server is on a Linux platform:
PHP 
Perl
 
CGI
 
CGI-BIN 
ASP v3 / ASP.NET v1.1 (only with Windows plans) 
Cold Fusion v5 (only with Windows plans)   
Javascript/DHTML 
ODBC/DSN (only with Windows plans)   
Override .htaccess Support (only with Linux plans) 
Server Side Includes (SSI) 
  Databases
MYSQL 100
PostgreSQL 100
Microsoft SQL 2000 (only with Windows plans)  100
phpPgAdmin 
phpMyAdmin
 
  Complimentary Scripts 
Message Forum (PHPBB2) 
Form-Mail (only with Linux plans) 
Guestbook (only with Linux plans) 
Web Counter (only with Linux plans) 
Chat 
  Ecommerce Features 
Free Shared SSL Certificate 
SSL Secure Server 
OS Commerce 
  Support Features 
Live Phone Support 
LiveChat System 
Ticket Center 
  Additional Features
Search Engine Submission 
International Domain Name Support 
Website Statistics 
Account Control Panel -   
  File Transfer
FTP Access 
Additional FTP Accounts (only with Linux plans) 
Anonymous FTP Accounts 
FrontPage 2000/2002 Extensions 
  Website Administration
FREE Professional Website Templates 
Create and Change Designs at Any Time
 
Log Files + Site Stats
 
Web File Manager
 
Publishing Program
 
Password Protected Directories (only with Linux plans)
 
Online Web Editor
 
Custom MIME Types 
Custom CRON Jobs (only with Linux plans) 
Customizable Error Pages 
  Multimedia
Flash & Shockwave Support 
MIDI File Support 
Streaming Audio Support 
Streaming Video Support 
Real Audio & Video Support 
  Security Mechanism
24/7 Monitoring 
Firewall Protection 
Spam Filter Spam Assassin 
UPS Power Back-up/Back-up Generator 
Hotlink Protection 
  Domain Management
Domain Access with or without “www” 
Domain Contact Management 
External Domains 
Parked Domains 
URL Masking (only with Linux plans) 
Add-on Domains 

[Pierre M.]

...I also tried to change address from "localhost" to 3306 as this is the way it is presented to me by my webhost...

There is miscommunication here : "localhost" is a computer name, 3306 is the standard MySQL TCP port, so there are not the same and not interchangeable. They can be combined like this : localhost:3306

You must know :
-your db host (can be "simpson", "localhost" or an IP adress like 127.0.0.1 or 192.168.0.5 or whatever)
-your db name (can be "mydb" or "cms" or whatever)
-your db user name
-your db user password
-your db port if not 3306

If your db is correctly set up and if you have these informations, please double check when you type them in the installer.

Pierre M.