title: Cpanel MySQL database credentials
body: <p>I've purchased a web hosting and the guy gives me the link of my hosting and I've added my domain against it; now I am trying to create MySQL database in it. I've created a database in MySQL and by clicking on phpmyadmin in cpanel it navigates me to the database, but I am not able to see its credentials and so that I could write those in code or configure my navicat. I've created a database and also a user in cpanel and have assigned all the privileges to the user, but I'm still not able to access the database in navicat. My navicat configurations are:</p>
  
  <pre><code>User Name/IP Address: localhost
  Port: 1433
  User Name: database name
  Password: password the cpanel give me while adding a user.
  </code></pre>
  
  <p>Please let me know where I am mistaken.</p>
  
  <p>EDIT:</p>
  
  <p>even the console rejects the credentials, my config_db is:</p>
  
  <pre><code>var Sequelize = require('sequelize');
  
  var sequelize = new Sequelize('database name', 'userName', 'userPassword', {
        host:"localhost",
  
  
        dialect: "mysql", // or 'sqlite', 'postgres', 'mariadb'
        port:    1334, // or 5432 (for postgres)
   });
  
  module.exports = {  
  
      dbase: sequelize,
  
  
  };
  </code></pre>
  
  <p>and the image of console is:</p>
  
  <p><img src="https://i.stack.imgur.com/B7eMP.jpg" alt="console rejecting the mysql credentials"></p>
  
  <p>and the code where i'm trying to access the table and try to execute the inset sql query is (the controller file):</p>
  
  <pre><code> client_login: function (req, res) {
  
  
       sequelize.query("INSERT INTO `t_user_Information` ( `id`, `user_name` , `user_password`) VALUES ('NULL', 'login' , 'passWordParam')");
  
                res.json({status: 'success', message: 'success' , has_agreed:resUserInfo.dataValues.has_agreed, password_reset: resUserInfo.dataValues.password_reset});
                console.log('&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;  Done  &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;')
  });
  </code></pre>