Re: CocoaMySQL access to db

2004-07-09 Thread Bill Allaire
Peter, My apologies on calling you Paul in my previous response instead of Peter. On Jul 9, 2004, at 10:30 PM, Peter Paul Sint wrote: Bill, thank you for the prompt help. This works. I have just to find out how to get the Startup Item (or some replacement) to open MySQL with --old_passwords (ju

Re: CocoaMySQL access to db

2004-07-09 Thread Bill Allaire
Paul, You can place --old-passwords (without the leading dashes) in the my.cnf file under the option group [mysqld] instead of passing it on the command line. The my.cnf file probably isn't on your system by default, at least it wasn't on mine until I created it. This file is generally placed

Re: CocoaMySQL access to db

2004-07-09 Thread Bill Allaire
Your problem may have to do with the difference in how 4.1.x+ does password hashing and that method is incompatible with older clients. You might find some help with this document: http://dev.mysql.com/doc/mysql/en/Old_client.html Specifically check out the information regarding resetting the pa

Re: Very strange database behavior

2004-07-07 Thread Bill Allaire
Paul, Has this class worked properly in the past? Have you tried executing the queries your class executes manually via the mysql client or a similar application removing your Java code from the equation? Have you run 'check table' if the table is either MyISAM or InnoDB? On Jul 7, 2004, at 1

Re: optimizing inserts

2004-05-16 Thread Bill Allaire
On May 16, 2004, at 1:15 AM, Ron Gilbert wrote: I have a table that is: CREATE TABLE GPSData ( ID int(10) unsigned NOT NULL auto_increment, Lat decimal(9,5) default '0.0', Lon decimal(9,5) default '0.0', TDate datetime default NULL, PRIMARY KEY (ID), UNIQUE KEY ID (ID), KEY ID

Re: Using 3.23 and Delphi 6

2003-02-26 Thread Bill Allaire
MyConnection -> TMyQuery (also to a database) -> DataSource -> DBGrid Bill Allaire Polytop Corporation The Glide wrote: Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database

Re: Starting MySQL Server

2003-02-25 Thread Bill Allaire
Try: safe_mysqld --user=user & Bill Jeremy Whitlock wrote: MySQL List, In Linux, I use: [EMAIL PROTECTED] bin]$ safe_mysqld --user=user to start the MySQL Server where user is a user in the database. When this happens, the terminal that I start it in become unusable. Is this by desi