title: Connecting Laravel project to remote MySQL created on CPanel
body: <p>Here's the scenario:</p>
  <p>I created a MySQL database on CPanel using CPanel's helper tool, also created a user for this database, and i run queries on this database using phpMyAdmin (which i also access through CPanel).</p>
  <p>I'm developing a Laravel application using the PhpStorm IDE, and i need to connect the application to this remote database. My doubt is, which credentials should i put on .env file?</p>
  <p>On the main page of phpMyAdmin, it says:</p>
  <pre><code> Server: Localhost via UNIX socket
   Server Type: MySQL
   Server Connection: SSL is not being used
  </code></pre>
  <p>plus, the 'host:port' shows up as localhost:3306.</p>
  <p>I already tried to use the 'host:port' credentials of my CPanel account, the localhost:3306, the user/password of my CPanel account, and the user/password created for the database (and all the combinations between these four credentials, plus using the database name) and nothing worked. I'm testing the connection on the PhpStorm's 'Add Database' section, <a href="https://i.stack.imgur.com/qBOVZ.png" rel="nofollow noreferrer">here</a>. If it connects, I'll know which are the right credentials. So far, i've only got &quot;Access denied&quot; error (<a href="https://i.stack.imgur.com/azUUG.png" rel="nofollow noreferrer">example</a>).</p>
  <p>Am I looking at the right things? Or the only way to connect is using this SSL connection? (and if so, is there a tutorial on how to do this?)</p>
  <p>Other suggestions on how to work on this scenario are welcome too :)</p>