Check MySQL databases using Command Line Client

1137360 pts.
Tags:
Database
MySQL
I'm fairly new to MySQL - specifically creating new databases. I've created several tables using MySQL WorkBench but I need to check them using the Command Line Client. How can I use the command line? Thank you so much.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

This should do it for you.

mysql> show databases;

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • gnuconsulting
    You should log in first:
    mysql -u <user> -p <database name>
    You can then run the following to see all of the tables that have been created:
    show tables;
    You can view more about a particular table with the following:

    describe <table name>;

    Replace everything in brackets with the appropriate names, of course.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: