Cannot INSERT into database on a shared server

Posted on

Question :

I have launched an application on a shared server but I cannot INSERT any data. I thought maybe I don’t have privileges so I did SHOW GRANTS in my application then die()

The result was [ EDITED ]:

  [Grants for gigfa_11863212@%] => GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `gigfa_11863212_life_journal`.* TO 'gigfa_11863212'@'%'
  [Grants for gigfa_11863212@%] => GRANT USAGE ON *.* TO 'gigfa_11863212'@'%' IDENTIFIED BY PASSWORD '*78839FD7FF9639FB72CCB5E9D8BCD81A7A0A9E3D' WITH MAX_QUERIES_PER_HOUR 80000 MAX_UPDATES_PER_HOUR 60000 MAX_CONNECTIONS_PER_HOUR 20000

Why do I get the following error message when I issue an INSERT statement?

< INSERT command denied to user ‘user’@’host’ for table ‘table’ >

Answer :

You have granted usage to user@% but all other things to usr@%.

I am totally stupid …

I my entire project which designed and developed locally and code-line’s count reaches about 15000 lines, I just mentioned my local database JUST one time in my entire project! and see the result of that!!! I have been down for this about 24 hours!

Thank you all guys for trying to help


Leave a Reply

Your email address will not be published. Required fields are marked *