# MySql in Login Tutorial **URL:** \ **Category:** programming\ **Created:** [September 29, 2004, 1:44pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770 "2004-09-29T13:44:10Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![norm1252003](https://avatars.discourse-cdn.com/v4/letter/n/977dab/32.png) [@norm1252003](https://forum.kirupa.com/u/norm1252003)\ **Post date:** [September 29, 2004, 1:44pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/1 "2004-09-29T13:44:10Z")
I have been working in flash for a while now and want something new to learn, so I am checking out all this Sql and PHP, Stuff… So, just a Quick Question… For some reason, when I get to the third step of the tutorial, The Mysql, I get lost as to what am I suppose to do with the script that is provided in the tutorial… Right now I have downloaded the files as is, and uploaded them to my server. So, I have not changed any of the script… Is there Something in the script that I need to change… If someone could help me, that would be great. thanks… cheers norm1252003 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 29, 2004, 1:46pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/2 "2004-09-29T13:46:53Z")
How about a link to the tutorial you are using? That would help me help you. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 29, 2004, 1:51pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/3 "2004-09-29T13:51:16Z")
[http://www.kirupa.com/developer/actionscript/authentication.htm](http://www.kirupa.com/developer/actionscript/authentication.htm) Here is the tutorial that I am using… ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 29, 2004, 2:06pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/4 "2004-09-29T14:06:05Z")
Step three deals with creating the table in your mySQL database where your data (in this case login and password) is stored. There are actually several different ways to do this. You can use the script provided, or my server comes with a utility called phpMyAdmin which is graphical approach to dealing with mySQL databases, tables, and data. You might want to look around and see you have this utitlity. It is much easier to use. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 29, 2004, 2:16pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/5 "2004-09-29T14:16:47Z")
I do not know if my server has that, so let’s assume I don’t, how and where do i make this databade that you are talking about. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 29, 2004, 2:32pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/6 "2004-09-29T14:32:07Z")
Are you sure that your server has mySQL? I guess that is the first question. If you do have mySQL, there should be someplace that you can change settings, add databases, add tables, ect. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 1:00am UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/7 "2004-09-30T01:00:52Z")
OKay, so i look into my account and i do have a MySql Database manager… So, What do I do with this, now that i know i have it… ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 1:45am UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/8 "2004-09-30T01:45:55Z")
There is a place where you can enter scripts. Enter the script that the tutorial provides. CREATE TABLE auth ( userid int(4) unsigned zerofill DEFAULT '0000’ NOT NULL auto\_increment, username varchar(20), userpassword varchar(20), PRIMARY KEY (userid) ); Change the name of the table “auth” to whatever your table is. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 2:32am UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/9 "2004-09-30T02:32:09Z")
I created a table in the mysql database with the script u provided. When I use the usercheck.php. I get an errorat the bottom: [http://www.bradparish.com/v2/login/usercheck.php](http://www.bradparish.com/v2/login/usercheck.php) what does that mean? ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 1:32pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/10 "2004-09-30T13:32:09Z")
I didn’t see an error? ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 1:34pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/11 "2004-09-30T13:34:35Z")
YEAH, I FINAL GOT IT TO WORK LATE LAST NIGHT. THANKS FOR ALL YOUR HELP MAN… THIS SQL STUFF IS PRETTY COOL… MANY MORE HOURS OF FUN AHEAD… CHEERS NORM125 ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 2:08pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/12 "2004-09-30T14:08:57Z")
It is some cool stuff. Wait until you start using pulling from mySQL, and then turning it into XML with PHP. That’s when the fun begins. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 2:10pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/13 "2004-09-30T14:10:10Z")
ANY TUTORIALS TO START ME IN THAT DIRECTION? ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\ **Post date:** [September 30, 2004, 2:25pm UTC](https://forum.kirupa.com/t/mysql-in-login-tutorial/65770/14 "2004-09-30T14:25:59Z")
Well here is a whole list of them: [http://www.kirupa.com/web/index.htm](http://www.kirupa.com/web/index.htm) I would start here: [http://www.kirupa.com/web/mysql\_xml\_php.htm](http://www.kirupa.com/web/mysql_xml_php.htm)