Showing, Creating and Using Database on MySQL

Posted on at

Use the SHOW statement to find out what databases currently exist on the server:

The mysql database describes user access privileges. The test databases often is available as a workspace for users to try things out.

If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself.

Creating a database does not select it for use; you must do that explicitly. To make mydb the current database, use this command:

About the author