How to insert data to Mysql database hosting using vb.net

Question

I have a website using PHP and MySQL Database that hosting ready. I want to upload data to website by using windows application using VB.net but I cannot connect to database. I try this code to connect to Mysql database:

    Dim conn As MySqlConnection
    conn = New MySqlConnection()
    conn.ConnectionString = "Host=www.mydomain.com; user=test; password=****; database=test;pooling=false"
    Try
        conn.Open()
    Catch myerror As MySqlException
        MsgBox("Error connecting to database! " & myerror.Message)
    End Try

This is message error:

"Error connection to database! Access denied for user 'test'@114.134.189.135' (using password: YES)".

Please help me to solve it.

Your connection string does not conform to those shown here: connectionstrings.com/mysql-connector-net-mysqlconnection — ron tornambe
– ron tornambe, Commented Sep 13, 2013 at 17:07

Bala · Accepted Answer · 2013-09-13 17:42:11Z

1

1.Verify that MySQL service is running on your target machine
2. Ensure that user 'test' having the password 'YES'<br>
2.1 Please login any MySQl UI (Eg.,SQLYog)with your username and password for confirmation
3. If not, create a new user
   CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

answered Sep 13, 2013 at 17:42

Bala

6587 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert data to Mysql database hosting using vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related