Securing mySQL database

Discussion in 'MySQL' started by robert4442, Apr 29, 2008.

  1. #1
    I wrote a script in php that accesses a mySQL database. The database has a table that contains email addresses. If I google one of the email addresses I come up with the following:
    phpMyAdmin
    3, jamesbakertpa@yahoo.com, Mr. Baker. Edit • Delete, 176, Bob.Shaye@newline.com, Robert, Shaye. Edit • Delete, 177, Michael.Lynne@newline.com, Michael ...
    http://www.florida-family.org/phpmyadmin/sql.php?lang=en-utf-8&server=1&collation_connection=utf8_genera... - 67k - Cached - Similar pages


    This search is going right into my database and pulling info from it. I googled another email and it gave me all the emails in the database. My IPS is telling me that I must secure the data thru my web code. Can you help me. I don't know exactly what I need to do to secure this info?
     
    robert4442, Apr 29, 2008 IP
  2. CreativeClans

    CreativeClans Peon

    Messages:
    128
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You've got a problem for sure. Everybody can get into your phpmyadmin and do all they want with your DB?
    Did you install it yourself? In that case you might visit the phpmyadmin site and look for answers there.
    I can't help you. Never installed phpmyadmin or mysql myself anywhere.
     
    CreativeClans, Apr 30, 2008 IP
  3. eric_basher

    eric_basher Peon

    Messages:
    185
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    make sure to give protection into the script,can use whit .htaccess ,also check the META stuff ,google/yahoo bot will check you site header to put on search engine.
     
    eric_basher, Apr 30, 2008 IP
  4. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,825
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #4
    Are you using root access for all your scripts? Do check in the phpmyadmin if the users privileges are local to the database or global.
     
    wisdomtool, Apr 30, 2008 IP
  5. MattC1983

    MattC1983 Peon

    Messages:
    71
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Deleted post, misread original question... :\
     
    MattC1983, Apr 30, 2008 IP
  6. Whippet75

    Whippet75 Well-Known Member

    Messages:
    1,599
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    155
    #6
    Whippet75, May 1, 2008 IP