MySQL Connection with ASP

Difficulty to connecting MySQL through ASP with ADODB Connection

[guruetech]

Hi I have facing problem to connecting MySQL through ASP.

Following is the connecting string I am using :

strConnect = "Driver={MySQL}; Server=localhost; Database=mydbname; User=myuid; Password=mypwd;"

Following is the error:

ADODB.Connection.1 (0x80004005)
SQLState: S Native Error Code: 1045 [TCX][MyODBC]Access denied for user 'root'@'localhost' (using password: YES)

do you have any idea to resolve this problem. I feel that there is problem with server using permission. But I have already given all permission to that user.

Thanks

[txbakers]

Most likely it's not a Windows permission error,but a mysql permission error.

Be sure you create a user in your database with full rights.

[guruetech]

Hi txbakers

Thanks for your suggestions but I have already given all permission to the user. I don't understand what's going wrong.

Thanks

[webdoctor]

I have already given all permission to the user

MySQL permissions need you to get the hostname right too.

Have you given permission for the user to log in from 'localhost'?