[antarr.byrd]

I know this has been asked before to an extent but none of them seem to help me.

I'm trying to connected to mySQL server. But I keep getting an error,

Quote

Access denied for user ''@'localhost' (using password: NO)

protected void Page_Load(object sender, EventArgs e)
        {
            con.ConnectionString = "Server=http://wwww.mysite.com;Database=mysite_test;Uid=mysite_user;Pwd=test";
            
            con.Open();
        }

private void button1_Click(object sender, EventArgs e)
        {
            //Let us just get connect and display the table in a GridView.
            MySqlDataAdapter dr = new MySqlDataAdapter("CREATE TABLE Members(FirstName varchar(15),LastName varchar(15),Age int);", con);
            DataSet ds = new DataSet();
            dr.Fill(ds);
            dataGridView1.DataSource = ds;
            //dataGridView1.DataBind();
        }

This post has been edited by antarr.byrd: 19 August 2010 - 05:31 PM

[Crunch]

antarr.byrd, on 19 August 2010 - 11:29 PM, said:

Access denied for user ''@'localhost' (using password: NO)

You have left the password field blank. Enter the correct password and try again.

(Your test variable must be empty)

[antarr.byrd]

Crunch, on 19 August 2010 - 04:36 PM, said:

antarr.byrd, on 19 August 2010 - 11:29 PM, said:

Access denied for user ''@'localhost' (using password: NO)

You have left the password field blank. Enter the correct password and try again.

(Your test variable must be empty)

It's not empty, unless i dont understand the connection string

Pwd=test

[Crunch]

where is your mysql server located? At localhost or somewhere on the network ?

[antarr.byrd]

Crunch, on 19 August 2010 - 05:23 PM, said:

where is your mysql server located? At localhost or somewhere on the network ?

hosted by siteground, I already gave my ip remote access.

[Crunch]

Then why does your error message say

Quote

Access denied for user ''@'localhost' (using password: NO)

Localhost ?

[antarr.byrd]

Crunch, on 19 August 2010 - 05:55 PM, said:

Then why does your error message say

Quote

Access denied for user ''@'localhost' (using password: NO)

Localhost ?

I have no idea

[antarr.byrd]

Crunch, on 19 August 2010 - 05:55 PM, said:

Then why does your error message say

Quote

Access denied for user ''@'localhost' (using password: NO)

Localhost ?

Well its working now, but I'm being denied Access to the Select command although the user has all privileges

[Crunch]

Well done