stupid LOCK TABLES message with MySQL - please help!

[CircleOfLinks]

Hi,

im having a major problem with my site, as soon as it finally starts to take of and gets heaps of traffic i've had to change my site to a new server.

I've transfered the whole site accross but im getting this following message:

Error
SQL query:

--
-- Dumping data for table `featured`
--
LOCK TABLES `featured` WRITE
MySQL said:

#1044 - Access denied for user 'w0010'@'localhost' to database 'aussiepages_com_au_database'

Please if someone has any idea on what I can do I would really appreciate it. Im trying to upload my backup database by going to myphpadmin selecting the database and clicking on SQL then browse and upload...

Please help really urgent.

thanks heaps

[megamoose]

Are you using cPanel? IF you are make sure in the cPanel you have added the user to the database, as you would get the above error message if the user doesn't have any access to the database.

If you don't use cPanel then you'll need to use phpMyAdmin and manually add the user to the database through the privallages tab.

Mark

[CircleOfLinks]

Hi Mark,

Im using myphpadmin and I cant find the privlige tab, where would it be? im using MySQL 5.0.27

thanks heaps

[megamoose]

Have a look at the screenshot below.




I also take it you aren't using cPanel? If you are the cPanel won't have the privileges tab.

Mark

[CircleOfLinks]

Hi mark, i dont have that option on my screen. ive attached a screen shot of what comes up when i login to myphpadmin

[CircleOfLinks]

Hi thanks

all sorted now