MySql Connection Problem

[wlkras]

Hi,

I'm having a problem with my MySQL, it seems to refuse my connection and I'm not sure why?

Here's the error:
Access denied for user 'otfcb_otfcb'@'localhost' (using password: YES)

The connection string is declared in my web.config as follows:

<add name="MySQLConnection" connectionString="server=localhost;Database=otfcb_Stats;User=otfcb_otfcb;Password=****;Pooling=false;" providerName="MySql.Data.MySqlClient" />

The user has been added in cPanel with full access rights, but to no avail.

I'm probably missing something blatantly obvious, but if someone can point it out, I'd be most obliged

 

[Gouri]

Hi,

I'm having a problem with my MySQL, it seems to refuse my connection and I'm not sure why?

Here's the error:
Access denied for user 'otfcb_otfcb'@'localhost' (using password: YES)

The connection string is declared in my web.config as follows:

<add name="MySQLConnection" connectionString="server=localhost;Database=otfcb_Stats;User=otfcb_otfcb;Password=****;Pooling=false;" providerName="MySql.Data.MySqlClient" />

The user has been added in cPanel with full access rights, but to no avail.

I'm probably missing something blatantly obvious, but if someone can point it out, I'd be most obliged

Which server you are on?

At the moment the mysql on two of free servers is under update. Check the status at http://status.x10hosting.com

Try after some time.

 

[wlkras]

I believe it's Lotus

 

[Gouri]

I believe it's Lotus

Then you should check the database information in your config file.

And better re create the database user(Only database user not database) and use that configuration in your config file.