Re: question about lock tables and unlock table

Hi Steven, Just one UNLOCK TABLES. :-) From http://www.mysql.com/doc/en/LOCK_TABLES.html LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases any locks held by the current thread. All tables that are locked by the current thread are implicitly unlocked when the thread issues

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

now allowing clients to login but I'm not sure what would cuse it not to allow root to change the password, I dubble and triple checked my entry but still nothing happens. Once I login to root I do the following mysql use mysql mysql UPDATE user SET Password= ('x') - WHERE

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

I figured it out. Actualy silly me forgot to add the password() function how embarising. :) -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query hung up in Copying to tmp table

Kevin, Forgot to mention that I think you're not seeing any temporary files because they're hidden. From http://www.mysql.com/doc/en/Temporary_files.html MySQL creates all temporary files as hidden files. This ensures that the temporary files will be removed if mysqld is terminated. The

group_concat()

I finally installed 4.1 alpha so I could test the group_concat function but need some help... could anyone give me a clue how I can order the results of group_concat() according to the lft field ? (just adding it per se wipes out the results) I have tried many many variations and have not hit

Re: Fulltext Index and Unicode (MySQL 4.1)

Egor Egorov wrote: Andreas Schwarz [EMAIL PROTECTED] wrote: is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) fields in 4.1? Nope. Fulltext search doesn't work with multi-byte character sets. Will this be fixed in future versions? Otherwise I would have to do the

Sobig.F on this list

I got a bounced email with an attachment entitled macex.mex.scr, about 72.3 KB, which if IIRC is probably the Sobig.F virus. It appears to have been sent to people on this list (even though the list wasn't in the to: line) because the body of the email discussed MySQL. Since Sobig.F forges the

MySQL on Windows 2000

Hi, We have installed PHP/MySQL on a Windows 2000 server. PHP MySQL are working fine on the server. We also require to connect ASP to MySQL database. How can we do that? Currently the MySQL/ODBC driver is not available on Windows 2000 server. How can we add that and proceed with ASP/MySQL?

Regular Expression Reference

I'm sure this is sitting inches from my nose but I just can't see it. In Appendix G of the manual it states: This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution. I can't seem

Help with the IN operator

I am having a bit of trouble with the IN operator. I am thinking that it just may be my misunderstanding. Situation. I have a table (ZipCounty) that I want to pull vendors from based on zipcode. So I have a Vendor like field declared as TEXT. To keep the table up to date, I issuse

Re: Regular Expression Reference

At 11:08 -0400 9/6/03, Jeff Brewer wrote: I'm sure this is sitting inches from my nose but I just can't see it. In Appendix G of the manual it states: This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included

Re: Fulltext Index and Unicode (MySQL 4.1)

At 11:25 + 9/6/03, Andreas Schwarz wrote: Egor Egorov wrote: Andreas Schwarz [EMAIL PROTECTED] wrote: is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) fields in 4.1? Nope. Fulltext search doesn't work with multi-byte character sets. That's correct. It's documented at:

Re: Help with the IN operator

You are misunderstanding the 'IN' operator Try and think of it this way SELECT value from table where field in (1,2,3) is the same as SELECT value from table where field = 1 or field = 2 or field = 3 So in you case SELECT Count(ID) FROM ZipCounty WHERE '528' IN (VendorLink); is SELECT

Re: Help with the IN operator

At 11:25 -0400 9/6/03, Roger Davis wrote: I am having a bit of trouble with the IN operator. I am thinking that it just may be my misunderstanding. Situation. I have a table (ZipCounty) that I want to pull vendors from based on zipcode. So I have a Vendor like field declared as TEXT. To

Re: Fulltext Index and Unicode (MySQL 4.1)

Hi! On Sep 06, Andreas Schwarz wrote: Egor Egorov wrote: Andreas Schwarz [EMAIL PROTECTED] wrote: is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) fields in 4.1? Nope. Fulltext search doesn't work with multi-byte character sets. Will this be fixed in future

Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10

Hello I have a C app that uses libmysql.dll provided with MySQL 4.1.0-max-nt distribution. I am trying to connect to a remote server running MySQL 3.23.47 and I get the error - Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10 whenever I try to connect using