RE: Invalid SQL..?

thank you.. for your answer... i think i know what wrong it is.. :). -Original Message- From: quot;Chris Boltquot; lt;[EMAIL PROTECTED]gt; Date: Wed, 25 Jul 2001 22:29:00 -0600 To: lt;[EMAIL PROTECTED]gt; Subject: RE: Invalid SQL..? Re: gt;gt;gt; Database error: Invalid SQL: select

Record ID

Hello, what is the best way to handle record id in MySQL? Has MySQL some kind of automatic record id? /Peter -- I´m using MySQL 3.23.39-nt, Windows 2000 Server --

charsets on win32 mysql

Hi, File 'c:\mysql\\share\charsets\?.conf' not found (Errcode: 2) Character set '#26' is not a compiled character set and is not specified in the 'c:\mysql\\share\charsets\Inde What this error means ??? i have these settings: [mysqld] basedir=C:/Program Files/MySQL datadir=C:/Program

RE: Record ID

if you need a record id which increments automatically, then you can use the int types( tiny, medium or int) with the attribute that it be unsigned and auto_increment like this: record_id mediumint unsigned not null auto_increment regards shane -Original Message- From: Peter Wiherkoski

3.23.40 Win32 version

Hi all, I couldn't find the latest 3.23.40 Version available under Win32. Does anybody know when it would be released? Thanks. Regards, Michael

MySql Server creating problem

hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket'

RE: Record ID

Hello, what is the best way to handle record id in MySQL? Has MySQL some kind of automatic record id? if you need a record id which increments automatically, then you can use the int types( tiny, medium or int) with the attribute that it be unsigned and auto_increment like this: record_id

Various Issues the Mysql Community seems to be raising

I have been a member of this list for a week now and have read with interest the issues that are raised. I have tools that will resolve some of these issues especially for new users of MySQL. I know this list probably should not be used as a sales forum but I do believe I have a tool that will

java mysql

Hi, I have a Java program, from which I'm accessing the data in a mysql database via jdbc. I want to run the program on linux and on windows, without changing the code. I was using the jdbc-odbc driver on Windows, but on linux I can't use this. I would be glad, if someone knows, how to manage

Procedures

I need to use procedures in mysql. Does somebody know, what is the easiest way? I hear, that it is possible to compile new procedures to mysql, but I don't know how! Thanks Michal - Before posting, please

Error in linking MySQL 4.0

I'm getting this when I'm trying to compile MySQL 4.0. Is it something wrong with my thread library? Red Hat 6.1, glibc 2.1.2-11 ../pstack/libpstack.a(linuxthreads.o): In function `linuxthreads_notify_others': linuxthreads.o(.text+0x16): undefined reference to `__pthread_handles_num'

MySql Server creating problem

Hello Selva, the best way to start the server is: 1. change to your mySQL-directory and then: 2. ./bin/safe_mysqld starts the damon via script in the background () Alles wird gut! [;-)] Christian

RE: java mysql

Hi Sibel, on linux, you just d/l the mmmysql jdbc driver and place the mysql_uncomp.jar in the classpath. and then do a 1. GRANT ALL ON db_name.* TO user_name@host_name IDENTIFIED BY your_password. 2. set your path for your jdk/bin 3. u are up and running! u don't need to make any modifications

Re: java mysql

In your Java app on Linux, change the db connection string to point to the old MySQL db server in Windows. For Linux, you can download MM JDBC driver from MySQL Contribution. Install and set-up by following the instruction. Set your dbURL =

Urgent help needed, is this a version bug?

Hello John, are you sure, that the user test with password test1 exist in your Grant-Tables and has rights to INSERT ??? [;-)] Gruß Christian john zie wrote: Mysql: We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works fine, however when we test a php file

Re: Record ID

On Thu, Jul 26, 2001 at 10:17:56AM +0200, Peter Wiherkoski wrote: Hello, what is the best way to handle record id in MySQL? Has MySQL some kind of automatic record id? if you need a record id which increments automatically, then you can use the int types( tiny, medium or int) with the

Re: Compile Error Tru64 __cxa_pure_virtual

Kundiger, Rick writes: When compiling with gcc3.0 mysql 3.23.4 I get the following error trying to link the mysqlbinlog (I think) any idaes? Rick lmach -lexc mkdir .libs gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions

localisation error - please, please help me

Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration

Re: Procedures

=?iso-8859-2?Q?Michal_Proke=B9?= writes: I need to use procedures in mysql. Does somebody know, what is the easiest way? I hear, that it is possible to compile new procedures to mysql, but I don't know how! Thanks Michal Check our manual on UDF's. -- Regards, __

Re: Multiple Tables

I am overlooking something as for the code to update the user table. Maybe it would help to make it more concrete. Assume that I create two tables with the following statements: CREATE TABLE system ( sysid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, sysname VARCHAR(12), os VARCHAR(10), cpumhz INT

Re: Multiple Tables

Philip Montgomery writes: I am overlooking something as for the code to update the user table. Maybe it would help to make it more concrete. Assume that I create two tables with the following statements: CREATE TABLE system ( sysid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, sysname

RE: MySql Server creating problem

hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket'

Re: Multiple Tables

I want to associate John Doe with system1. How do I get mysql to extract the sysid from the system table and then update the user table with the sysid and the username? Thanks, Phil This feature is scheduled to come up in 4.0, which will be released this Autumn. So in release

MySQL Tests

Sir/Madam: I installed MySQL 3.23.40 on Linux 6.2 and am having trouble running the tests: Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perlte_perl/5.005 .) at ./run-all-tests line 36. Line 36

MySQL Tests

Sir/Madam: I installed MySQL 3.23.40 on Linux 6.2 and am having trouble running the tests: Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl/5.005 .) at ./run-all-tests line 36. BEGIN

Re: MySQL Tests

On Thu, 26 Jul 2001 09:32:47 -0400, Cavo Vincent Civ AFRL/SNRT [EMAIL PROTECTED] wrote: I installed MySQL 3.23.40 on Linux 6.2 and am having trouble running the tests: Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503

joining two databases

HIi, i'm new to the list, i have a problem and i hope you have the answer. i have 2 mysql servers, i need to run a query that joins two tables from two databases on the two servers, how can i do this? Motasem. - Before

MFC

Hi, I’m new two this list as well, and I was wondering if anyone know how to connect an MFC application to a remote database? It works fine with my local database but when I come to create a file DSN for the remote one using MyODBC, it wouldn’t connect. Any ideas? Thanks.

Mysql Version 3.23.37

Hello, I downloaded the Mysql application from your site and installed it. While trying to start for the first time the MySQL with winmysqladmin.exe. I encountered some problems using your Readme file . I chose the mysqld-nt and then you say Choose 'create my.ini' file I couldn't find it,

Re: mysql and credit cards

On Wednesday 25 July 2001 17:53, Elvis wrote: You can always degrade the credit card. 1) verify AUTH ONLY (not capture) with your CC provider. (if you want to verify they have funds available and the CC is valid) 2) store the CC # in the database 3) ..do your order processing thing or

Re: Compiling MySQL 3.23.39 on FreeBSD 4.3

Hi Juraj, I don't see an anwser to your request, so I will tell you that I have no problems compiling 3.23.39 or .40 or FBSD 4.3-release or stable. Here is my compile script rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \

Re: stability of freebsd 4.3, gcc 2.95.3

Allen, Sorry to take so long to reply I have been away, and will be away again in a few hours. Try this is a shell script: rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure $DEBUG --enable-large-files --with-berkeley-db

help on connection mysql

hello everybody: When I deal with my database log_db using mysql on linux, I meet with a problem like this: 1.the command is: #mysqlimport --local log_db http_tb --fields-terminated-by , but mysql run wrong .There are what mysql print out : Error: lost connection to

Re: Moved MySQL to new machine.

13 is access denied. Your /var/lib/mysql ( Or whatever ) is owned by root, and mysql can not create a new directory. Jeremy wrote: I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following

Re: mysql and credit cards

So sprach »Fletcher Sandbeck« am 2001-07-25 um 15:08:48 -0700 : I would counter that symmetric encryption is reasonably easy to implement and provides a modicum of security, so why not go ahead and do it. Just don't be fooled that a determined individual won't be able to defeat your

Mysql Security

Hello Is it possible to authenticate a user running mysql client by comparing the unix username($LOGNAME) with the user table in mysql.It seems more secure than specifying the authenticaton parameters in a configuation file or along with the client. Thanks Sachin

[fwd] Re: Re: mysql and credit cards (from: mysql@lists.mysql.com)

database,sql,query,table So sprach =BBPeter van Dijk=AB am 2001-07-25 um 23:59:48 +0200 : That is only true for a parallel cipher. A non-parallel cipher (like Yep, that's why I said symetrical encryption. Asymetrical enc.'s work like you explained. Alexander Skwar -- How to quote:

[fwd] Re: mysql and credit cards (from: ASkwar@DigitalProjects.com)

So sprach »William R. Mussatto« am 2001-07-25 um 23:01:49 -0700 : But what happens when the customer returns the product? You no longer have the cC to do a chargeback Have him enter it again. Explain that this is done to increase the security and he may be fine. If not - well he's already

Re: mysql and credit cards

So sprach »Alexander 'Digital Projects' Skwar« am 2001-07-26 um 18:48:15 +0200 : MySQL's builtin ENCRYPT() function is good enough. No need to worry Uhm, is ENCRYPT decryptable? Anyhow, I was rather thinking about ENCODE()/DECODE(). PS: filter sql Alexander Skwar -- How to quote:

Re: Uploading files using PHP to database.

Could anyone shed some light on how to go about uploading a text file with a web interface using php into a mysql database. wow, that was a mouthfull. I would much appreciate it. Well, that depends. Do you want to store the native text file fully intact say like you might store an image

[fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)

Hi! Could someone please do anything about this? - Forwarded message from Mail Delivery Subsystem [EMAIL PROTECTED] - From: [EMAIL PROTECTED] (Mail Delivery Subsystem) Date: Thu, 26 Jul 2001 19:06:21 +0200 (CEST) Subject: Returned mail: Host unknown (Name server: mailserv: host not

Mysql Security

Hello my friend, shure its possible! additional you can insert into the user table of mysql the encryptet Password-Hash of your local etc.shadow-Phile to verify the correct Password and authenticate the the user. Hope it helps Christian sachin shetty wrote: Hello Is it possible to

CREATE SEQUENCE

Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - Before posting, please check:

Building MySQL on HPUX with InnoBase support

I have had problems building the MySQL database server when I include support of InnoBase DB files. During the build process I must use the HP/ANSI compilers. This causes an error while building the mach0data.c file in the mach directory in the InnoBase directory structure. Has anyone on HP-UX

Re: Mysql Security (fwd)

-- Forwarded message -- Date: Thu, 26 Jul 2001 13:15:06 -0400 (EDT) From: sachin shetty [EMAIL PROTECTED] To: Christian Grimm [EMAIL PROTECTED] Subject: Re: Mysql Security Thanks Christian But when a user connects to the server isnt it mandatory to specify the password?. Is

The old interfering with the young

Here's my problem: I had some pre-installed version of MySQL on a Linux machine that I didn't want to use or know how to dispose of properly and then installed a source distribution on the same machine. I've gotten the source distribution installed all right and everything seems to be working

Re: FW: encrypt

So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 : sa must be a 2-char long Salt-String... Which is completely optional :) sql,database,filter Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage:

Unix passwd file and mysql authentication table

Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table).If there is a module that handles this during connection of the mysql client to the server, then it saves the

Correct DISTINCT syntax for MYSQL version 3.22.32

Hi, I'm using MYSQL version 3.22.32. I have read that from version 3.23.xx COUNT can be used in combination with DISTINCT. However, I have a project deadline which does not give me time to upgrade. I have a small table 'web-stats' consisting of the following fields: IP_address web_date

Re: DISSERTATION2 [VIRUSES STRIPPED]

You have a virus on your system sending email with virus attachments. As a respected Individual or company in business, it is imperative that you fix your system by deleting the virus infection. Below are some simple steps you can take so it won't be sent to anyone else. WHY YOU NEED TO DO

Re: Mysql Security (fwd)

The fact that he has logged on should not require him to specify password again. This fact means: when a user is logged in, he is allowed to use the mysql-server: use this one:( every logged -on -user on localhost has all rights to every base and table without pw) GRANT USAGE ON *.* TO

access dbs to mysql dbs

Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Can't stop msqld

Hello all, I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server running apache and php. I could start msqld and shut it down. Then I created a password for root. Mysql still starts but I can't stop it as root or any other user. It runs as user mysql which also requires password.

Help Please OpenBSD Mysql

Has anyone ever seen this error. I have loaded mysql on a sparc running openbsd. I have asked on the opebsd list and searched for days on google and deja. But it seems as if mysql has a problem running on the sparc platform because others have ran in to this eact same problem but have not been