RE: SSH tunnel MySQL traffic..
Hi~ I have trouble with ssh tunneling. I run this command as you told. [wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost Secure connection to localhost refused; reverting to insecure method. Using rsh. WARNING: Connection will not be encrypted. localhost: Connection refused what's the problem? should I run sshd deamon? if then, how to configure sshd deamon? Thank you for advanced answer! ps. I installed MySQL 4.0 SSL connection support. But I cannot find any MySQL Client which support SSL connection. although MySQL 4.0 support SSL connection, still ssh tunneling required? Thank you! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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: Query Problem.
Why don't you try like this. F:\\devkunde\\SENDTNER\\ '\' is escape character. so you must use '\\' to insert '\'. Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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
SSL connection question Again!
Happy New Year! I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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
Embedded MySQL terminate abnormally.
I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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
SSL connection question.
I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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 : String comparison.
You should use binary attribute. mysql select binary fff= fff ; +-+ | binary fff= fff | +-+ | 0 | +-+ 1 row in set (0.28 sec) mysql select fff= fff ; +--+ | fff= fff | +--+ |1 | +--+ 1 row in set (0.00 sec) mysql select version() ; +---+ | version() | +---+ | 3.23.46 | +---+ 1 row in set (0.00 sec) when you create table... create table table_name ( a char(10) binary ... ) ; you can check white characters. Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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
When will Stable version 4.0 be released ?
Hi! I'll be happy if I know that when Stable version 4.0 will be released. Thanks! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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
Some questions About DBMS.
(I'm sorry if my question does not fit to this mailing list) Hi~ there.! Is there A Book about implementing RDBMS? I just found Database System Implementation written by Ullman. looking for another Book if there is. Monty, What's the Best Resource(helping you) when you have started making MySQL? Umm. MySQL AB Has any plan to make MMDB or Embedded DBMS? (Last month's survey asked us 'bout Embedded DBMS) Thank you for Avanced Answer! Member OF http://database.sarang.net http://www.nnr.or.kr --MIME Multi-part separator-- - 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
unaunthenticated user?
Hi~~~ My SHOW PROCESSLIST's output | 22 | unauthenticated user | 10.169.xxx.xxx || Connect | | login | what 'unauthenticated user' means? who is he? anonymous user? Thank you for your advanced answer! database --MIME Multi-part separator-- - 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