title: MySQL Workbench: Cannot export a database
body: <p>I am encountering a problem concerning the export of a database. 
  First of all, I have to clarify that I am using <strong>MySQL Workbench 5.2.47</strong>. The procedure that I followed so far is the following: </p>
  
  <ol>
  <li><p>I followed the instructions of <a href="http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/" rel="noreferrer">http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/</a> in order to create a connection with my <code>MSSQL DB</code> in order to transform it into <code>MySQL DB</code>. </p></li>
  <li><p>Then I also checked that my data is imported in the database. </p></li>
  <li><p>Now I want to export it into an sql file / or preferably to frm,myi,myd files in order to place them in my server.</p></li>
  </ol>
  
  <p>I have tried to export them from</p>
  
  <ul>
  <li><p>Server Administration -> Data Export</p></li>
  <li><p>Changed already the password from the security (Users and Privileges)</p></li>
  </ul>
  
  <p>but I encounter the problem </p>
  
  <pre><code>Dumping test (all tables)
  Running: mysqldump.exe --defaults-extra-file="c:\users\d_micha\appdata\local\temp\tmpgtwa_m.cnf"  --user=root --max_allowed_packet=1G --host=localhost --port=3306 --default-character-set=utf8 --single-transaction=TRUE --routines --events --no-data "test"
  
  mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
  
  Operation failed with exitcode 2
  </code></pre>
  
  <p>I don't know what I might be doing wrong and I have searched in google to find the solution, but it should be normally exported. </p>
  
  <p>Any other information will be given upon request.</p>
  
  <p>Thank you.</p>