MySql error via localhost in test environment

[RescueDog]

I'm having trouble getting my database connected thru Dreamweaver (CS5). I'm sure it's something easy that I'm overthinking! I have my server up and running but receive an error when trying to setup my database connection.

 

Any help is greatly appreciated!

 

Will post if I figure it out in case someone else encounters...

[RescueDog]

as promised:

1. Create a DB backup - this was thru cPanel on my host server and resulted in a database_backup.sql file
   
2. open PhpAdmin on your local machine
   
   1. 
      
   2. Create a new database - name it the same as what is specified in your ../config/settings.inc.php file (or make a change there)
      
   3. IMPORT the .sql file created in step 1. IMPORT via the PhpAdmin function, select the file and PhpAdmin will build your DB from that.
      

[*]open DreamWeaver

1. open ../config/settings.inc.php
   
   • Change
     
     • define('_DB_USER_', 'root');
       define('_DB_PASSWD_', '');
       

[*](you will also change define('_DB_NAME_','-------------'); if you used another name in PhpAdmin)

[*]setup your data connection using:

• Name: your choice
  
• Server: localhost
  
• User: root
  
• Password:
  
• Database --------------> click the select button and yours should show
  

I hope this helps someone in getting their testing environment established! I also grabbed XAMPP and installed it to replicate my hosts environment. It was installed with Php and MySql support.

The test environment I'm using:

• Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1
  
• MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $
  
• PHP extension: mysql
  

PS 1.4.6.2 --- which I'm a total noob at!