Reply to comment

How to create MySQL database?

Login to your MySQL database server

mysql -u root -p

and type this command:

mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)

To check your newly created database, type this command:

mysql> show databases;

  1. +--------------------+
  2. | Database           |
  3. +--------------------+
  4. | information_schema |
  5. | mysql              |
  6. | test               |
  7. | test_db            |
  8. +--------------------+
  9. 4 rows in set (0.00 sec)

No votes yet

Reply

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You may quote other posts using [quote] tags.

More information about formatting options