How to connect to a MySQL server database VB NET VB.NET VB6 Visual Basic

required dll (UPDATED!):
http://filebeam.com/39afb51e15a9863bd2dd8067b0b2d3a8

copy paste text:

"server=" & txtServer.Text & ";user id=" & txtUsername.Text & "; password=" & txtPassword.Text & "; port=3306; database=" & txtdb.Text & "; pooling=false"


entire code:

Imports MySql.Data.MySqlClient
Public Class Form1 Private Sub btnConnect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnConnect.Click Try Dim Connection As New MySqlConnection("server=" & txtServer.Text & ";user id=" & txtUsername.Text & "; password=" & txtPassword.Text & "; port=3306; database=" & txtdb.Text & "; pooling=false") Connection.Open() MsgBox("Connected to: " & txtServer.Text) Catch ex As MySqlException MsgBox(ex.Message) End Try End Sub
End Class

Category:

Howto & Style

Tags:

• how
• to
• connect
• mysql
• server
• sql
• db
• database
• VB
• NET
• VB.Net
• VB6
• Visual
• Basic
• 2008
• tutorial
• guide
• Studio

[EasyTool70]

Just kidding, followed the whole video ofcourse.

However i always end up with "Acces denied for user '...'@'myserveriphere' (Using password: YES)

Strange.

[nathan76296]

@EasyTool70 Sounds like a mysql server issue not a issue with the program. Make sure you have the right password for that account.

[EasyTool70]

@nathan76296

Hmm yeah it was i think.

Fixed it before i saw this but i think you were right.

I made an new database and again all tables in it and its working great right now.

Is it possible that if someone registers at my forum, it's username goes directly to my mysql database?

If so then how?

And if you dont know either, can you refer me/us to some valuable tutorials?

[nathan76296]

@EasyTool70 When you have a online forum most of them use a mysql database to hold the account information in. If you want their username to go into a custom database as well as the one the forum uses then you will have to modify the PHP.

[EasyTool70]

Thats the point where i turned my pc off.

When you said "browse"

Around 0:24

[nathan76296]

@EasyTool70 why turn it off? you should of just threw it out the window.

[Dennis2148]

Your voice is funny :D

[Zaxer11]

Is this really your voice? :P

[MarkoPety]

ara marra canr dor it so ara do it :D

[jbsadvseeker]

low there.. could somebody post a vb6 with mysql connection set-up? just the steps. please.. that will be a great help for us students.. I am a graduating student. please lend a helping hand,,,

[kaiokkanonen]

HAHAHA xDDDD

"I Will put it in my description so you don't send me dirty messages" xD

[kaiokkanonen]

@Zaxer11 He's from Finland, almost everybody from there talks like that when they talk English xD

[rehabilitisitivity]

all is well :)

[Roman8880]

lol it's a virus?

[twisterwep]

russel peters cusen >>> take it and go

[VagueHumanity]

@Zaxer11

INSTEAD OF SAYING THIS , YOU CAN SAY THANK YOU ! IT WILL BE MUCH BETTER !

THANK YOU NATHAN !

[MightyVideosCinema]

pakiggg