I'm having some difficulty with a program I wrote
which uses the MySQL C api. I'm trying to migrate
my server from version 4.0 to version 4.1.
I have no difficulty connecting to the server using
the mysql.exe command line utility, but when I try to
connect from my program using the same
Password hashing was changed in 4.1 to improve authentication security, but
this complicates backward compatibility. See the manual for details:
http://dev.mysql.com/doc/mysql/en/old-client.html
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Your best bet is to link your app against
On Fri, 25 Mar 2005, Michael Stassen wrote:
Password hashing was changed in 4.1 to improve authentication security, but
this complicates backward compatibility. See the manual for details:
http://dev.mysql.com/doc/mysql/en/old-client.html
On Fri, 25 Mar 2005, Andrew Prock wrote:
On Fri, 25 Mar 2005, Michael Stassen wrote:
Password hashing was changed in 4.1 to improve authentication security, but
this complicates backward compatibility. See the manual for details:
http://dev.mysql.com/doc/mysql/en/old-client.html
Hello Mark,
thanks for your answer. In fact the mysql shell where I update the row is
using AUTOCOMMIT=1.
Even after I issue a COMMIT manually the changes are not seen by the
application.
What I dont understand is that the program doing a SELECT has to issue an
COMMIT to have all data available.
Hi Stefan,
Does the second shell actually perform those changes? In this case, I
assume
it's got something to do with the isolation level / consistent read in
InnoDB tables. shell1 sees all its changes immediately, shell2 (the
application) has just a snapshot of the data at the time it
Heri,
H. Steuer schrieb:
Hi Stefan,
Does the second shell actually perform those changes? In this case, I
assume
it's got something to do with the isolation level / consistent read in
InnoDB tables. shell1 sees all its changes immediately, shell2 (the
application) has just a
Heri,
- Original Message -
From: H. Steuer [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 03, 2002 11:49 AM
Subject: Re: C API problems with InnoDB
Hello Mark,
thanks for your answer. In fact the mysql shell where I update the row is
using AUTOCOMMIT=1
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls a database every 30 seconds. When the application
starts everything seems to be fine.
During the running of the application i change some rows, but the
application itself doesnt see the changes
7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: H. Steuer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 10:29 PM
Subject: C API problems with InnoDB
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
H. Steuer wrote:
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls a database every 30 seconds. When the application
starts everything seems to be fine.
During the running of the application i
hi there
the present serves for some clearing some doubts i have:
1 - if i wanna make an action based on the fact that a query i just made
won't return results (empty set), how can i test that?
will this do?
if(!mysql_query(myData, query)
{
results = mysql_store_results(myData);
1 - if i wanna make an action based on the fact that a query i just
made
won't return results (empty set), how can i test that?
will this do?
if(!mysql_query(myData, query)
{
results = mysql_store_results(myData);
if(mysql_num_rows() == 0)
{
//action;
}
}
On Saturday, 29. June 2002 11:15, Hugo Veiga wrote:
Hello Hugo,
will this do?
if(!mysql_query(myData, query)
{
results = mysql_store_results(myData);
-if(mysql_num_rows() == 0)
+if (!mysql_num_rows(results))
{
//action;
}
}
with the above correction it should
Message-
From: HaB JacKaL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 9:10 AM
To: [EMAIL PROTECTED]
Subject: C API problems
Can someone give me a quick *complete* example code of setting up a
connection, performing a small query, and reading back the result?
The docs
-Original Message-
From: HaB JacKaL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 9:10 AM
To: [EMAIL PROTECTED]
Subject: C API problems
Can someone give me a quick *complete* example code of setting up a
connection, performing a small query, and reading back the result
Hi,
Attached is my test program while exercising the C API of the MySQL.
Of course I have replaced the host name, user name, password and database
name with dummy ones.
I am using RH 6.1. The MySQL version is 3.22.
Essentially you need to do
#include mysql.h
...
main()
{
MYSQL
Can someone give me a quick *complete* example code of setting up a
connection, performing a small query, and reading back the result?
Any of the standard MySQL clients included in the source distribution
that are written in C provide examples. Some are more brief than others.
Another source
man ldconfig
If you are running Linux, add the library directory to ld.so.conf
and run ldconfig.
Your linker does not know about the libraries.
my limp wrote:
can any one help me. I am trying to connect to mysql database via a c
program. The program compiles fine but I keep on getting the
Hi!
I'm having problems compiling the example programs provided with the
MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on
longlongs. Does anybody know hot to get around this? What files should be
included in the project?
Thanks in advance on any info,
Kristian Lukander writes:
Hi!
I'm having problems compiling the example programs provided with the
MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on
longlongs. Does anybody know hot to get around this? What files should be
included in the project?
Thanks in
21 matches
Mail list logo