title: Using mysql_config_editor
body: <p>Using mysql_config_editor on a computer running Windows 7 pro so password need not be put into batch file</p>
  
  <p>Running MySql version 5.7 on Windows 7 Pro.  I am learning MySql .
  My goal is to put the MySql password into a file so I don’t have to put the plain text password into batch files I want to invoke .There is much I do not understand about the relationship between MySql and Windows permissions.</p>
  
  <p>Before executing mysql_config_editor, I would manually navigate to the 
  cd “Program Files\Mysql\Mysql Server 5.7\bin    folder
     and then type             mysql
    I would get a prompt for password.  I enter the password and the MySql command prompt appears.</p>
  
  <p>I read about mysql_config_editor.  So I typed:
    mysql_config-editor  set –user=root –password
    The   mysql_config-editor prompted me for a password .  I entered the password.</p>
  
  <p>Then I navigated to the bin folder as above.
    I typed          mysql and this time the mysql command prompt immediately appears, no prompt for password.
    The mysql 5.7 manual says the   mysql_config-editor  will create a file called mylogin.cnf  .  I have searched all the drives on my Windows 7 computer and cannot find this file.  Yes, I am logged in as administrator, I have full rights. </p>
  
  <p>So I thought now, when I execute a Windows batch file,  I just need to enter the –user=root command in the batch file  and MySql will log in as user root without any need for me to provide a password.  And this works as log as I am logged in as administrator. </p>
  
  <p>Question:
   I cannot find any file called mylogin.cnf .  I cannot find any file when I search for mylogin*.*  Obviously the  mysql_config-editor changed something.  What file did it change?</p>