mysql - can't run commands in terminal?

Question

I'm new to database and mysql.

After running sudo mysql -u root -p and type in my password, I get into mysql successfully. (I'm under Mac OS X 10.10.)

However, when I tried to create a database, there was something wrong.

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.6.23 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test
    -> exit
    ->

What's the problem?

Vasfed · Accepted Answer · 2016-04-29 14:27:09Z

1

I believe that you may just be missing the semicolon

create database test;

edited Apr 29, 2016 at 14:27

Vasfed

18.6k10 gold badges56 silver badges59 bronze badges

answered Apr 29, 2016 at 14:21

Matt M

387 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jinglei Over a year ago

Sorry to bother again. After I add a semicolon, a database is created and I can see it appears in the result of running show databases;. But where is the file? I run mysql under home directory but I can't find a database file in it?

Matt M Over a year ago

I believe this will explain the location of the databases stackoverflow.com/questions/26402884/… I would suggest looking for a crash course type tutorial to get generally familiar with working with databases like maybe mysqltutorial.org

Collectives™ on Stack Overflow

mysql - can't run commands in terminal?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related