xProteuSx Posted January 28, 2008 Share Posted January 28, 2008 I have been gone for about 3 weeks and upon coming back I have discovered that there is now a 'mystery' database on my website. It is entitled 'information schema' and contains 17 tables. Does anyone know what the hell this is, and what it does? What can I do to prevent it? Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/ Share on other sites More sharing options...
effigy Posted January 28, 2008 Share Posted January 28, 2008 http://dev.mysql.com/doc/refman/5.0/en/information-schema.html Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451584 Share on other sites More sharing options...
xProteuSx Posted January 28, 2008 Author Share Posted January 28, 2008 I'm sorry Effigy, I can't figure out what this is. Can you please take a minute to spell this out for my in layman's terms? I really don't know what I am into here. Have I been hacked? If so, what is this hack capable of doing? Can I get a tool to scan my site so that I can find the hole in my security? I really cannot have this happen again. I have worked really hard to write the code for my site. I would be devastated if it was destroyed. Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451596 Share on other sites More sharing options...
effigy Posted January 28, 2008 Share Posted January 28, 2008 Take a deep breath and read the first few paragraphs from the link, would you? Also, notice that this database is documented on the MySQL website; thus, highly reducing the assumption that it's a hack Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451599 Share on other sites More sharing options...
xProteuSx Posted January 28, 2008 Author Share Posted January 28, 2008 Effigy ... lol ... I'll try to take in some deep and consistent breaths. Being that I am very new to all this, but have been hacked a few times before, I am very uncomfortable with the idea of the appearance of mysterious files and/or databases. I do see that it is on the official MySQL site, and it doesn't sound threatening, but why does it pop up now? Did I trigger it, or is it an automated thing? Usually, if something on a website changes, I assume that someone made it change. And since it wasn't me ... (or at least I don't think it was). Thanks for you help. I love these boards. Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451604 Share on other sites More sharing options...
effigy Posted January 28, 2008 Share Posted January 28, 2008 Perhaps you missed it before? Did MySQL go through any updates or permission changes? Also, allowing your application user to create databases is a big deal. Make sure this user has very limited permissions: SHOW GRANTS FOR user@host; Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451629 Share on other sites More sharing options...
fenway Posted January 28, 2008 Share Posted January 28, 2008 Sounds like an DB upgrade to 5.0... shouldn't have happened without your knowledge. Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451641 Share on other sites More sharing options...
xProteuSx Posted January 29, 2008 Author Share Posted January 29, 2008 Effigy and Fenway. Thanks for your help. I am just amidst finding out, from my host, if there have been any updates to MySQL. I am starting to lean to that direction. Thanks again. Quote Link to comment https://forums.phpfreaks.com/topic/88255-solved-what-are-information-schema-tables/#findComment-451773 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.