creating sql databases for users

Discussion in 'MySQL' started by TheHumaNetwork, Jun 26, 2008.

  1. #1
    is there a way how to give my clients sql databases? i was trying to use phpmyadmin and they can easily view my databases
     
    TheHumaNetwork, Jun 26, 2008 IP
  2. TheHumaNetwork

    TheHumaNetwork Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i would like to create sql users with there own databases and not showing the root users databases or not other sql users
     
    TheHumaNetwork, Jun 26, 2008 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Create a mysql user in phpMyAdmin and give it access to some databases. Create a separate installation of phpMyAdmin and in the configuration provide that mysql user and password. It will display only allowed databases in phpmyadmin. In this way, you have to create a separate installation for each user.
     
    mwasif, Jun 26, 2008 IP