RE: mysql error logging

2005-03-08 Thread Daniel Fisla
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to connect to database: Access denied for user 'root'@'localhost' (using password: NO) Now for dropped sockets/connections you need to enable logging

RE: mysql *SERVER* error logging

2005-03-08 Thread Daniel Fisla
, March 08, 2005 3:23 PM To: Daniel Fisla; mysql@lists.mysql.com Subject: RE: mysql *SERVER* error logging --On Tuesday, March 08, 2005 15:03 -0500 Daniel Fisla [EMAIL PROTECTED] wrote: Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error Mar 6 05:39:11 orion pdns

Charsets, collation and connections.

2005-03-01 Thread Daniel Fisla
After doing much research I am at a loss how really utf8_bin and utf8_general_ci differ, besides the obvious -- sort order. What I inferred from MySQL docs and some online articles is the following. utf8_bin is pretty much what it suggests, utf8 strings are stored as bytes and MySQL server