Create a MySQL Database From the Shell
Create a database: (Creates directory /var/lib/mysql/databasename)
[prompt]$ mysqladmin -h localhost -u root -ppassword create databasename
(or use SQL command: CREATE DATABASE bedrock;)
Add tables, data, etc:
Connect to database and issue the following SQL commands:
[prompt]$ mysql -h localhost -u root -ppassword
…
mysql> use databasename; - Define database to connect to. Refers to directory path: /var/lib/mysql/databasename
mysql> create table employee (Name char(20),Dept char(20),jobTitle char(20));
mysql> DESCRIBE employee; - View the table just created. Same as “show columns from employee;”
mysql> show tables;
Bookmark This Post:
