Current time: 03-01-2015, 05:29 AM Hello There, Guest! (LoginRegister)

Post Reply 
MySQL DB - information_schema
05-17-2006, 03:30 PM
Post: #1
MySQL DB - information_schema
What exactly is this database for? Is it safe to delete?
Find all posts by this user
Quote this message in a reply
05-17-2006, 04:09 PM
Post: #2
MySQL DB - information_schema
You should not delete it. MySQL5 stores configuration information in that special database (it was done differently in MySQL4).

--------
Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code SCJESSEY97
Visit this user's website Find all posts by this user
Quote this message in a reply
05-17-2006, 06:42 PM
Post: #3
MySQL DB - information_schema
Is there any way to hide it or prevent other users from accessing it? I don't want it accidently deleted or anything.
Find all posts by this user
Quote this message in a reply
05-17-2006, 07:11 PM
Post: #4
MySQL DB - information_schema
Quote:Is there any way to hide it or prevent other users from accessing it? I don't want it accidently deleted or anything.
I am not aware of a way to hide it. I would have thought it would be difficult to accidentally delete it. You would have to specifically select it in phpMyAdmin before you could delete it (complete with a yes/no message), or type "drop database information_schema", which would be hard to accidentally type!

--------
Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code SCJESSEY97
Visit this user's website Find all posts by this user
Quote this message in a reply
05-17-2006, 07:40 PM
Post: #5
MySQL DB - information_schema
I'm probably being paraoid; I just don't want some other user to possibly mess around with it.
Find all posts by this user
Quote this message in a reply
05-18-2006, 04:47 AM
Post: #6
MySQL DB - information_schema
Quote:I'm probably being paraoid; I just don't want some other user to possibly mess around with it.
That can only happen if you give someone else your MySQL hostname, username, and password.

--------
Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code SCJESSEY97
Visit this user's website Find all posts by this user
Quote this message in a reply
05-18-2006, 05:31 AM
Post: #7
MySQL DB - information_schema
The tables in the database are read only so they will not get deleted or altered until the host is removed.

This is what the manual has to say:-

"In effect, we have a database named INFORMATION_SCHEMA, although the server does not create a database directory with that name. It is possible to select INFORMATION_SCHEMA as the default database with a USE statement, but it is possible only to read the contents of tables. You cannot insert into them, update them, or delete from them."

--
Norm

Opinions are my own views and are not the views of DreamHost.
Any advice offered by me should be acted upon only at your own risk.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: