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
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
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
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
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
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
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
