New database, has two databases already in there: information _schema and test

Discussion in 'MySQL' started by philb, Nov 12, 2011.

0
  1. #1
    I've just set up a database and there's already two tables in there.


    Both tables have entries, what should I do with them?

    Here's the info..

    'information_schema' with 17 tables

    CHARACTER_SETS
    COLLATIONS
    COLLATION_CHARACTER_SET_APPLICABILITY
    COLUMNS
    COLUMN_PRIVILEGES
    KEY_COLUMN_USAGE
    PROFILING
    ROUTINES
    SCHEMATA
    SCHEMA_PRIVILEGES
    STATISTICS
    TABLES
    TABLE_CONSTRAINTS
    TABLE_PRIVILEGES
    TRIGGERS
    USER_PRIVILEGES
    VIEWS


    and 'test' with 9 tables

    Adverts
    AdvertsImages
    Categories
    Companies
    DirCompanies
    Directory
    Locations
    Sessions
    Users
     
    philb, Nov 12, 2011 IP
  2. bogi

    bogi Well-Known Member

    Messages:
    482
    Likes Received:
    16
    Best Answers:
    2
    Trophy Points:
    140
    #2
    What does "what should I do with them?" means?

    If you're wondering why there is already a db named information_schema, it's the MySQL's core database which stores everything and you can't delete it.

    Don't worry about it :)
     
    bogi, Nov 12, 2011 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    You can delete test if you want. Don't mess with the information_schema table, including editing permissions for it.
     
    jestep, Nov 14, 2011 IP