View Full Version : setting up a mysql database

04-20-2008, 07:20 AM
okay so ive been reading up on php lately and im still confused with how to set up a mysql database. i mean there are scripts in the book but don't you have to go to your server and set one up? how do you set up a server to store all the information the users put in?

04-20-2008, 07:37 AM
Are you using phpMyAdmin (http://www.phpmyadmin.net/home_page/index.php)? Set it up if you can, makes managing mySQL databases a lot easier.

04-20-2008, 09:13 AM
It depends on where you want to set one up at. If you pay for webspace you likely have some sort of control panel that will assist you with the initial setup, which you can then use phpMyAdmin (http://www.phpmyadmin.net/) or similar to setup/modify the tables outside of your script. If, on the other hand, you're running a server locally, with XAMPP (http://www.apachefriends.org/en/xampp.html) or WAMP (http://www.wampserver.com/en/) for example, you would probably be more familiar with a GUI-based app, like HeidiSQL (http://www.heidisql.com/). This site has a forum specifically for MySQL questions, too, and a sticky thread (http://www.codingforums.com/showthread.php?t=91271) with some useful resources.