Page 1 of 1

Going nuts mysql installation

Posted: Sun Mar 02, 2003 9:48 pm
by lc
Ok well I think I've gone as far as I can with php & flatfiles.

So it seems a natural step to get into mysql, which means I have to run it on my machine. I have Apache & Php on a Windoze system, basicly.

Thing is... I can't seem to find a simple tutorial explaining everything... and I do mean everything.

I have no idea how it works. Where does mysql create these databases on your hard disk? How does php know where to find the program?

I have the installable windoze version of mysql on disk... installed it... but then what? what do I have to set?

I'm confused, have a slight headache. Don't really know where to start.

Posted: Mon Mar 03, 2003 2:12 am
by twigletmac
If you've installed MySQL and got it started then you've not far to go. If you get something like phpMyAdmin running then you can quickly create a database stick a table in it and put a bit of data in.

Check out Jason's tutorials:
http://www.phpcomplete.com/tutorials.ph ... adTutorial
http://www.phpcomplete.com/tutorials.ph ... adTutorial

MySQL stores each database's files within a folder (of that database's name) in the mysql/data directory - there are 3 files for each table in the database.

Mac

Posted: Mon Mar 03, 2003 9:35 am
by lc
thanks mac... I'll go have a looksee ;)

Posted: Mon Mar 03, 2003 10:37 am
by lc
I don't want to repeat myself.... ehm yes I do... thanks again. That works great. I had some trouble connecting to the internet for a bit but that seemed to be because the mysql bind adress wasn't set to localhost but to my net connection... woops. looks like it's all working now.

I'll never end will it? :lol: