Sorry, I maight not have been clear about what I wrote, there is only
one user account in mysql and that user is ola, I was saying that
username Administrator only exist in Windows 2000 Server and not in
MYSQL, and that because each time, I log into the PC as Administrator
and not as user ola who is the only user account on MYSQL. since mysql
starts as a service, does it automatically see that admin is logged on
and not Ola and that is why I get error 1064? Are you saying if I create
username Administrator and GRANT the account all privileges on the
database that I am using, then I would not have this error?
Thanks
>>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/29/03
12:06PM >>>
If your query has worked in one account, but not in another, then your
1064 error is probably related to privileges granted to the second
account.
HTH
>>> "Ola Ogunneye" <[EMAIL PROTECTED]> 07/29/03 09:08AM
>>>
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...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
