User database permissions

Discussion in 'Server Operation' started by Barragán Louisenbairn, Jan 26, 2021.

  1. Hello again:
    It's normal that the database user from an user has the permits to use all the databases? Or maybe it's my error and I must learn how to create users? (maybe using only the ISPConfig user instead the ISP admin user...?)

    GRANT USAGE ON *.* TO `user_test`@`localhost` IDENTIFIED BY PASSWORD '*XXXXXXxxxxXXXXXxxXXXXXXXXXXxxxxxxx' |
    | GRANT ALL PRIVILEGES ON `user_test`.* TO `user_test`@`localhost`
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    It only has access to the database you assigned the user to through the panel.
     
  3. ok, thanks a lot!
     

Share This Page