Re: creating database and user
Posted: Thu Sep 24, 2009 4:11 pm
To echo Ollie Saunders more information is needed to help you:
a) who are you hosting with?
b) do you have (or can you get) SSH access to the server?
c) does the server have MySQL installed on it?
d) is the username and password for MySQL on the server accurate?
Also, I might add that the code you posted will only work correctly the first time it runs because you can only create a database once.
That is, running the query " create database $database_name" will create a database the first time, but every time you try it after that it will return an error because the database $database_name will already exist....
a) who are you hosting with?
b) do you have (or can you get) SSH access to the server?
c) does the server have MySQL installed on it?
d) is the username and password for MySQL on the server accurate?
Also, I might add that the code you posted will only work correctly the first time it runs because you can only create a database once.
That is, running the query " create database $database_name" will create a database the first time, but every time you try it after that it will return an error because the database $database_name will already exist....