#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    2
    Rep Power
    0
    I'm still fresh with Mysql, pls advise me.
    Suppose I have 2 domins in my host such www.aa.com and www.bb.com . And now I've connected them with the same user and password (Admin Password).
    But I would like to use the individual password and username for each domain, Because I've afraid of the big mistake. If there is someone know the admin's password, may he will destroy all databases that I have.
    Could you let me know how I can create individual username and password for each domain ?

    I've tried to find the information in this case but I still failed. Could you explain and give me a bit example?
    Thank you very much.
  2. #2
  3. No Profile Picture
    Carpe Diem
    Guest
    Devshed Newbie (0 - 499 posts)
    grant all on database.* to user@localhost identified by 'password';

    so it would be something like

    grant all on aadb.* to aauser@localhost identified by 'aapass';

    grant all on bbdb.* to bbuser@localhost identified by 'bbpass';

    That should do it

    Regards
    Darren
    http://www.php4hosting.com/ $ http://www.php4hosting.co.uk/
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    2
    Rep Power
    0
    Yeh!! successfully...
    Thank you very much for your knidness.

Similar Threads

  1. MySQL password problems NOT root
    By braveheart in forum MySQL Help
    Replies: 2
    Last Post: February 15th, 2004, 08:18 AM
  2. Authentication System
    By ThundaCat in forum PHP Development
    Replies: 5
    Last Post: January 31st, 2004, 01:32 PM
  3. Replies: 1
    Last Post: January 30th, 2004, 02:10 AM

IMN logo majestic logo threadwatch logo seochat tools logo