view_create_and_delete_mysql_users
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
view_create_and_delete_mysql_users [2016/08/03 08:59] – walkeradmin | view_create_and_delete_mysql_users [2016/08/27 19:39] – [To Create a New User with all Privileges and a Password] walkeradmin | ||
---|---|---|---|
Line 17: | Line 17: | ||
SELECT user, host FROM mysql.user; | SELECT user, host FROM mysql.user; | ||
\\ | \\ | ||
- | | + | ==== To Create a User ==== |
| | ||
CREATE USER ' | CREATE USER ' | ||
Line 29: | Line 29: | ||
GRANT ALL PRIVILEGES ON * . * TO ' | GRANT ALL PRIVILEGES ON * . * TO ' | ||
\\ | \\ | ||
- | | + | ==== To Create a New User with all Privileges and a Password ==== |
+ | GRANT ALL PRIVILEGES ON mydb.* TO ' | ||
+ | \\ | ||
+ | ==== To Delete a User ==== | ||
| | ||
DROP USER ' | DROP USER ' |
view_create_and_delete_mysql_users.txt · Last modified: 2023/03/09 22:35 by 127.0.0.1