View Full Version : Creating MySQL databases


twix2006
01-18-2007, 03:27 AM
I've been having trouble with one of my fanlistings for awhile and i finally figured out what the problem was--i had the wrong database entered! My hostess was switching sites and I still had the old site's database entered on my config page for enthusiast..and now MySQL isn't letting me connect because I don't have the new site's database name..is there any way that I can make one or does my hostess have to do it?

Idiotic Creation
01-18-2007, 04:47 AM
Well, as long as your sql server is set up, you should be able to create database your self. First I would check to see if you have phpMyAdmin (database manager) If you dont then you can create one by writing a few sql queries then executing them. Heres a nice tutorial.
http://www.w3schools.com/sql/sql_create.asp

Good Luck,
David

twix2006
01-18-2007, 09:58 PM
um..where would i insert that script?

djou
01-19-2007, 01:56 AM
Normally, if you are hosted with someone else, it is this person who has to create a database and give you the required information, which you must then change in your fanlistings config file. The snippets suggested above will not be needed if you use one of the common scripts like Enthusiast or PHPFanBase, as they already have their own create file.

twix2006
01-20-2007, 03:43 AM
oh no :( she isn't replying my emails and i only have until the 22nd to get this fixed :(