SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Mysql security

  1. #1
    SitePoint Addict lmasi02's Avatar
    Join Date
    Aug 2004
    Location
    Zambia
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql security

    Hi
    I have a webserver and i run mysql database. I ve several client who have dynamic site. How can i give indvidual password to their database only?Because at the moment, they all use root password. I have phpMydmin on the server.

    Waiting for your response
    Power of Knowledge

  2. #2
    SitePoint Enthusiast
    Join Date
    Jun 2005
    Posts
    94
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Checkout the grant command
    ie
    Code:
    GRANT ALL ON mydb.* TO username@host IDENTIFIED BY 'password'


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
  •