Hi Guys,
How can I disable autocommit in the database. Can this only be done per session as
opposed to having it done globally at the database level.
Last where can I get a complete list and explanation of the buffer/memory areas of
mysql.
I checked the manual and it was brief at best.
Thanks,
Hi Guys,
I am running winxp with mysql 5.0.
I am attempting to run this statement
mysql load data infile c:\\mysql\\pop.txt into table population
(lastname,firstname,age,sickness);
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
and then a
If you resize the password column to what it was pre 4.1 it will store a
hash the same length as the old algo used to produce and users will be able
to log in just fine.
Michael Stassen pointed me to this link
http://www.mysql.com/doc/en/Password_hashing.html. and it has a number of
work
Hi guys,
I posted a similar question on this the other day but received no answers.
I'm running 5.0 and have a possible security/password problem. If i run from command
line all users work with or without passwords.
If I try and connect to mysql through php,perl,python or odbc with a user that
] ;
I can access mysql from command line and these -(php,perl,odbc,python
etc...)
- Original Message -
From: Gerald R. Jensen [EMAIL PROTECTED]
To: jamie murray [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 2:05 PM
Subject: Re: mysql 5.0
Jamie:
I
.
cheers!
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: jamie murray [EMAIL PROTECTED]
Cc: Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 3:05 PM
Subject: Re: mysql 5.0
Password security was improved in version
Hi Guys,
I am running winxp with mysql. Seeing this is a home machine there is no workstation
just one computer which I guess at this point is acting as my server and client for
mysql. I am just getting acquainted with mysql so I have been playing around with both
4.1 and 5.0. Neither database
can you show the actual code for php that does this.
- Original Message -
From: Reza Milan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 26, 2003 1:55 PM
Subject: SQL Support
Dear sirs,
I installed PHP and MYSQL on my XP system.
All commands supported except sql and
Plinio,
Hence my suggestion for use of a flat file. The file can be located on the
db server middle tier wherever it doesnt matter.
The important part is that you control what goes in the file and its done
ahead of time not when an enduser presses a button.
What about creating tables the users can
I'm new to MySql as well but the LOAD DATA statement is probably what
your looking for. It's a bulk loader and dumps the data from a flat file
into a designated table for you. You could easily automate this by writing a
simple perl script(probably php also but im not to familiar with that
What about creating a flat file on the middle tier from the database system
tables that the clients can view with your gui or web page.
Only things is keeping the file in sync with the system tables. But access
will be faster to the flat file and no security risks
because there won't even be a
11 matches
Mail list logo