see db and tables

Posted on 2011-10-29
Last Modified: 2012-05-12
Using MySQL workbench 5.2CE how to see all the databases and all the tables
Question by:rgb192
    LVL 21

    Accepted Solution

    LVL 24

    Assisted Solution

    Or you can browse the information_schema database as root user.  the tables view show information on all tables in all databases.  Note that you have to be logged on as user with admin privileges, else you will only see the tables the user has been granted access to.

    Author Closing Comment

    thanks both

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Creating and Managing Databases with phpMyAdmin in cPanel.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now