User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. Create a user named joss with the password f1refly, logging in from the localhost only, with all privileges plus GRANT OPT
GRANT ALL ON duckwear.duck_sales TO joss@localhost
IDENTIFIED BY "f1refly" WITH GRANT OPTION;