Problem with Access to database

[dani22]

Get this message when I try to Insert data into a Mysql database. I get this Message in browser:

Error in table: Access denied for user 'md7dani2_myuser'@'lotus.x10hosting.com' to database '1'

This is the code Im using:

INSERT INTO Spec (city) VALUES ('$city_menu')

I've checked in my cpanel and should have full privileges for the db Im using. It worked fine to Create the table Spec.

What's wrong, any idea?

 

[garrettroyce]

the database name should be 'md7dani2_1' if '1' is the database name you chose, similar to 'md7dani2_myuser' is for 'myuser'