User Tools

Site Tools


view_create_and_delete_mysql_users

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
view_create_and_delete_mysql_users [2016/08/03 08:59] walkeradminview_create_and_delete_mysql_users [2016/08/27 19:39] – [To Create a New User with all Privileges and a Password] walkeradmin
Line 28: Line 28:
          
     GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';     GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';
 +\\ 
 +==== To Create a New User with all Privileges and a Password ====
 +    GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'%' IDENTIFIED BY 'password';
 \\  \\ 
 ==== To Delete a User ==== ==== To Delete a User ====
view_create_and_delete_mysql_users.txt · Last modified: 2023/03/09 22:35 by 127.0.0.1