[SPTUsers] installComplete.php

[Michael McFadden]

I am having another problem with the SPT--InstallComplete.php
Here is what is listed on the page after I enter the relevant info into
Install.php and hit continue.

The following problems were detected during installation:

	Could not successfully execute SQL command:


	CREATE TABLE APSessions (
	SessionId INT NOT NULL,
	LastActiveDate DATETIME NOT NULL,
	INDEX (SessionId)
	);

	(SQL error message: Table'APSessions' already exists)

I am using RedHat 8.0 w/ apache or httpd ver. 2.0.40-8, php ver.
4.2.2-8.0.5, mysql ver. 3.23.52-3

I created a Database called SPT and didn't create any tables that I know of.
I used the command:     mysqladmin create spt
Next I used the mysqladmin command to create a user and password.  I am not
sure how to get back into mysql to even verify that the Table APSessions
exists.
After I create the username and password I seem to be locked out.  If I try
to enter a command for example:  mysqladmin create whatever       I get an
error of:  mysqladmin:  connect to server at 'localhost' failed 
error:  'Access denied for user:  'root at localhost' (Using password: NO)'

Any help would be great like what command would I use to remove tables
within the SPT database or how now do I login to mysqladmin.  Or is there
something else I am missing.  I did install the mysql-php rpm so I am pretty
sure that php and mysql are talking to each other.

Michael McFadden
Meeting the Challenge
719-444-0252


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3170 bytes
Desc: not available
Url : http://scout.wisc.edu/pipermail/sptusers/attachments/20030312/496ec6de/winmail.bin