Re: Mysql..Python..

> My sense is that it's not as popular for use with MySQL as PHP or > Perl, but yes, there are people using it. A few of the MySQL books > out there have descriptions of how to use the Python interface for > MySQL, and (shameless plug) it's one of the 4 languages covered in > the upcoming MySQL C

Mysql..Python..& ..MSQLdb

I have been using perl and Mysql together but have decided to try python and Mysql together. I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. The module does not seen to have instructions for use. Can anyone point me to intructions or examples. My purpose is a user friendly GUI

Re: 3.23.43 fails merge test ON make test of src.

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > > > R> Below is My bug report... > R> Mysql 3.23.40 is runjning after the compile but, > R> after a compile with errors 3.23.42 or

Re: 3.23.43 fails merge test ON make test of src.

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > R> Hi! > >>>>> "rjtalbo" == rjtalbo <[EMAIL PROTECTED]> writes: > > rjtalbo> I am using Mysql 3.23.40 on Linux ke

mysql-3.22.33

Please solve the problems # # groupadd mysql # useradd -g mysql mysql # cd /export/home0 # gunzip < mysql-3.23.33.tar.gz | tar xvf - # cd mysql-3.23.33 # ./configure --prefix=/usr/local/mysql # make make all-recursive I have compiled 3.22.32, ...3.23.40.. 3.23.42 All on Linux w/ kernel 2.2.10

Mysql GUI doesn't like localhost/ New Install..

I obviously missed something because I have installed MySQL many times but this time MySQL GUI would not except localhost in MySQL GUI Options.. but it would work with the actual Host name. Note same versions of all the above with the same Linux kernel work on two other installs.. All have localh

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: R Talbot wrote: Still having compile problems and GNU binary produces the following info > Michael Widenius wrote: > > > > The problem is probably that your tar >program doesn't use user-names > > > but user-ids, in which case the

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > R Talbot wrote: > > > R Talbot wrote: > > > > > Michael Widenius wrote: > > > > > > > > > > > > > > The problem is probably that your tar program doesn't use user-names > > > > > > >

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > R Talbot wrote: > > > Michael Widenius wrote: > > > > > > > > > > The problem is probably that your tar program doesn't use user-names > > > > > but user-ids, in which case the files may be owned by 'anyon

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > Michael Widenius wrote: > > > > > > The problem is probably that your tar program doesn't use user-names > > > but user-ids, in which case the files may be owned by 'anyone. > > > What output do you get for: > > >

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Michael Widenius wrote: > > The problem is probably that your tar program doesn't use user-names > but user-ids, in which case the files may be owned by 'anyone. > What output do you get for: > > ldd bin/mysqld > [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root root 1832912 Se

Re: Help - I'm completely locked out of mysql

Derek Fage wrote: > Hi Bob, > > Sorry to appear a bit dense, but how do I use the -Skip-grant? > > I don't see a -Skip-grant option in mysql (mysql --help) > > Thanks, > > Derek... > > -Original Message- > From: R Talbot [mailto:[EMAIL PROTECT

Re: Compiled v. 3.23.40 and 3.23.42to 12 test Failures

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > R> Monty, > R> Took your advice and downloaded > R> mysql-3.23.42-pc-linux-gnu-i686.tar.gz > R> Placed it in /usr/local > R> Rena

Help - I'm completely locked out of mysql

> mysql >Subject: Help - I'm completely locked out of mysql >From: Derek Fage <[EMAIL PROTECTED]> >Date: 2001-09-22 14:36:08 >[Download message RAW] > Hi there, If your forgot yout root password try #/bin/mysql > -Skip-grant use mysql;

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Monty, Took your advice and downloaded mysql-3.23.42-pc-linux-gnu-i686.tar.gz Placed it in /usr/local Renamed /usr/local/mysql to /usr/local/mysql-old unpacked with tar -zxvf mysql-3.23.42-pc-linux-gnu-i686.tar.gz which made /usr/local/mysql-3.23.42-pc-linux-gnu-i686 I checked out the dir (

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

R Talbot wrote: > Boyd Lynn Gerber wrote: > > > What version of Caldera are you running? I may be able to help next week. > > > > tt, > > > > -- > > Boyd Gerber <[EMAIL PROTECTED]> > > ZENEZ 3748 Valley Forge Road, Magna Utah 84044 >

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

R Talbot wrote: > Michael Widenius wrote: > > > Hi! > > > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > > > R> Sasha Pachev wrote: > > >> On Thursday 20 September 2001 20:37, R Talbot wrote: > > &

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Sasha Pachev wrote: > On Thursday 20 September 2001 20:37, R Talbot wrote: > > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 > > being too old but how muc trouble is it to upgrade.the LIB > > V. 3.23.40 is running but with 12 failed tests including

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Sasha Pachev wrote: > On Thursday 20 September 2001 20:37, R Talbot wrote: > > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 > > being too old but how muc trouble is it to upgrade.the LIB > > V. 3.23.40 is running but with 12 failed tests including

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 being too old but how muc trouble is it to upgrade.the LIB V. 3.23.40 is running but with 12 failed tests including bigint is this an install I want to develop with. Please advise MYSQLBUG SEND-PR: -*- send-pr -*- SEND-P

Mysql Daemon starts at boot then Terminates??

I have deleted the Mysql 3.22.32 install and compiled source for and installed Mysql 3.23.40. The new installation resides at /usr/local/mysql. Make Test did fail onlymerge >From the command line The daemon starts perfectly with either mysql.server startor safe mys

@variableName What Version?

I currently use MySQL 3.22.32-log I compiled the source code to use with Caldera 2.3.. Does my version support the use of the @variable syntax.. When I attempt to use this I get error Error 1064 .. I find that this also would not work set @min_price=min(shop.price); P.S What is the log

Version 3.22.32 Source to upgrade??

I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2.4 edeskt

Some Frusrations!!

Jorge, I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2

RE: Select and =MAX()

Jorge When I issue your suggested commands here are the resulted rows.. mysql> SELECT price ->FROM shop ->HAVING price=MAX(price); Empty set (0.01 sec) But when I issue... mysql> select price from shop order by price desc; +---+ | price | +---+ | 19.95 | | 10.99 | | 3.9

Select and = MAX()

Following the Tutorial Creating and populating the table Shop in the db Test.. Why won't the following syntax work? mysql> select price -> from shop -> where price=Max(price) ; ERROR : Invalid use of group function Bob T

Couldn't select database

Hi Jake, Your problem appears similar to a problem I had but... you aren't providing quite enough information.. Are you working as a user on the same local host or are connecting across a network? To eliminate a MySQL problem ( so you can concentrate your efforts on PHP code) try to connect d

Console Remote connect Commands

As a long time DB2.. Sybase.. & Postgresql user upon turning to MySQL I find only some functionalities not intuitive. 1. What command syntax to use and connect to a database on another host. ( where I have granted permissions in mysql tables User..Host..and ..DB ) ( have been successf

Re: Too many PIDs

Jeremy.. Apoligies I shot off an email to you 3 seconds before I saw this one. Please read both..this email and that email.. Jeremy Zawodny wrote: > On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote: > > Jeremy > > > > So what your pointing out is I am s

How many Mysql PIDs ?

> Re: How many Mysql PIDs ? > Date: > Thu, 7 Jun 2001 15:42:15 -0700 > From: Jeremy Zawodny <[EMAIL PROTECTED]> > Reply-To: > [EMAIL PROTECTED] > To: R Talbot <[EMAIL PROTECTED]> >CC: >

Too many PIDs

Jeremy So what your pointing out is I am seeing several threads generated by mysqld... But that does not answer as to why the rpm installation start with one thread?? Both installations which I compiled from source start with multiple threads.. ( diffrent machines Caldera 2.3) Sa

How many Mysql PIDs ?

Please explain why I get multiple Daemon process when I start mysql.server..Such as 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=root --pid 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1095 pts/0SN 0:00 /usr/local/mysql/libexec