De;ete from whos_online

[accelerator]

Hi People

 

I've got through the installation procedure, but when I try and access:

 

http://www.mydomain.com/catalog/index.php

 

I get the following error:

 

-ERROR STARTS-

1044 - Access denied for user 'myuser'@'%' to database 'mydatabase'

 

delete from whos_online where time_last_click < '1140309852'

 

[TEP STOP]

-ERROR ENDS-

 

Now, I've had a look around the forums, and I understand such an error can often be corrected by deleting entries from the whos_online table. However, this table in my database doesn't have any rows in it, so I'm a bit confused.

 

Any suggestions very welcome.

 

Thank you

 

Accelerator

[accelerator]

Anybody? Come on, I know someone knows the answer! :D

 

Thanks

 

Accelerator

[♥Vger]

Access denied for user 'myuser'@'%' to database 'mydatabase'

 

should be something like:

 

Access denied for user 'myuser'@'localhost' to database 'mydatabase' using Password 'YES'

 

Sounds as though your configure.php files did not get written to by the Install programme.

 

Vger

[accelerator]

Hi Vger

 

Many thanks for your reply.

 

I found that I had not granted the MySql user enough privileges to my database. I found once I had granted the DELETE privilege to the user, the error went away. Hurrah!

 

I shall bear your comments regarding correct writing to the configure.php file in mind in case I encounter further issues.

 

Thanks again

 

Accelerator