openshift mysql database schema creation script -

i using redhat cloud openshift (rhcloud) , have mysql cartridge.

i able create database schema using script, opposed manually phpmyadmin.

how can this?

openshift contains mysql command-line tool

connect openshift:

• connect openshift: $ rhc ssh <app_name>

• connect mysql command-line tool: $ mysql

create database schema:

$ mysql --user=user_name --password=your_password -e "create database mydeebee"

verify creation:

• connect mysql command-line tool: $ mysql --user=user_name --password=your_password

• inspect schemas: mysql> show schemas; (don't forget ;)

• or verify connection new database , sql: show schemas

link mysql cli commands