title: Create database and table syntax
body: <p>I am failing to find an example of creating the database and a table in one script. I am not sure how to do this because I have no <code>MySQL</code> installed. This is what I have:</p>
  
  <pre><code>CREATE DATABASE TestDB;
  
  USE TestDB;
  
  CREATE TABLE TestTable
  (
      ID INT NOT NULL PRIMARY KEY
  );
  </code></pre>
  
  <p>Is this valid for <code>MySQL</code>? I tried to test this on <a href="http://rextester.com/" rel="nofollow">http://rextester.com/</a> but getting exception:</p>
  
  <blockquote>
    <p>Access denied for user 'rextester_user'@'localhost' to database
    'testdb'</p>
  </blockquote>
  
  <p>Edit:</p>
  
  <p>What is going on? So simple question without answer?! Can anynbody just copy and paste this code to <code>MySQL</code> to verify it?</p>