Hello. I have just created a new database with easy to remember passwords. The hostname used to reach the database has already propegated, so I am able to use PHPmyAdmin to configure it. I have added two tables, “student” and “faculty” with the appropriate structures. (name, homeroom etc.)
I have already set up a user for this database, but in my PHP script, I am unable to add to the database tables. I get the error:
INSERT command denied to user ‘parking_permit’@‘apache2-zoo.greenlantern.dreamhost.com’ for table ‘student’
However, in the control panel, the user “parking_permit” has every privilege checked off with no exceptions. This is all vanilla, but I can’t seem to insert any rows. What is the problem?