I need to protect MySQL databases

Discussion in 'MySQL' started by jc@ukzone.com, Oct 10, 2007.

  1. #1
    Hi...
    I run a server with a few databases running.
    I use phpMyAdmin to administer the databases.
    Up to now only my own databases are running on the server so security was not a problem.
    However, I have a client who wants a database.
    I have setup phpMyAdmin on his own site and given him his required username and password.
    On testing:
    I can get into phpMyAdmin with his login and password.
    There is a list of all the databases for selection.
    I can choose ANY database and can access it with his login and password.

    I imagine that I have setup database permissions incorrectly, but I don't know how to rectify it so that he cannot access any databses except his own.

    Can anybody advise me?

    Thanks....
     
    jc@ukzone.com, Oct 10, 2007 IP
  2. jc@ukzone.com

    jc@ukzone.com Guest

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I've sorted this now - Thanks...
     
    jc@ukzone.com, Oct 11, 2007 IP