Error while connecting to the database

[Hendrik]

Hi Support,

 

I have looked around the forum and have found that other people have had the same problem, but none of the solutions helped me.

 

The error i get.

 

---------------------------

Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES)

 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 

Exception Details: MySql.Data.MySqlClient.MySqlException: Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES)

--------------------------

 

My domain name is ngs.is.

I have created a database and user and assigned a user to the database.

The user has all the privileges.

Also johnny.heliohost.org is the database server address, right?

 

I am able to connect to the database through cpanel phpmyadmin, but not remotely.

 

I doubt that the mistake is in the connection string but i will add it anyway, just in case "SERVER=johnny.heliohost.org; DATABASE=tazan_ngsis; USERNAME=tazan_ngsis; PASSWORD=***********";

 

Will be waiting for the reply

 

Best Regards,

Hendrik

 

[jje]

In cPanel, have you entered the 'Remote SQL' page and put a % symbol in the box?

[Hendrik]

thanks, it helped me.

but what baffles me is that prior to making this topic i was trying the same very solution, but the cPanel did not accept '%' at all, but now it does

[Guest Geoff]

Well, maybe you entered something else before.