supermanhamuerto.com

User Tools

Site Tools

Trace:
mysql:grant

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
mysql:grant [2014/12/24 10:42] – external edit 127.0.0.1mysql:grant [2021/01/15 15:26] – rlunaro
Line 6: Line 6:
  
 <code sql> <code sql>
 +mysql> create user DATABASE_USERNAME;
 mysql> grant alter, create, delete, drop, index, insert, lock tables, select, update on  DATABASE_NAME.* to DATABASE_USERNAME@'%'; mysql> grant alter, create, delete, drop, index, insert, lock tables, select, update on  DATABASE_NAME.* to DATABASE_USERNAME@'%';
 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec)
Line 15: Line 16:
  
 <code sql> <code sql>
 +mysql> CREATE USER DATABASE_USERNAME;
 mysql> grant delete, insert, lock tables, select, update on  DATABASE_NAME.* to DATABASE_USERNAME@'%'; mysql> grant delete, insert, lock tables, select, update on  DATABASE_NAME.* to DATABASE_USERNAME@'%';
 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec)