title: using method 'mysql_native_password' failed
body: <p>An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll</p>
  
  <p>Additional information: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: NO)</p>
  
  <p>I need to connect my database to the report viewer in visual studios however this error always appears and i dont know what changes i have to make...the password was already set to 'root' however this error still appears, I want to know what "(password: NO)" means since this only appeared when i accidentally flushed out the privaleges.</p>