privileges – Email shop Community https://theemailshop.co.uk/community Wed, 04 Dec 2019 05:50:53 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 How to add new user to a database and add some privileges? https://theemailshop.co.uk/community/knowledge-base/how-to-add-new-user-to-a-database-and-add-some-privileges/ Wed, 04 Dec 2019 05:50:53 +0000 https://theemailshop.co.uk/forum/?post_type=epkb_post_type_1&p=1198
  • Sign in to the cPanel account.
  • Click on the icon ‘MYSQL databases’ in the database section

    • mysql-databases-icon

    • Scroll to the bottom of your page and find ‘add a user to database’, choose a relevant user from the drop-down list and then select the required database.
    • Click on the ‘Add’ button

    add-db

    • You will find ‘manage user privileges’, then mark the box ‘add privileges’ click ‘make changes’

    add-privileges

    ]]>