MySQL That Extra Database: Difference between revisions

Jump to navigation Jump to search
Removed excess category tags; additional grammar and cleanup edits.
m (Reverted edits by Upazixorys (Talk); changed back to last version by Ric)
(Removed excess category tags; additional grammar and cleanup edits.)
 
Line 4: Line 4:
== 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.
After creating a new user with access to only one database, you discover to your horror that there's 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 ===
=== 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.
Relax; it poses no threats. The information schema is a comprehensible, rich source of metadata. It was first introduced in MySQL 5.0.02 or thereabouts. MySQL automatically populates the database.


=== Current user only ===
=== Current user only ===
Line 15: Line 15:


=== Read only ===
=== 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.
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 ===
=== Stable ===
Line 24: Line 24:
You can’t remove it so use it.
You can’t remove it so use it.


'''''[[#top | Top]]'''''
----
{|
| [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]]
|}


[[Category: UniCenter]]
 
 
 
[[Category: MySQL]]
[[Category: MySQL]]
[[Category: Facts]]

Navigation menu