> Also remember to set your root password! Check the manual for this as
well.
Yeah, right... That's easier said than done!
I'm still chasing my tail from using the erroneous commands the install said
to use.
Speaking of which, someone thankfully told me to do a USE mysql before using
the UPDATE command, which then returned yet another error:
mysql> USE mysql
Database changed
mysql> UPDATE user SET Password=PASSWORD("letmein") WHERE User="root"
ERROR 1175: You are using safe update mode and you tried to update a table
without a WHERE that uses a KEY column
So any ideas that get me fixed up will be rewarded by copius quantities of
liquor and massages! ;)
Using GRANT though, I can get root password set up, but only until
restarting server.
Now for the Snitz Forum 2000 part (that's why I'm using MySQL and
Chili!ASP). Snitz says I need to start an empty database prior to running
setup.asp, yet I believe Snitz looks to this database for the user/password.
When I do a mysqladmin create blahbblah, it just make a directory, is that
an empty database? I would have thought it at least had some files, ie.
tables and such but without any info in them.
If I run setup.asp it says I need to logon first.
This is the Snitz error when running setup.asp?RC=5 after I add root and
root password where indicated:
=================
Please Wait until the installation has been completed !
Error:
3704
strSql:
DROP TABLE IF EXISTS FORUM_CATEGORY
Error:
3704
strSql:
CREATE TABLE FORUM_CATEGORY ( CAT_ID INT (11) DEFAULT ''
NOT NULL auto_increment, CAT_STATUS SMALLINT (6) DEFAULT
'1'
NOT NULL , CAT_NAME VARCHAR (100), CAT_MODERATION int
(11) DEFAULT '0', CAT_SUBSCRIPTION int (11) DEFAULT '0',
CAT_ORDER int (11) DEFAULT '1', PRIMARY KEY (CAT_ID),
KEY
FORUM_CATEGORY_CAT_ID(CAT_ID), KEY
FORUM_CATEGORY_CAT_STATUS (CAT_STATUS) )
===================
... and many more 3704 errors
Now if I enter root and leave password blank, it says Installation Complete
and has a test database link, I take the link and it's back to the "need to
logon" error page.
I am posting this at the Snitz forum and the mysql list.
Thank you very much,
eeehaah/Gregg Baker
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
