MySQL - Tables

[sail3005]

How do i add tables to a MySQL DB i created? it doesn't have to be php, i just want to create the tables.

[sail3005]

nm, i got it

[chrisjk]

You didn't say what you'd got, but try this if you haven't already

http://phpwizard.net/projects/phpMyAdmin/

it's a sweet piece of kit

[sail3005]

DUDE THATS AWESOME!

Thanks a LOT for showing me that!

It just made my life 5983624593765 times easier!

[chrisjk]

no problemo, that's what I thought when I found it

[TheGoldenShogun]

Hey, I downloaded the phpMyAdmin thing but how do I install it onto my server? I'm using Linux but I am not too fluent in how Linux works. Could you give me a few pointers?

[scoutt]

Originally posted by sail3005
DUDE THATS AWESOME!

Thanks a LOT for showing me that!

It just made my life 5983624593765 times easier!

I thought you new about that program Sail? I guess not

Shogun: just take that program and insert it in your web directory in your server adn then make sure you configured the config.inc.php file so it has your mysql stuff in it.

then just run the index.php file and you are set.

[TheGoldenShogun]

This program is great! Thanks for the tip for it. I've been looking for a way to dump my database to a desktop file and you have it. Thanks Scoutt

[TheGoldenShogun]

this is cool and all but how do I prevent other people from using this tool. Right now if you go to my site and get the right path, you can just hack away at my database with the /index.php extension. Is there a way to prevent outside user access to that file?

[scoutt]

name it something else or use .htaccess to block that directory and use .htpasswd to secure it for your own use.

[TheGoldenShogun]

hmm... sounds interesting, how do I do that?

[chrisjk]

phpmyadmin has built in authorisation which interacts with Mysql's users

http://phpmyadmin.sourceforge.net/documentation/