UPDATE command denied to user (myuser)@localhost for table "table

Avatar
  • updated
  • Answered

I have a problem, in my web proyect i can insert on my bd but can't update y have this error UPDATE command denied to user (myuser)@localhost for table "table

i don't understand because my user have all privileges, so...
could someone tell me why?

Pinned replies
Avatar
Alyssa K
  • Answer

Hello Jonathan,

Thank you for your reply and for providing additional information. I suggest using your account IP address instead of localhost to connect to ensure that the command is being attempted in the correct location. To find your account IP please see the following guide:

https://www.inmotionhosting.com/support/edu/cpanel/how-to-find-your-shared-ip-address-of-your-server-in-cpanel/

Please let us know if you have any further questions and we will be happy to help.

Best Regards,
Alyssa K

Avatar
Alyssa K
  • Answer

Hello Jonathan,

Thank you for your reply and for providing additional information. I suggest using your account IP address instead of localhost to connect to ensure that the command is being attempted in the correct location. To find your account IP please see the following guide:

https://www.inmotionhosting.com/support/edu/cpanel/how-to-find-your-shared-ip-address-of-your-server-in-cpanel/

Please let us know if you have any further questions and we will be happy to help.

Best Regards,
Alyssa K

Avatar
Jonathan Trujilo

i connect successfully to my bd and my user have all privileges but its strange because i can insert records from my site but i can´t update records because i have the following error " UPDATE command denied to user (myuser)@localhost for table "table"
insist, my user have all privileges update is one of them

i connect to database with name localhost , i don't know if that is a problem

Thanks fos answer

Avatar
Alyssa K
  • Answered

Hello Jonathan,

Thank you for your comment, I am happy to assist with this database issue. It would appear that the user does not have access to that database and cannot complete the query. I recommend ensuring that all database access privileges have been enabled for that user in cPanel via the following guide:

https://www.inmotionhosting.com/support/edu/cpanel/create-db-user/

Additionally, if you are connecting remotely to do this, you may need to add your IP address to the server firewall:

https://www.inmotionhosting.com/support/website/add-ip-to-firewall/

For direct assistance with this issue I recommend contacting our 24/7 Technical Support team by emailing [email protected], calling 888.321.HOST(4678), or by starting a chat session via your Account Management Panel.

Please let us know if you have any further questions and we will be happy to help. 

Best Regards, 
Alyssa K