title: Authenticate as a specific user in MySQL
body: <p>I'm a Brand new User to MySQL DB, have installed the WAMPSERVER and I'm using MySQL through the MySQL console. </p>
  
  <p>Query_1: Every time that I log in, it directly asks me for the password of root. However, i want to log in as a different user.</p>
  
  <p>Query_2: If at all i do login as root, i want to switch user without closing the console.</p>
  
  <p>How can I do this? </p>
  
  <p>Thank you.</p>