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
view_create_and_delete_mysql_users [2016/08/03 07:59] walkeradminview_create_and_delete_mysql_users [2016/08/27 18:39] (current) – [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.1470211166.txt.gz · Last modified: (external edit)