Page 1 of 1
creating database problem
Posted: Wed Feb 16, 2005 8:01 am
by Robin
The server my website is hosted at is a shared server, which means I'm not user root. This is somewhat of a problem, since I need to create a database like this:
3. Create the cms database and grant a user rights to use it:
- login to mysql: mysql -u root -p
create database cms;
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
quit
Anyway, a possible solution would be to just create a database called robin_cms, which is something I can do and then just change the config file. The only problem with that solution is that my config file is blank.
Any ideas??
creating database problem
Posted: Wed Feb 16, 2005 10:38 am
by Robin
Patricia wrote:yes you can do like this:
create robin_cms as a new database
the config file is blank before install, try pointing to
[yourinstallfolder]/install/install.php if it doesn't redirect automatically
in database info, enter robin_cms as database name, and your usual database username and password, this work even on a shared environement (I have one install in this same situation)
Cheers and do not hesitate to ask more in case of need
Oh right, thank you so much. I get it now. You've been a great help.
creating database problem
Posted: Wed Feb 16, 2005 4:20 pm
by Robin
One last question, what do I have to do when it says:
Warning: install directory still exists. Please remove it completely.
Do I have to remove the entire admin directory with its contents?? That seems like a bad idea.
creating database problem
Posted: Wed Feb 16, 2005 4:55 pm
by Ted
Not the admin directory, the install directory. doc_root/install
creating database problem
Posted: Wed Feb 16, 2005 8:35 pm
by Robin
wishy wrote:Not the admin directory, the install directory. doc_root/install
Oh right, that makes more sense.