Invalid authorization specification

[donboe]

Hi I'm new to this forum and also quite new to Coldfusion! I'm making a control panel with a log in screen. I have this control panel and database from a working site. When I upload everything and try to log in I get the following error message:

Error Executing Database Query.
Invalid authorization specification: Access denied for user 'poliscyprus'@'localhost' (using password: YES)

The error occurred in /home/httpd/vhosts/poliscyprus.info/httpdocs/controlroom/authorise.cfm: line 6

4 : <cfelseif isDefined('form.username') AND isDefined('form.password')>
5 : <cfquery name="rsUsers" datasource=#MM_connPolcyp_DSN# username=#MM_connPolcyp_USERNAME# password=#MM_connPolcyp_PASSWORD#>
6 : SELECT * FROM users WHERE username='#form.username#' AND password='#form.password#'
7 : </cfquery>
8 : <cfif rsUsers.RecordCount GT 0>




Can anybody please help me out here.

Thanks in advance

[ccoonen]

make sure your user "poliscyprus" is created, and accessible to your table 'users'

[ccoonen]

In the database that is - your database should be also correctly defined in the DSN 'MM_connPolcyp_DSN'