Re: user d/b access

Hi mark, I would recommend to use GRANT ALL ON URCMS.* TO 'urcms_admin'@'localhost' IDENTIFIED BY 'changeme' WITH GRANT OPTION; if you only need to connect to URCMS database from localhost. HTH Michael mark wrote: Just fired up mysql 3.23.53 * Created a d/b, and then create

Re: Compilation error on Solaris.

hi steve, there was a thread concerning compilation of mysql on solaris three days ago. one of the postings had a link: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbfgjdo to an earlier posting where j warburton describes how he successfully compiled mysql (3.23.51)

Re: provider for .net

Hi Jay, see http://www.mysql.com/press/release_2002_10.html for an overview. HTH, Michael Jay Fields wrote: > > I'm building an asp.net app and I want to connect to mysql, but I dont what > which DataAdapter to use, and I don't know what Provider to specify in my > connection string. Anyone

Re: Solaris 8 Library Problems.

hi stephen, the ncurses library is not part of the mysql distribution. it's available as a solaris binary package at www.sunfreeware.com. look for "ncurses-5.2". HTH michael "Stephen D. Myles" wrote: > > Hi, > > I am new to MYSQl so any help is much apreciated! I have recently instaled > my

Re: libncurses.so.5 problem

hi, the ncurses library is available as a solaris binary package at sunfreeware, too. look for "ncurses-5.2". Christopher Thompson wrote: > > This is not a MySQL question, it's a Solaris question. :) But anyway, you > need to get and install ncurses (version 5). You can find more informati

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

hi, the source rpm for mysql 3.23.49 contains build instructions for gnu compilers 2.95 or newer. redhat 6.2 comes with a compiler that cannot handle the "permissive" flag (i think its ecgs-2.91). therefore the build fails. one solution could be to install a more recent compiler version and try

Re: upgrading mysql-3.23.48 and rpm package.

hi, on redhat 6.2, you have a package manager (rpm) version which cannot interpret rpm's created with package manager version 4. afaik, rpm 3.0.6 is able to read both formats, so you should upgrade your package manager software to version 3.0.6 to be able to install the new mysql package. don't

Re: How do I verify it's a 64-bit build

you could use: file /path-to/mysqld the output will tell you if mysqld is a 32 or 64 bit ELF executable. Hatton Steven wrote: > > Sorry about the previous, seemingly stupid question asking for clarification > on the LDFLAGS. I was not able to hit > http://home.earthlink.net/~jaymzh666/mysq

Re: math_iso.h / libm.a

hi mark, math_iso.h is c header file located in /usr/include/iso, part of SUMWlibm package. this is output of pkgchk from solaris 8 machine (german locale): # pkgchk -l -p /usr/include/iso/math_iso.h Pfadname: /usr/include/iso/math_iso.h Typ: reguläre Datei Erwarteter Modus: 0644 Erwarteter Eig

Re: FOLLOW UP on "column names not liked by odbc/php/access"

hi, in your sql command there are several errors: it has the form INSERT INTO () VALUES (); but: - there are more items in the list of values than in the list of fieldnames. these lists should match. - there's an extra comma after fieldname 'unico', and the closing ) is missing. - you dont n

Re: need mysql version newer than 3.23.38 for dec osf4.0

hi, found this on german mysql mirror ftp://ftp.kernelnotes.de/mysql.com/Downloads/MySQL-3.23/mysql-3.23.44-dec-osf5.1-alphaev6.tar.gz (6320kb). don't know if there might be problems with osf5.1 vs osf4. hope this helps, michael Klaus Kunze wrote: > > Hallo, I am new on this maillist. I nee

Re: add a new column

hi, use sql statement like "alter table tablename add column ..." for details, have a look at: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ALTER_TABLE hope this helps, michael Nuno Lopes wrote: > > Hi everybody, > > I have an answer. Can you answer it?? Thank