Setting up MySql and then a mailing list!

[free mojo]

I am looking at using PHP for creating my news in Flash also i want to create a "mailing list" when i think of one of these i am thinking of somewhere to input your email address and a "submit" button to send it to a database. Am i right in thinking that's what it is?

I have found and looked at various tutes for using php in flash but i don't even know if i've set up mySql up correctly.

How do you use the damn thing!?!

anyone use this kind of technology? I mean i think it's something simple to do with making an account and putting in servers and host names and stuff. An outline of what people have done with theirs would be great! Then i can go and learn the flash/php tutes knowing it will work.

thanks!

[free mojo]

any thoughts, i don't know wether it's a simple answer or not , any help=brilliant

[snapple]

free mojo,

To check whether that is working, i think trying to log into your MySQL monitor would be a good idea. Open up your command prompt window and type:

cd\bin\mysql

Your command line should now read:

c:\mysql\bin>

Then type:

mysql -u root

(it might log you straight in) or it should then ask for you to login -if you are on localhost and have not set a password, just type:

root

you should then see:

welcome to the mysql monitor. commands end with ; or /.g Your mysql connection id is ... to server...

then type:

SHOW DATABASES;

that should at least show some demo pre-made databases.

Regards, snapple :)

[free mojo]

sorry but im not sure what u mean. If it helps my webspace offers MyphpAdmin which lets u edit and view the mysql databases apparently. This is what i've messed around on.

[snapple]

Well your sorted then. If you have phpMyAdmin, just do it that way, or if you want - run a PHP script to create your database(s).

But to save time, rather than FTP'ing everything - i would just test all your scripts on your localhost.

Just run the SQL.

Your MySQL monitor should look like this:

http://www.snappleflash.com/mysqlpic/

Snapple :)

[free mojo]

thanks but i don't know where you got the picture from, i don't know what you were in or on. I know that i can go to myphpadmin when i go to the control panel of my host, but i don't know how to target the database i use and stuff like that i don;t think. I'm gonna try today but if u know what i mean it would help me.
thanks for the replies so far !