Hi,
I am sorry for asking stupid questions, but I am at the end
of my trials. I simply want to setup a user who can
connect from anywhere and write some table and read from
another one. Here's what I do:
GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO
dataexport@localhost IDENTIFIED BY 'somepassword';
GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@localhost
IDENTIFIED BY 'somepassword';
GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO
dataexport@"%" IDENTIFIED BY 'somepassword';
GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@"%" IDENTIFIED BY
'somepassword';
FLUSH PRIVILEGES;
Looking into the tables "tables_priv" and "user", everything
looks good. So does the output of SHOW GRANTS for dataexport@localhost.
However, it still doesn't work. (See output below.) Any ideas,
what might be wrong?
Thanks,
Jochen
C:\cvs12\tm>c:\Programme\mysql\bin\mysql mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 674 to server version: 3.23.39-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO
dataexport@localhost
IDENTIFIED BY 'somepassword';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@localhost
IDENTIFIED
BY 'somepassword';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO
dataexport@"%" IDENTIFIED BY 'somepassword';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON sessiondb.LANGUAGELIST TO dataexport@"%" IDENTIFIED
BY
'somepassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
C:\cvs12\tm>c:\Programme\mysql\bin\mysql --user=dataexport
--password=somepassword sessiondb
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 675 to server version: 3.23.39-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from sessiondb.LANGUAGELIST;
ERROR 1142: select command denied to user: 'dataexport@localhost' for
table 'languagelist'
mysql> quit
Bye
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
