Mysql Error
#7

Quote:
Originally Posted by JohnRastion
Посмотреть сообщение
and what's methode to fix that problem
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.
Reply


Messages In This Thread
Mysql Error - by JohnRastion - 02.01.2019, 16:58
Re: Mysql Error - by Heress - 02.01.2019, 17:20
Re: Mysql Error - by JohnRastion - 02.01.2019, 17:25
Re: Mysql Error - by Heress - 02.01.2019, 17:30
Re: Mysql Error - by JohnRastion - 02.01.2019, 17:40
Re: Mysql Error - by JohnRastion - 02.01.2019, 17:43
Re: Mysql Error - by RoboN1X - 03.01.2019, 03:56

Forum Jump:


Users browsing this thread: 1 Guest(s)