r in test database because mysql.db table
has records which allows updates to any user, and database
privileges ORs with global privileges. Send us the contents
of your privileged tables. See:
http://dev.mysql.com/doc/mysql/en/request-access.html
Upgrade to the latest release 4.1.12 (4.0.24).
I tried the SHOW GRANTS statement
SHOW GRANTS FOR 'dtk10mv'@ 'localhost'
and got this:
Grants for [EMAIL PROTECTED]
GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc'
GRANT UPDATE (column1) ON database1.table1
Hello,
I want one of my MySQL-users only update one of my columns in a table. I
used
grant UPDATE (column1) on database1.table1 to 'user1'@'localhost'
but the user1 can update other culumns too.
The mysql-db-table entries for user1 after grant command are:
- db: -
- host: -
- user: Select_priv: Y
How should I do this?
$query="select oart_bez from oart";
$result=safe_query($query);
$result=sort($result);
while($wert=mysql_fetch_row( $result ))
{ print "" . $wert[0];
}
greetings, Wolfgang Gliese
---
