[kyle_denney]

Hello!

I am getting an error when connecting to MySQL database. For some reason I cannot gain access to my database. I have used similar code to connect to another database on another server in a previous application but cannot do it for this one. Is it a configuration issue or a code issue? If so what changes do I need to make. I am using cPanel and phpMyAdmin. Thanks!

Here is my code :

            Dim dr As MySqlDataReader
            Dim cmd As MySqlCommand

            conn = New MySqlConnection("Server=IPADDRESS;Port=3306;Database=DATABASENAME;Uid=USERID;Pwd=PASSWORD;")
            conn.Open()


          cmd = New MySqlCommand("SELECT FIELD FROM TABLE WHERE FIELD= '" & VALUE & "'", conn)             
          dr = cmd.ExecuteReader()             
            If dr.HasRows = True Then 
                While dr.Read = True

                End While
            End If

[modi123_1]

It would be great to know the error..

[kyle_denney]

The error states this:

AUTHENTICATION FOR HOST (IP ADDRESS) FOR (DATABASE NAME) FOR METHOD MYSQL_NATIVE_PASSWORD FAILED WITH MESSAGE ACCESS IS DENIED WITH USER USING PASSWORD = YES

Not sure what this error means but I even re-created the database and password and to no avail.

[modi123_1]

Just googling 'FOR METHOD MYSQL_NATIVE_PASSWORD FAILED WITH MESSAGE ACCESS IS DENIED WITH USER USING PASSWORD = YES' more or less points to the server you are trying to connect to doesn't like you credentials.. or doesn't like peeps connecting from elsewhere. Talk to who ever set up your db.