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 documentation

Re: compile error mysql-4.0.16

2003-10-26 Thread Patrik Fimml
/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- Version: GnuPG v1.2.3 (GNU/Linux

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

2003-10-26 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: How to use the C API? (_not_ C++)

2003-10-26 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 last:

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

2003-10-25 Thread Patrik Fimml
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+cEEfGuNrgnXJXEjGnV4+RvL