#7 Mysql Login in Vb.net

[nettsam]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND password= '' txtpass.text' at line 1

[jbheroxx]

@nettsam Can you give me the whole query line?

[nettsam]

@jbheroxx That is it.

[nettsam]

@nettsam Check your messages

[SecForRes]

I'll have you know, sir, that this is the ONLY helpful video tutorial (or ANY type of tutorial for that matter) on the ENTIRE internet. No lie man... THANK YOU.

[handsomethomas]

thanks alot. it was very helpful, is it possible to have a user authentication using the same method. lets say you a db with username,psswrd and userlevel, and you have 3 forms. form a,b and c. and during login it will check which level does the user has, if userlevel is equal to 1 then form A should come up and so on.

[huejiitechx]

thanks sir... great job

[techhuejii]

thanks alot sir.... nice turorial...

[TaleRanger]

the pastbin are dead...

try it.

without space

pastebin .com /03C31s2w

[peejay0812]

mydata = cmd.ExecuteReader() - my error :(

[nettsam]

@peejay0812 I have that error too.

[VicherVan]

it says Unable to connect to any of the specified MySQL hosts.

why was that?

can you help me in this?

[ronronsh]

I got tons of errors..

[Firqable]

It keeps saying: "Database not available". So it doesn't find the database. It can't connect. So I don't know what's wrong cause it's all connected and all set up.

[TrueCodeStudios]

fuck yes trying to find this tut other are sht thxxx

[liminos]

Best tutorial about that all others are crab

[BloodStone20]

Table 'database.login' doesn't exist error.... <<<<whats this bullshit.. iv tryd everything but it keeps giving me the database as a table

[SyoncMaster]

Hi...can you please Give me link to your WebSite for SourceCode.. Thanks..!

[420clownen]

ive made a login form with vb 2010 but is it possible to compile it to an exe?

my build options dissapears as i include mysql to the form..

[emann123456]

Can any one has an idea about how to get data from mysql and retrieve it put the data to text box instead of data grid?

[420clownen]

@emann123456

there is a tutorial on how to get a query to a textbox.

watch?v=eIHeiAX3wnQ

[sputtnikk11]

pastebin is a fucking fail! -.-

[emann123456]

@sputtnikk11 GOTO yills(dot)wordpress(dot)com and you can see the code

[sputtnikk11]

@emann123456 Thanks :D

[thehaloman96]

how do i setup my sql server online (im using webs.com(a website hosting site))?

[nettsam]

@thehaloman96 It does not work like that, you cant fancy around with any web host. They haft to have MySQL databases with remote access. Webs does not include databases of any kind. Try freemysql . n e t ( remove the spaces )

[trewq343]

Username: admin (or any other username)

Password: 'OR''1=1'

that's all you have to do to hack in to a SQL database...

[skiLLdotexe]

source reuploaded: pastebin. com/XHiFgsi7

[sputtnikk11]

@skiLLdotexe TY! :D

[skiLLdotexe]

pls make a tut for that vid how to set up the database tables!

[skiLLdotexe]

nice tut btw hoe to setup the mysql db? :S

[Evilnils]

@TutorialOfDarkness Got it working nps :) 

[Evilnils]

I dont have any MySQL.Data reference -.-' any help?

[Markusistcool]

can you send me the Projekt ? or mh i have md5 hash :/

[nmxsys1]

thanks friend!!!!

[Senapy]

why this is not working? :(

[XSparshX]

plz upload codes again

[HackingSaint]

what if i want to allow a user to have access to my program, without knowing his password?

[surffinn]

pastebin. com/0xNbNKzC

[sajidctn]

plz see and help me what am do ??

watch?v=Ipggfejz38s

[KaibaCorporationDTDL]

If you get SQL Syntax error than change:

"Select * From Login WHERE Username='" + TextBox1.Text + "'AND Password='" + TextBox2.Text + "'"

to

"Select * From Login WHERE Username='" & TextBox1.Text & "'AND Password='" & TextBox2.Text & "'"

[makoto114]

could you please send me the code for your login? The Code in your links is gone

[matrob81]

I have a problem with "myData = myCommand.ExecuteReader()"

It isn't underlined with red, it crashes the program when it tries to obtain a result. :S help

[vbigvppl]

Hej :) Thanks for tutorial, but i don't know what should be in mysql database (i have empty mysql base :P)

[vbigvppl]

ok, i got it ;)

[quickvidtutorials]

HI GUYS! HERE IS HOW TO FIX THE ERRORS!!!

Step 1 - make sure that User is the name of your table in php myadmin

Step 2 - make sure that under Username and Password you have the table names. mine are field1 and field2

ALSO after txtpass.Text & "';" make sure you have the ; symbol or semicolon for it to work

let me know if you want a vid tut on this

[quickvidtutorials]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELCET * FROM login WHERE username = '' AND password = ''' at line 1

HELP

[jbheroxx]

pastebin. com/f23b87f57

[complayer772]

@jbheroxx thanks

[jbheroxx]

@jbheroxx It is line 31 causing the issues, can you fix it or do you want the solution?

[JasonWaterfield]

Paste bin doesnt work it's been deleted.

[treverg]

IT no worky i get the same error as the guy below and i made EVERYTHING correct

[musaikaa]

oiii i got this same error help me plz wt did u do to correct this error !!!!!! i am expectign a big help from youuuuuu

[Destinycomputing]

I keep getting error when it cant find a server myData = myCommand.ExecuteReader()

I click the error and this is what I see

(Connection must be valid and open.)

InvalidOperationException was unhandled

[joler1302]

hm i got error:

Error1Handles clause requires a WithEvents variable defined in the containing type or one of its base types.C:\Documents and Settings\Joler1302\Lokale indstillinger\Application Data\Temporary Projects\WindowsApplication1\L­oginForm1.vb51103WindowsApplic­ation1

[HARSHIZZLE]

well i have another question. Does this allow me to change the password of the login forum over the internet?

[jbheroxx]

You can use this script as a starting point to then send replace command :D

[HARSHIZZLE]

umm i cant find the MySQLData thing, can u help me find it

[jbheroxx]

Check the description :)

[HARSHIZZLE]

ok thanks dude

[datornet]

Where can i get a Mysql database?

[jbheroxx]

You can either get one from a free host or from a paid webhost provider, alternatively you could set your own one up by downloading the server software yourself, a great bundle that includes the web server and admin software is something called 'WAMP' search it in google :)

[CarbonSXMonkey]

This is an extremely insecure method of a Mysql login, If I used a Packet Injection I could easily get all the information to your database, Might want to also make a tutorial for encryptions .

[jbheroxx]

Thanks for the quick comment :) this is only meant for a starting point for people to interact with the database through their programs.