Quick Help Needed - Connecting to MySQL DB

["biznet11" <webforumsuser@xxxxxxxxxxxxxx>]

(I'm new to MySQL) - I'm trying to connect to a MySQL DB (below) - in cf admin 
I tried:

 Database = TEST1
 server = localhost
 port = 8888
 user = root
 pass = root

 error = Connection verification failed for data source: house1
 java.sql.SQLException: Timed out trying to establish connection
 The root cause was that: java.sql.SQLException: Timed out trying to establish 
connection

 * I'll bet I need to create a 'normal' user tied to this DB - but I Don't know 
how...?
  
 ---

 * GEAR:  CF8 mac 10.4.10 tiger w MAMP install of php -phpMyAdmin - mysql and 
apache - working 


 I went to: 

 http://localhost:8888/MAMP phpMyAdmin 

 - and created new empty database called TEST1 
 - now I need to create a user - how do I do that? 
 - I tried to log in using using MySQL administrator APP using : 

 The MySQL Database can be administrated with phpMyAdmin. 
 To connect to the MySQL Server from your own scripts use the following 
connection parameters: 
 Host: localhost 
 [Port: 8889] 
 User: root 
 Password: root 

 but the app errored: access denied for root@localhost using password "yes" 
code 1045 

 Q: How do I create a user for this database TEST1? 
 Q: How do I restore in this database TEST1 from another backup (which I have)?