Starting up mysqld at boot time as NOT root

2001-05-15 Thread Chris Lambrou [CGL]
Hello, This is more like a UNIX question: In our LINUX box startup file, we have an entry to start mysql. However, when the machine boots, mysql starts as root. How do we make it to start as mysqladm (the user we setup for mysql) Any help is much appreciated. Christopher Lambrou, CGL Compu

Re: RE: Auto_increment or manual??

2001-05-03 Thread Chris Lambrou [CGL]
For replication, yes, there will be a problem, but this has anything to do with mysql. You'd have the same problem with a Sybase identity field replicated to another database server. A possible solution is this: 1. have a separate table for generating counter fields. 2. make the replicated

working on binary data with jdbc

2001-05-02 Thread Chris Lambrou [CGL]
I am writing a java app that saves binary data into a mysql BLOB column. I am having trouble escaping the ascii(0) character. Since Java is unicode, how do you represent the ASCII 0 character? Any help is much appreciated. And sorry, but java sucks. I could do all the escaping in Perl in 1