MySql Insert doesn't work when the website deployed on the host!

Question

I'm using XAPP under windows and my website just working well!

when I deployed it on the host server, it seems to be working normally, but the insert requests to MySql doesn't have any effect, nothing is changing on the database!

Does anyone had this issue before? is there any configuration in MySql to make it accept insert requests? or simply whats the best way to make it work!

[EDIT]

I use PhpMyAdmin, I have two tables members and notifications, I wanna configure permissions so I can Insert into the notifications table, any hint please?

thank you

Answer 1

check the permissions on the database server for the username and password that you are using. It can also be restricted by IP address, among others.

Answer 2

Indeed, the administrator can set read-only privileges for a user or for a specific table. Check out the "grant" command for more information.

Answer 3

it would be helpful if you could find out the error message that MySQL is returning. check your web server log files. if you are using some shared hosting plan, there should be an option in your host control panel to see the web server log files. PHP is configured in most places so that error messages are stored in web server log files. find out what is actually happening there. it could be permissions most likely.