Yup I found with the snapshot download I got on October 27th that I had to run the MySQL command,
ALTER TABLE nuke_users ADD COLUMN pn_last_visit DATETIME NOT NULL DEFAULT '0';
after I had loaded the setup.ddl as that particular line was commented out of the setup.ddl but is required else you can't logon.
I also had to edit prepare.ddl to remove the ' ' tics from the line,
ON nukes.* TO nukes@localhost WITH GRANT OPTION;
And for my system I had to edit the,
as follows: Change line 7 and replace,
Is there a reason to be using the Giant Java Tree definition as opposed to the MySQL.com one ?. Is GJT more future-proof or flexible over the MySQL one ?.
Same here, also, I had to add an entry into the MySQL user table for localhost.localdomain, which appears to be the target host when using jdbc on a redhat box with the localhost.localdomain /etc/hosts entry.
> Same here, also, I had to add an entry into the MySQL
> user table for localhost.localdomain, which appears
> to be the target host when using jdbc on a redhat box
> with the localhost.localdomain /etc/hosts entry.
yes it suxx sometimes on redhat for that.
oh also, according to the mysql documentation the use of single ticks (') is valid and recommended for hostnames and usernames with non alphanumeric characters such as '-'.
i modified the statement to the following to make it work (dropped some privileges):
grant select,insert,update,delete,create,drop,references,index,alter on nukes.* to nukes@'localhost' with grant option;
grant select,insert,update,delete,create,drop,references,index,alter on nukes.* to nukes@'localhost.localdomain' with grant option;