Creating a MySQL Database from Terminal or Command Line

The following assumes you have a successful installation of MySQL on OS X or Linux:

Create MySQL Database

mysqladmin -u root -p create database_name_development
Enter password:

To Test the Connection

mysql -u root --password=root_user_password create database_name_development
VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: +1 (from 1 vote)

One Comment to “Creating a MySQL Database from Terminal or Command Line”

  1. Vladimir 6 April 2011 at 12:31 pm #

    Thank you! It’s exactly what I was searching for.

    Does exists any command available in Terminal to list all available databases?

    VA:F [1.9.17_1161]
    Rating: 3.0/5 (2 votes cast)
    VA:F [1.9.17_1161]
    Rating: 0 (from 0 votes)

Leave a Reply