yep. but that does only apply when using INSERT INTO, right?
GRANT should do that by itself?
anyway, it didn't help. didn't help to restart mysqld either.
mysql> select * from db where user='datatal';
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv
| Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
Create_tmp_table_priv | Lock_tables_priv |
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| % | phonewatch | datatal | Y | Y | Y | Y
| N | N | N | N | N | N | N
| N |
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
mysql> select * from db where user='datatal';
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv
| Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
Create_tmp_table_priv | Lock_tables_priv |
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| % | phonewatch | datatal | Y | Y | Y | Y
| N | N | N | N | N | N | N
| N |
+------+------------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
> -----Ursprungligt meddelande-----
> Från: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 11:03
> Till: Datatal AB - Gauffin, Jonas
> Ämne: AW: GRANT problem
>
>
> Hi Jonas,
>
> did you send a 'FLUSH PRIVILEGES' after the GRANT-Statement ?
> If not, MySQL-Srver doesn't read the privileges-Table again.
>
> mfg
> Klaus
>
> -----Ursprungligt meddelande-----
> Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 10:44
> Till: [EMAIL PROTECTED]
> Ämne: SV: GRANT problem
>
>
> Additional info:
>
> the user is added to mysql.user with no privileges.
> the user is added to mysql.db with
> insert,update,delete,select privileges on phonewatch db.
>
> When I try to connect to the db, "C:\mysql\bin\mysql
> phonewatch -h ts2test -u datatal -pMYPASSWORD", I get "ERROR
> 1045: Access denied for user: '[EMAIL PROTECTED]'
> (Using password: YES)"
>
> please help
>
> > -----Ursprungligt meddelande-----
> > Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
> > Skickat: den 23 oktober 2003 09:15
> > Till: [EMAIL PROTECTED]
> > Ämne: GRANT problem
> >
> >
> > Hello
> >
> > I've created an account by using:
> > GRANT insert,update,select,delete on phonewatch.* to datatal
> > identified by 'MYPASSWORD'
> >
> > I cant connect(mysql.exe or myodbc) to the db with the new
> > account, and I did not receive any errormessages when
> > creating the account. Have I forgot something?
> >
> > Med vänlig hälsning/Best Regards
> > Datatal Utveckling AB
> > Jonas Gauffin
> > Tel direct: +46 (0) 498 25 30 16
> > Tel Support: +46 (0) 498 25 30 30
> > Fax: +46 (0) 498 25 30 99
> > http://www.datatal.se
> >
> > "I try every day, but sometimes I fail"
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?> [EMAIL PROTECTED]
> >
> >
> >
>
>
> --
> MySQL General Mailing
> List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
