03.01.2019, 03:56
Uncheck "All Privileges" and check only necessary ones.
https://dev.mysql.com/doc/refman/5.7...-provided.html
You can apply it for specific user, or for specific database
If you are using phpMyAdmin: Enter as your root/admin database user (user that have privilege to change or grant another user's privilege), Click on the database, select "Privileges" tab, click "Edit User Privileges" next to the user name in the list.
But if you want to change the privileges globally (all database), click home icon, click users, then click "edit user privileges" next to the user name in the list.
Note: It's recommended to set your database privileges per user per application only, example for "samp_server" user, you block everything from other database, and only allow your sa-mp server database, with selected privileges as ****** suggested, or to be actual, what the script needs. It is just to minimize the risk in case your database/user is hacked.
https://dev.mysql.com/doc/refman/5.7...-provided.html
You can apply it for specific user, or for specific database
If you are using phpMyAdmin: Enter as your root/admin database user (user that have privilege to change or grant another user's privilege), Click on the database, select "Privileges" tab, click "Edit User Privileges" next to the user name in the list.
But if you want to change the privileges globally (all database), click home icon, click users, then click "edit user privileges" next to the user name in the list.
Note: It's recommended to set your database privileges per user per application only, example for "samp_server" user, you block everything from other database, and only allow your sa-mp server database, with selected privileges as ****** suggested, or to be actual, what the script needs. It is just to minimize the risk in case your database/user is hacked.