I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web.
Using geeklog as been okay until I tried creating moderators to my forum
and then I got the following error:
1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '' at line 1
My intuition is that because I start mysql as a service in win2k and so
each time I log onto my Win2k Server, mysql is running already. I
however log into win2k with username Administrator, while mysql root
user has been changed to my name ola, I believe that user Ola has all
the rights with the following setup string:
mysql> delete from user where Host='%';
mysql> delete from user where User='';
mysql> delete from db where Host='%';
mysql> update user set User='ola', Password=password('olapassword')
where User='root';
mysql> flush privileges;
With the above, I was able to create 3 databases, and I believe that
because of the above, then user ola is now the root user and should be
able to grant privileges to other users....
Does user ola need to be granted privileges in each database created
after executing the above commands or are they inherited since user ola
is now the root user?
Would manually starting Mysql with user ola correct the error 1064 that
I got from the other application?
Thanks in advance...
