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 revision		Previous revision
Last revisionBoth sides next revision
mysql:grant [2014/12/24 10:42] – external edit 127.0.0.1mysql:grant [2022/12/02 22:02] – external edit 127.0.0.1
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)