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
cheers