Results 1 to 1 of 1

Thread: HOWTO: Provide a MySQL user with an additional database.

  1. #1
    Join Date
    Jun 2003
    Location
    UK
    Posts
    2,326

    HOWTO: Provide a MySQL user with an additional database.

    as with all HOWTO guides i provide i take no responsibility, any problems that are caused by following the guide are your responsibility only.



    Login To PHPMyAdmin as 'da_admin' using the first password used for DA (login at http://YOURIP/phpMyAdmin)

    On the right frame you should see something similar to: 'Create new database [Documentation]' followed by a form field.

    Type in the database name you want for the user (try to use a name that will not interfere with any accounts made by DA) Once you have typed it in, press 'create'

    Now you need to press the back button on your browser to return to the homepage.

    On the right frame, around 4 lines below the form you used to create the database, you will see a link saying 'users'. you need to click that link.

    Look for the user you want to give the additional database to, once you have found it, click the 'grants' button on the users line.

    The form should have a few form fields, you need to untick the 'Any database' radio button by selecting 'Database' just to the right. Select the database you just created from the list. You must leave the 'any table' and 'any column' selected for normal priveldges.

    Futher down the page you will see the 'Privileges' section. You need to select the following:

    select
    update
    create
    index
    insert
    delete
    drop
    alter

    complete the process by pressing the 'go' button.

    you may need to restart MySQL after doing this.

    Chris
    Last edited by ProWebUK; 10-07-2003 at 04:43 AM.
    OptimumServers » Managed Dedicated Servers & General Systems Management » Coming Soon!
    ProWebUK - Quality Web Services
    DirectAdmin Server Checklist

Similar Threads

  1. Move mysql database to another user
    By ranz in forum MySQL / PHP
    Replies: 48
    Last Post: 08-10-2015, 03:11 PM
  2. New database foro existent mysql user
    By carli in forum Scripting / API
    Replies: 2
    Last Post: 09-21-2011, 03:58 PM
  3. Create MySQL database without user prefix
    By PvanEs in forum MySQL / PHP
    Replies: 1
    Last Post: 05-04-2011, 10:27 AM
  4. Replies: 15
    Last Post: 05-16-2006, 09:09 AM
  5. MySQL optional additional users
    By Eric in forum Feedback & Feature Requests
    Replies: 14
    Last Post: 04-23-2005, 12:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •