How can i connect my site to the database?

[lesterax]

Please help. I am trying to connect my website to the database i created. in the login in i encountered this error

Warning: mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /home/trialx21/public_html/login.php on line 9
Failed to connect to MySQL: Access denied for user 'root'@'localhost' (using password: NO)

Thanks

 

[bdistler]

Please help. I am trying to connect my website to the database

the following settings should be used:

Host/Server Name - [ localhost ]

Port - [ 3306 ] (not necessary)

Username --> Your cPanel username followed by an underscore and the MySQL username you configured in cPanel

Password --> The password that you used when creating the MySQL user

Database --> Your cPanel username followed by an underscore and the name of the database that you created in cPanel

NOTE: Free hosting accounts do not have remote MySQL access.