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 08:59] walkeradminview_create_and_delete_mysql_users [2023/03/09 22:35] (current) – external edit 127.0.0.1
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: 2023/03/09 22:35 (external edit)