Welcome to the JaguarPC Community
JaguarPC
Sales: (888) 338-5261
Support: (888)-551-3050
Results 1 to 2 of 2

This is a discussion on [Newbie] MySQL & users in the VPS & Dedicated forum
Another VPS question (Hope all this doubts help other users too) The only way I find to use MySQL databases (created in Plesk) is to ...

  1. #1
    JPC Member
    Join Date
    May 2006
    Posts
    26

    [Newbie] MySQL & users

    Another VPS question (Hope all this doubts help other users too)

    The only way I find to use MySQL databases (created in Plesk) is to create a user for every single database I use.

    Is there a way to assign a user to more than one db? So I don't have to create an remember different users to each db

    Thanks in advance...

  2. #2
    cef
    cef is offline
    JPC Member
    Join Date
    Apr 2006
    Location
    NYC
    Posts
    16
    I've never used Plesk so I don't know what it's created inside of MySQL, but you can use the mysql GRANT function to change access rights to databases.

    Log in to mysql as root or admin or someone with "full" privileges, and execute this command:

    GRANT ALL ON db_name.* TO user_name

    (of course you will need to use real information for db_name and user_name)

    This will give the user "user_name" full read/write access to the database named "db_name".

    For reference, here's the GRANT syntax page in the mysql docs:

    http://dev.mysql.com/doc/refman/4.1/en/grant.html

    Hope this helps.

Bookmarks

Posting Permissions

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