HELP - Error message when trying to log into MySQL - Solved

[DR White]

I used the MySQL Database wizard to setup database and user name.
I have the following Connect Button script:

on mouseUp
  -- use a global variable to hold the connection ID so other scripts can use it
    global gConnectionID
    
    -- set up the connection parameters - edit these to suit your database
    --put "runrev.com" into tDatabaseAddress
   -- put "runrev_test" into tDatabaseName
   -- put "runrev_example" into tDatabaseUser
   -- put "example" into tDatabasePassword
    ----drwhite.on-rev.com
----- drwhite_Test_1
----drwhite_drw10

    put "drwhite.on-rev.com" into tDatabaseAddress
    put "drwhite_Test_1" into tDatabaseName
    put "drwhite_drw10" into tDatabaseUser
    put "XXXXXXXX" into tDatabasePassword




    -- connect to the database
    put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
    
    -- check if it worked and display an error message if it didn't
    -- & set the connection ID global
    if tResult is a number then
        put tResult into gConnectionID
        answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
    else
        put empty into gConnectionID
        answer error "Unable to connect to the database:" & cr & tResult
    end if
end mouseUp


I have checked these things and my password at least 20 times, but I keep getting the error below:

Unable to connect to database
Access denied for user.
.........
(Using Password:YES)


What could I be doing wrong?

Thanks,

David

[A1Qicks]

What was your solution? I don't have this problem but I am curious.