Question posted in 
I’ve created a database with a user “jack”. I’m doing this through xampp locally.
https://puu.sh/xi7wh/e3046fd320.png
I’m trying to install magento with this connection:
https://puu.sh/xi7AX/98460dd7c0.png
But I get “database connection error”. I’m not sure where I’ve gone wrong.
Thanks for any help.
3
Answers
First of all, check your database user name and password. Before you proceed to this step, you should have already set up the database in MySQL. You need to create a user and grant access privileges to that user.
Then check your MySQL server configuration. The default port number is 3306. However, your system admin might change it to something else. Or if you are using software packages such as MAMP/WAMP, the port number may be set to something other than 3306. In these cases, you need to explicitly put the port number in the Host field.
If all these are correct and you still have database connection error, you can try to use root account to access the database. If root works out, that means there are problems with the privileges in your MySQL settings. Although it is not recommended to use root account for future production deployment as it adds security risks to the server.
More information visit following URLS :-
https://magento.stackexchange.com/questions/84782/database-connection-error-magento-installation
Installing magento, get database connection error.
Make sure to use hostname as 127.0.0.1 alongwith port no. if changed and the same in the URL as well
first you have to check the configuration.and then check the port number specified.if it is the default one, simply write the host name as localhost or other you assign else you have to specify the hostname with its port number.