derp1
New Member
Posts: 2
|
Post by derp1 on Nov 5, 2012 19:51:28 GMT -5
I am encountering the following error whenever I try to insert data on the server.
Query not exec: INSERT command denied to user 'ug33'@'starfire1' for table 'Topics'
Do we have permission to make inserts?
|
|
|
Post by domalley on Nov 5, 2012 20:21:54 GMT -5
if you're trying to insert with monitor or in your php code, make sure you specify that you're using the database named after your ug#. in monitor, command is: use your_ug#; In php code, you have to specify your database as your_ug# in the connection code.
|
|
|
Post by Bob P on Nov 5, 2012 20:34:49 GMT -5
Checking with sysadmin on your acct ... If you run SHOW GRANTS; it should display the command that was used to give you access and if it says something like GRANT ALL PRIVILIGES ON *.* to 'your username' than you are good Bob
|
|
derp1
New Member
Posts: 2
|
Post by derp1 on Nov 5, 2012 21:08:17 GMT -5
Resolved.
DB reference error from localhost DB name and remote DB name.
|
|