How to grant a user permission to create, insert, update, delete and create temporary tables from localhost
- برمجة سي كيو ال 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@localhost identified by 'mypassword';
flush privileges;أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال