OK, now I think I found why you could not really do anything (not select
query but update/delete thing) on the oscar database.
INSERT INTO db VALUES
('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES
('%','oscar','oscar','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('%','oscar','anonymous','Y','N','N','N','N','N','N','N','N','N');
Please run the above queries and see if it works for you.- DongInn gareth wrote: > On Thu 2006-05-04 (10:51), DongInn Kim wrote: > >> OK, can I see if root or oscar user can access the oscar database and do >> any query on it. >> mysql> use oscar; >> mysql> show tables; >> > > yep those are both possible from the oscar and root user > > >> Can I get another sql query output? >> SELECT Host, User, Db FROM mysql.db; >> > > mysql> SELECT Host, User, Db FROM mysql.db; > Empty set (0.00 sec) > > >> BTW, what version of OSCAR have you installed? >> > > oscar-4.2.1r4033-20051208 > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Oscar-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/oscar-users > ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Oscar-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oscar-users
