title: How to create database using XAMPP shell
body: <p>I want to install Magento on my localhost, using xampp shell. I've been busting my ass on the same error for hours now. </p>
  
  <p><strong>This is my code so far</strong></p>
  
  <pre><code>set folder="mystore"
  set password="mypassword"
  set ip="localhost"
  
  md %folder%
  cd %folder%
  
  echo CREATE DATABASE %folder% | mysql -u root -p
  </code></pre>
  
  <p>After i do this, i get prompted to type in the password. If i do type in the password i get the <strong>error 1045 access denied for user 'root'@'localhost' using password yes</strong> error, but if i just press enter, i lets me through (atleast i think) but i get another error - <strong>error 1064 at line 1, you have an error in your sql syntax</strong></p>
  
  <p>I've been googling solution, tried different variations like:</p>
  
  <p><strong>CREATE DATABASE mystore</strong></p>
  
  <p><strong>CREATE DATABASE "mystore"</strong></p>
  
  <p><strong>CREATE DATABASE 'mystore'</strong></p>
  
  <p>but nothing works. I've just started using xampp and shell and i'm still a newbie, so please help :(</p>
  
  <p><a href="https://i.stack.imgur.com/D6w05.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D6w05.jpg" alt="enter image description here"></a></p>
  
  <p><strong>After another few hours i came across some linux website where i found the solution. Can't believe the answe is that easy, but i guess as long as you are newbie at one thing, you can easily miss those things. Anyway, here's the solution</strong></p>
  
  <p>instead of "", ' ' or even nothing in CREATE DATABASE, use ``</p>
  
  <p>Example.</p>
  
  <p><strong>Not working</strong></p>
  
  <pre><code> echo CREATE DATABASE %folder% | mysql -u root -p
  </code></pre>
  
  <p><strong>Working</strong></p>
  
  <pre><code>echo CREATE DATABASE `mystore` | mysql -u root -p
  </code></pre>