Hi Gareth,
I am sorry for the late response. Yes, I have got 13 columns.
MySQL that I use is
[EMAIL PROTECTED] ~]$ mysql --version
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
So, what version of mysql do you use? What distro do you use?
But probably you'd better set "Y" on all the *_priv columns except for
"Grant_priv" for the first query (for localhost access).
INSERT INTO db VALUES
('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
For % host and oscar user, you'd better set "Y" on
{Select,Insert,Update,Delete}_priv
INSERT INTO db VALUES
('%','oscar','oscar','Y','Y','Y','Y','N','N','N','N','N','N');
For anonymous user, you should set "Y" on only "Select_priv".
INSERT INTO db VALUES
('%','oscar','anonymous','Y','N','N','N','N','N','N','N','N','N');
I don't know what other of the columns would be in your MySQL but I am
sure that you can figure out what value you should put.
mysql> desc db;
+-----------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host | char(60) binary | | PRI | | |
| Db | char(64) binary | | PRI | | |
| User | char(16) binary | | PRI | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+-----------------+------+-----+---------+-------+
13 rows in set (0.00 sec)
Please let me know if you have any problems with this.
Regards,
- DongInn
gareth wrote:
> On Thu 2006-05-04 (11:04), DongInn Kim wrote:
>
>> 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.
>>
>
> ah ok.
>
> i assume i run 'use msyql' first. i then get:
>
> mysql> INSERT INTO db VALUES
> ('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
> ERROR 1136 (21S01): Column count doesn't match value count at row 1
>
>
> the db table exists, how do you check it's structure?
>
>
> -------------------------------------------------------
> 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
