title: Laravel app on Azure: Access denied for user 'azure'@'localhost'
body: <p>I am deploying a Laravel app to Azure (Web App + Mysql), so far I did the following steps :</p>
  
  <p>1- Activated Mysql In App</p>
  
  <p>2- Connected to BitBucket repository and made sure code was synced</p>
  
  <p>3- Created .env file and set database variables as follows </p>
  
  <pre><code>DB_CONNECTION=mysql
  DB_HOST=127.0.0.1
  DB_PORT=port form Mysql connection string
  DB_DATABASE=localdb
  DB_USERNAME=azure
  DB_PASSWORD=password form Mysql connection string
  </code></pre>
  
  <p>4- Ran <code>php artisan config:cache</code></p>
  
  <p><strong>The Problem :</strong></p>
  
  <p>Running <code>php artisan migrate</code> returns this error :</p>
  
  <pre><code>
    SQLSTATE[HY000] [1045] Access denied for user 'azure'@'localhost' (using pa  
  
    ssword: YES) (SQL: select * from information_schema.tables where table_sche  
  
    ma = localdb and table_name = migrations and table_type = 'BASE TABLE')      
  </code></pre>
  
  <p>Strange thing is,I ran <code>SHOW GRANTS FOR CURRENT_USER</code> In PhpMyadmin and it returned : 
  <code>GRANT ALL PRIVILEGES ON *.* TO 'azure'@'localhost'</code></p>
  
  <p>P.s : I got DB credentials from Kudu Debug Console and made sure there are no spaces before/after password or username</p>