I'm trying to use mysql on our shared virtual server. I created a user in cpanel and gave them permission on the database in cpanel. when I tried to run the follwing mysql code from phpmyAdmin I get the following error:
Access denied for user: 'myusername@localhost' to database 'databasename'
The script is from the book PHP and MySQL Web Development. They have created a table called writers. It has three columns, username, password and fullname. This and the rest of the mysql stuff went into the database fine, but it threw up on the GRANT stuff as Dana noted previously. Here's the lines it threw up on:
GRANT select, insert, update, delete
ON username_content.*
TO username_mgr@localhost identified by 'password';
GRANT all ON username_content.* to username_mgr@localhost;
I'm not sure what it's looking for. I DID check at the mySQL site, but don't understand half of what they say (no fault of their's...I'm really not a programmer).
I don't know what to do so that I don't get this error...
Thanks for any ideas. Thanks for your time....
