What's wrong with my GRANT example?

2001-06-25 Thread Jochen Wiedmann 


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\tmc:\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\tmc:\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

Stringifying MySQL C types

2001-06-15 Thread Jochen Wiedmann 


Hi,

does the MySQL client library contain any support for
a proper stringification of the MySQL specific data
types like my_ulonglong? IMO they are depending on the
operating system and I should not use ltoa() or similar
functions.

Thanks,

Jochen

-
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

Missing symbols in mysqlclient.lib in Win32

2001-05-20 Thread Jochen Wiedmann 


Hi,

while trying to link the DBD::mysql driver on a Win32 machine
I receive the following error message claiming about missing
symbols __pctype and ___mb_cur_max in mysqlclient.lib. As you
can see from the output below, I am linking against all .lib
files in the MySQL distribution. The paths are right.

I am not an experienced user, but in particular the symbol
__pctype looks like it should be a header definition actually.
I am using VC++ 6.0, SP3.


Any hint welcome.

Thanks,

Jochen



  C:\Perl\bin\Perl.exe myld link -out:blib\arch\auto\DBD\mysql\mysql.dll
-dll -nologo -nodefaultlib -release  -libpath:C:\Perl\lib\CORE
-machine:x86 dbdimp.obj  mysql.obj
C:\Perl\lib\CORE\perl56.lib
c:\Prg\mysql\lib\opt\mysqlclient.lib
c:\Prg\mysql\lib\opt\libmysql.lib
c:\Prg\mysql\lib\opt\zlib.lib
C:\prg\MVS\VC98\lib\oldnames.lib
C:\prg\MVS\VC98\lib\kernel32.lib
C:\prg\MVS\VC98\lib\user32.lib
C:\prg\MVS\VC98\lib\gdi32.lib
C:\prg\MVS\VC98\lib\winspool.lib
C:\prg\MVS\VC98\lib\comdlg32.lib
C:\prg\MVS\VC98\lib\advapi32.lib
C:\prg\MVS\VC98\lib\shell32.lib
C:\prg\MVS\VC98\lib\ole32.lib
C:\prg\MVS\VC98\lib\oleaut32.lib
C:\prg\MVS\VC98\lib\netapi32.lib
C:\prg\MVS\VC98\lib\uuid.lib
C:\prg\MVS\VC98\lib\wsock32.lib
C:\prg\MVS\VC98\lib\mpr.lib
C:\prg\MVS\VC98\lib\winmm.lib
C:\prg\MVS\VC98\lib\version.lib
C:\prg\MVS\VC98\lib\odbc32.lib
C:\prg\MVS\VC98\lib\odbccp32.lib
C:\prg\MVS\VC98\lib\msvcrt.lib
-def:mysql.def
  Creating library blib\arch\auto\DBD\mysql\mysql.lib and object
blib\arch\auto\DBD\mysql\mysql.exp
  mysqlclient.lib(str2int.obj) : error LNK2001: unresolved
external symbol __pctype
  mysqlclient.lib(my_init.obj) : error LNK2001: unresolved
external symbol __pctype
  mysqlclient.lib(charset.obj) : error LNK2001: unresolved
external symbol __pctype
  mysqlclient.lib(default.obj) : error LNK2001: unresolved
external symbol __pctype
  mysqlclient.lib(my_error.obj) : error LNK2001: unresolved
external symbol __pctype
  mysqlclient.lib(str2int.obj) : error LNK2001: unresolved
external symbol ___mb_cur_max
  mysqlclient.lib(my_init.obj) : error LNK2001: unresolved
external symbol ___mb_cur_max
  mysqlclient.lib(charset.obj) : error LNK2001: unresolved
external symbol ___mb_cur_max
  mysqlclient.lib(default.obj) : error LNK2001: unresolved
external symbol ___mb_cur_max
  mysqlclient.lib(my_error.obj) : error LNK2001: unresolved
external symbol ___mb_cur_max

-
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

Re: Trouble automating backup

2001-03-14 Thread Jochen Wiedmann 



Duncan Hudson wrote:

  $sth_backup = $dbh-prepare("BACKUP table ? TO ?");

You cannot embed table names or column names with the
placeholder. If you do, that will not be mapped to

BACKUP table foo

but to

BACKUP table 'foo'

which will most probably fail.

Use

prepare("BACKUP table $table TO $othertable")

instead.

-
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