User Tools

Site Tools


docu:csheet:sysadm:db:my:create_user

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

docu:csheet:sysadm:db:my:create_user [2020/02/10 10:24]
admin created
docu:csheet:sysadm:db:my:create_user [2020/02/10 10:28] (current)
admin
Line 8: Line 8:
 CREATE USER 'newuser'@'127.0.0.1' IDENTIFIED BY 'password'; CREATE USER 'newuser'@'127.0.0.1' IDENTIFIED BY 'password';
  
 +GRANT USAGE ON *.* TO 'newuser'@'localhost';
 GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
 GRANT ALL PRIVILEGES ON db.table TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON db.table TO 'newuser'@'localhost';
 </code> </code>
  
docu/csheet/sysadm/db/my/create_user.1581330291.txt.gz · Last modified: 2020/02/10 10:24 by admin