PDA

View Full Version : MySQL Tutorial needed



DGentry
September 30th, 2007, 04:47 PM
I followed the instructions on setting up my LAMP system.
I have Apache working since I can see something when I look at localhost.

But now I'm wondering how I make MySQL work?
How do I know if it's installed correctly.
If it is, how do I create a database
After I do create a database, how to link it with apache.

Can anyone suggest some good books or web page that would great for a newbie?

southernman
September 30th, 2007, 05:52 PM
Most anything you want / need is found in The MySQL Reference (http://dev.mysql.com/doc/refman/5.0/en/index.html).

Just setting up a fresh copy of MySQL? Give this a thorough read (http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html)... and apply it to tighten up the security of your installation a bit.

How to create a MySQL Database... The tutorials section is a good place to start (http://dev.mysql.com/doc/refman/5.0/en/tutorial.html)... refer to section 3.3

PS. MySQL in and of itself doesn't exactly fall into the camp of newbie friendly, likewise a lot of the documentation doesn't either.

Have fun! :)