Page 1 of 1

Database

Posted: Thu 19. Mar 2009, 19:10
by bowyersden
Is MySQl fine for the database? I am trying a new install and locking at step 1. I am copying the DB name and DB user name right out of the web server info on my control panel. I re did the password several times to make sure it's the same.

I can't get past it. I would think once is me, but I have triple checked everything. Any ideas. Running on a windows platform

Re: Database

Posted: Thu 19. Mar 2009, 23:25
by nebenaube
yes it's fine... are you using odbc or is the server listening on the standard port? What are you using for a webserver? is mysql support compiled in /enabled? How about php?

Re: Database

Posted: Thu 19. Mar 2009, 23:30
by bowyersden
I got that fixed, Now it wants to create tables, but has an error.

Code: Select all

Errors while creating initial phpwcms tables. Solve it manually:
How is there errors? I did not change anything.

Re: Database

Posted: Thu 19. Mar 2009, 23:43
by nebenaube
When you created the database and user did you grant the user all access to the database? Do you have query logs from the database?

Re: Database

Posted: Fri 20. Mar 2009, 12:39
by bowyersden
The bold ones are the only ones selected. Do I need to select them all? I did not have to do this for a message board for phpbb3.
Privilege name
grant
lock tables
drop
create routine
create temporary tables
update
create
alter
index
execute
select
alter routine
show view
references
insert
delete

create view

Re: Database

Posted: Fri 20. Mar 2009, 12:40
by bowyersden
nebenaube wrote:Do you have query logs from the database?
Nube here, not sure where they are, if they are there.

Re: Database

Posted: Fri 20. Mar 2009, 13:45
by bowyersden
I check them all and got.
Fine! All initial phpwcms tables were created or still exists.
So it seems to work now.

Re: Database

Posted: Fri 20. Mar 2009, 13:51
by bowyersden
Crashed out on step 3 on setup to a white page.

That was after e-mail settings. I did not setup a php.ini file yet. Is that why is crashed?
EDIT
I used a comma. :oops:

Re: Database

Posted: Fri 20. Mar 2009, 18:29
by nebenaube
You're getting there. Your database user will also need to have the alter table privilege. Yes, you will need the php.ini. If you are setting this up on a development box (running on localhost, not on the net) You should turn the error logging on in PHP.ini It will help to track down any problems you are having.