pick1e Posted August 11, 2010 Posted August 11, 2010 Hi all, maybe a mysql guru can answer this for me, but I see in my "databases" list on a brand new server "information_schema" and "mysql". I know "information_schema" is system info (do not touch) but I've never seen "mysql" database before. Same here? Maybe an addition for a newer version? Thanks for any input. -------------------------------- Justin osC is awesome. Thanks everyone.
web-project Posted August 11, 2010 Posted August 11, 2010 mySQL default databases? don't use original default database, as this database is used for storing information like usernames, passwords and privileges for other mysql databases. Simply create new mysql database and use it. Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you.
pick1e Posted August 11, 2010 Author Posted August 11, 2010 don't use original default database, as this database is used for storing information like usernames, passwords and privileges for other mysql databases. Simply create new mysql database and use it. I knew that about "information_schema" but I was curious about "mysql" because I'd never seen it before. And I don't find any reference to it in documentation, mostly because searching for "mysql" database doesn't yield any useful results :) -------------------------------- Justin osC is awesome. Thanks everyone.
MrPhil Posted August 12, 2010 Posted August 12, 2010 Is "mysql" a database itself, or just a random file? If your host permits you multiple databases, the safest course would be to create a new database for your store, and leave this existing one alone. If you're forced to put everything in one database "mysql", browse it in phpMyAdmin to see what tables are already in it, and look at the oscommerce.sql file to make sure there are no conflicts with the existing tables. Your host should be able to tell you what "mysql" is for.
pick1e Posted August 17, 2010 Author Posted August 17, 2010 Is "mysql" a database itself, or just a random file? If your host permits you multiple databases, the safest course would be to create a new database for your store, and leave this existing one alone. If you're forced to put everything in one database "mysql", browse it in phpMyAdmin to see what tables are already in it, and look at the oscommerce.sql file to make sure there are no conflicts with the existing tables. Your host should be able to tell you what "mysql" is for. mysql is a database. So is information_schema, phpmyadmin_zBlwfT8eZt, and psa. They all look like they have configuration type data in them. I have full control of the server. Of course I have made a separate database for osc. I'm just a curious cat, and hadn't seen them before on previous servers. I'm nervous about anything I don't know about :) I also don't remember seeing the last two even on the current server before... I remember seeing information_schema on most servers, mysql on this server, but not the other two until today. Weird, maybe I will have a new database each day like a little gift? -------------------------------- Justin osC is awesome. Thanks everyone.
MrPhil Posted August 17, 2010 Posted August 17, 2010 You're growing new databases, and have no idea where they're coming from? That doesn't sound good. I would have a chat with the hosting service to see if they have any idea what's going on. You want to be sure that your hosting account hasn't been compromised and some hacker is "borrowing" your account to run a database for his purposes. The use of some features in your site control panel may explain some of the databases (phpmyadmin_* is presumably something to do with phpMyAdmin). If your host can't explain the extra databases, and you haven't installed any applications that might use these databases ('psa' I have no idea), you might back them up and delete them. At the very least, browse the mystery databases and see if there's anything suspicious in them. If you see a bunch of Russian (.ru) domains, or account names and passwords, or stuff like that, that have nothing to do with your legitimate business, you want to deal with it ASAP. Change all your passwords, too, in case it is a hacker, and scan your PC for spyware (keystroke loggers and password sniffers). Try using an SSL connection to access your account control panel and FTP, in case someone snooping on your connection is grabbing passwords.
pick1e Posted August 18, 2010 Author Posted August 18, 2010 You're growing new databases, and have no idea where they're coming from? That doesn't sound good. I would have a chat with the hosting service to see if they have any idea what's going on. You want to be sure that your hosting account hasn't been compromised and some hacker is "borrowing" your account to run a database for his purposes. The use of some features in your site control panel may explain some of the databases (phpmyadmin_* is presumably something to do with phpMyAdmin). If your host can't explain the extra databases, and you haven't installed any applications that might use these databases ('psa' I have no idea), you might back them up and delete them. At the very least, browse the mystery databases and see if there's anything suspicious in them. If you see a bunch of Russian (.ru) domains, or account names and passwords, or stuff like that, that have nothing to do with your legitimate business, you want to deal with it ASAP. Change all your passwords, too, in case it is a hacker, and scan your PC for spyware (keystroke loggers and password sniffers). Try using an SSL connection to access your account control panel and FTP, in case someone snooping on your connection is grabbing passwords. Well, I did find that "psa" is apparently configuration info for Plesk control panel. That makes more sense. And I assume phpmyadmin_lkajsdlkfj is likewise used by phpmyadmin. I've browsed through both and they look like plain old boring config stuff. So I guess I won't worry about them. I've had a virtual dedicated server on Windows with an older version of plesk for several years, so maybe this version is just not hiding some of the stuff that's hidden by the older plesk. -------------------------------- Justin osC is awesome. Thanks everyone.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.