I'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases.
I've been following this tutorial from page 3 on, as the first 2 pages where on how to initialize a local MySQL database.
My MySQL database is on my website, so I thought I had to use the website's name instead of "localhost".
Anyways, I now use this code:
Dim connection As MySqlConnection connection = New MySqlConnection() connection.ConnectionString = "Server=resload.com; Uid=***; Pwd=***; Database=***;" Try connection.Open() MessageBox.Show("Connection Opened Successfully") connection.Close() Catch mysql_error As MySqlException MessageBox.Show("Error Connecting to Database: " & mysql_error.Message) Finally connection.Dispose() End Try
But it popups (don't now whether that's a real word :p) with the message:
Error Connecting to Database: Access denied for user '***'@'my ipaddress' (using password: YES)
I've spent a lot of hours searching for the solution and problem, but couldn't find a working answer. My question therefore is; do you know what is going wrong?