Dirty secret is this will work with Windows or anything else that runs MySQL, as well as the recommended Debian, Ubuntu, Red Hat / RHEL (which is what CentOS really is) etc.
mysql -u root -p
(The long form, which is quite unnecessary, is " mysql --user=user-name --password=your-password")
Once in the MySQL command line utility:
Then to see what's in a particular database: