Re: User and permissions/grants - HELP!

2003-10-28 Thread Patrik Fimml
> i dont think there's any privilege called "ALL PRIVILEGES". You need to say > just "ALL", like: > > GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY > '12345678' WITH GRANT OPTION; > GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH > GRANT OPTION; Maybe you should read the docum

Re: How to use the C API? (_not_ C++)

2003-10-25 Thread Patrik Fimml
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > If you're using PHP you want the Perl DBI stuff. The C API > is for C apps. If you are compiling a C application and > are having trouble linking, post your specific issues and > I'll be glad to help. Well, I tried it many times... here is the las

Re: How to best accomplish selecting string (unless it is null)

2003-10-25 Thread Patrik Fimml
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I have a select statement that selects two string (text) fields. In some > cases, the first of them may be NULL. In this case, I would like the > second field to be selected instead. It is also possible that in rare > cases that the second string

Re: compile error mysql-4.0.16

2003-10-25 Thread Patrik Fimml
ving directory `/usr/local/src/web/mysql-4.0.16' > make: *** [all] Error 2 It seems your GNU Compiler Collection does not support options -o, -c and -S, as well as multiple connections. You should try to get a new one (http://gcc.gnu.org/). Patrik Fimml -BEGIN PGP SIGNATURE- Vers

How to use the C API? (_not_ C++)

2003-10-25 Thread Patrik Fimml
mes - it didn't work. So maybe someone can explain me how to include the C API? I hope so. Patrik Fimml -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iQEVAwUBP5pgtZFyPD7t0rMPAQJJIQf+J1f9Ee7bAPdtwLvdkSmuMs9OHGaIar8w Tf9Ba7S7aHhU/bvvfjh/AHXGn0tcu8MdLGqZKhuc+cEE