ASP.NET/MySQL Problem

[wlkras]

Hi guys,

I'm having some trouble trying to connect to mySql via ASP.NET. I've tried various methods listed here on the forums, but I cannot for the life of me seem to make it work.

Here's my current connection string (from web.config)
connectionString="Server=mysql-lotus.x10hosting.com;Database=otfcb_Stats;User={blanked};Password={blanked};Pooling= false;"

I've tried with both localhost and mysql-lotus.x10hosting.com, but both cause errors, though different ones

localhost causes this:

Connection refused
Description: HTTP 500. Error processing request.
Stack Trace:
System.Net.Sockets.SocketException: Connection refused at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remoteEP) [0x00000] in <filename unknown>:0 at System.Net.Sockets.Socket+Worker.Connect () [0x00000] in <filename unknown>:0

mysql-lotus.x10hosting.com causes this:
SELECT command denied to user 'otfcb_otfcb'@'int.lotus.x10hosting.com' for table 'grade'

Description: HTTP 500. Error processing request.
Stack Trace:
MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'otfcb_otfcb'@'int.lotus.x10hosting.com' for table 'player' at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int32& insertedId) [0x00000] in <filename unknown>:0 I have tried to remove the user privileges, the user and even created a brand new user, but the problems persist. Maybe I'm missing something blatantly obvious, but I've been trying for three nights and I have no clue what to do next.

If anyone has any suggestions, I'm keen to hear them.
Cheers
WLKRAS

 

[Zubair]

Replace

Server=mysql-lotus.x10hosting.com

with

Server=localhost

in web.config

 

[masshuu]

Make sure the user has rights on the database.

SELECT command denied to user

tells me its permission issues.

Also zubar, he did use localhost:

ocalhost causes this:

Connection refused
Description: HTTP 500. Error processing request.
Stack Trace:
System.Net.Sockets.SocketException: Connection refused at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remoteEP) [0x00000] in <filename unknown>:0 at System.Net.Sockets.Socket+Worker.Connect () [0x00000] in <filename unknown>:0