MySQL That Extra Database: Difference between revisions

From The Uniform Server Wiki
Jump to navigation Jump to search
(New page: <span id="top"></span> <div style="padding:0;margin:0; border-bottom:3px inset #000000"> {| | MPG UniCenter || [[MySQL separate user accounts | MySQL user acc...)
 
mNo edit summary
Line 1: Line 1:
<span id="top"></span>
{{Uc nav mysql}}
<div style="padding:0;margin:0; border-bottom:3px inset #000000">
{|
|[[Image:uc_small_logo.gif | MPG UniCenter]] ||
[[MySQL separate user accounts | MySQL user accounts]] | 
[[MySQL Console | MySQL Console]] | 
[[MySQL phpMyAdmin | MySQL phpMyAdmin]] | 
[[MySQL That Extra Database | MySQL Extra Database]] |
[[MySQL Lost Password | MySQL Lost Password]]
|}
</div>
{| cellpadding="2"
|
__TOC__
||
'''MySQL information_schema database''' - That extra database  
'''MySQL information_schema database''' - That extra database  
|}
 
== Extra database ==
== Extra database ==



Revision as of 22:30, 2 August 2008

MySQL: General information.

MySQL information_schema database - That extra database

Extra database

After creating a new user with access to only one database, you discover to your horror an extra database named information_schema. You try to remove it to no avail what is it and has your system been compromised.

No threat

Relax it poses no threats the information schema is a comprehensible, rich source of metadata. It was first introduced in MySQL 5.0.02? (Uniform Server 3.5-Apollo current version is MySQL 5.0.41). MySQL automatically populates the database.

Current user only

The information_schema database is accessible to every user. MySQL populates it dynamically to contain only the metadata for those objects that are accessible to the current user. You should not attempt to manipulate its structure because of its virtual nature.

Read only

It does not support addition, deletion or modification of data. Direct manipulation of the data contained within it is out of bounds so do not even think about it unless you really do know what you are doing.

Stable

You can rely on the information schema database structure to remain stable because of its tight specification and adherence to the SQL standard. If you ever need to obtain metadata in MySQL, this is the place to obtain it.

Conclusion

You can’t remove it so use it.

Top


Ric