How to grant a user permission to create, insert, update, delete and create temporary tables from any host
- برمجة سي كيو ال sql
- 2021-09-02
- mhanasmh00489829403
الأجوبة
Syntax :
grant [<permission_1,permission_2,...permission_n>|<all>]
on [database].[<table_name>|<all_tables(*)>]
to [user name]@[<localhost>|<IP address>|<any host('%')>]
identified by ["password"];
Example :
grant select, create, insert, update, delete, create temporary tables on posts.*
to amit@'%' identified by 'mypassword';
flush privileges;أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال