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 created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION; Ok, it never prompts me for a password, nor did it let me, as that user, use URCMS. I looked in mysql.db, and the host for that user was %, which according to the reference, *should* let me do that from any host. At any rate, it only let me go to the d/b after, as root, I did GRANT ALL ON URCMS.* TO [EMAIL PROTECTED] WITH GRANT OPTION; I would assume that % should include localhost. Am I missing something here? mark * Please don't tell me to upgrade to 4.x. I'm working on some software, and I do *not* want it to require Only The Latest Version. Since many distros are still shipping with 3.23, I want it to be compatable with what they're running, and not force them to upgrade, *unless* this is a known bug. In that case, I have no problem upgrading to the next patch level. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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?? Thanks! Here is it: I have a db in > mysql (off course!) with a lot of data. Can I add a new column (a new > variable) to an existing table??? If yes, what's is the sql query?? Thanks! > > Thanking in Advance, > Nuno Lopes > > P.S.: When you reply to the list, please reply to me to I get the answer > a.s.a.p. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 need for my Dec-Server with > OSF4.0 a newer version (binary) of mysql than 3.23.38 Where can I > get such version. > With source-code of Version 3.23.44 I have problems > Mit frdl. Gruss > Klaus Kunze > === > Dr. Klaus Kunze Tel. 97 33324 (0341) > Rechenzentrum __o > Universitaet Leipzig _`\<,_ > Augustusplatz 10/11 (+)/ (+) > 04109 Leipzig > e-mail: [EMAIL PROTECTED] > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 know if there any libc issues, though. bye michael Ireneusz Piasecki wrote: > > Hi all. > I would upgrade my mysql serever from RPM: > > rpm -i MySQL-3.23.48-1.i386.rpm > only packages with major numbers <= 3 are supported by this version of RPM > error: MySQL-3.23.48-1.i386.rpm cannot be installed > > What can i solve this problem. I use Red Hat 6.2 > Where can i find the RPM engine to install mysql 3.23.48 ? > > With mysql 3.23.47 was no problem > > Pleas help. > > Regards > I. Piasecki > > -- > > Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! > > [ http://oferty.onet.pl ] > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's (although there had been a rpm-3 version which could _read_ rpm-4 packages - i think it was 3.0.5.) besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... if you dont have very specific reasons to stick with redhat 6.2 in my opinion it could be simpler just to install a later redhat version... not sure if this really helps... bye michael Gabriele Carioli wrote: > > Hi everybody... > > I've searched thrugh the lists (IMHO the search engine is > slow and the output sucks: what about a date column at the > beginning of each row in the post list and in search results?) > and the manual. This is the 3rd time I post about this > problems but it looks like nobody can give me an answer ... > > I wonder if it is possible at all to build rpm MySQL 3.23.49 > binaries for RedHat 6.2. Is it possible? I've not been able to > build rpm for my platform on three different machines. > > I've tried to > >rpm --rebuild MySQL-3.23.49-1.src.rpm > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 information > at: > http://www.gnu.org/software/ncurses/ncurses.html > > On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote: > > Hello, > > > > I feel i am dead in the water with this problem, it appears that > > libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 > > from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to > > start mysqld daemon and i can run mysqladmin commands but when i try to > > connect i m getting : > > > > bash-2.03$ mysql > > ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or > > directory > > Killed > > bash-2.03$ > > > > I have done a whole find for libncurses.so.5 on system and couldn't find it > > anywhere. I am really confused, please HELP. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
> mysql version 3.23.45 on Sun solaris 8 (sparc). The server installed fine but I
> am unable to connect to the server using the mysql command due to some missing
> libs. Both the server and client are running locally.
>
> # ./mysql -h tilda -u mysql
> ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory
> Killed
>
> A truss of the above output shows mw whitch lib files.
> # truss ./mysql
> execve("mysql", 0xE72C, 0xE734) argc = 1
> mmap(0x, 4096, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON,
> -1, 0) = 0xEF7B
> resolvepath("/usr/lib/ld.so.1", "/usr/lib/ld.so.1", 1023) = 16
> open("/var/ld/ld.config", O_RDONLY) Err#2 ENOENT
> open("/usr/local/mysql/lib/mysql/libncurses.so.5", O_RDONLY) Err#2 ENOENT
> open("/usr/local/lib/libncurses.so.5", O_RDONLY) Err#2 ENOENT
> open("/usr/lib/libncurses.so.5", O_RDONLY) Err#2 ENOENT
> ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory
> write(2, " l d . s o . 1 : . / m".., 81) = 81
> getpid()= 1028 [1027]
>
> I can find no reference to this files in any of the documentation at all which
> leaves me a little confused.
>
> Any ideas?
>
> thanx
>
> smyles
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 need apostrophes for numeric fields. you get the table
definition using sql command 'DESC tablename'
(- and the tablename -was- missing :)
hope this helps,
michael
"database,sql,query,table"
mweb wrote:
>
> Hello,
>
> On the same database, this query works:
>
> $SQL_Exec_String = "INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link)
> VALUES ('prova titolo','prova descrizione','.gif','prova link');";
> $cur= odbc_exec( $cnx, $SQL_Exec_String );
>
> This one gives this error:
> ISQL_exec_String = "Insert Into (Artista, Opera, Label, Anno, Nazione, CDNow,
> Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato, Unico, VALUES
> ('prova2', 'inedita', 'ignota',
> '2001','IT', 'nonesiste', 'io', 'lui','3', 'ulteriori dettagli sul genere
> musicale', 'http://www.no.it', '1', '20011205111456', 'asdas erfver', 'ciao
> ni', '2.5', 'Non andare a capo!');"
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
> INSERT INTO statement., SQL state 37000 in SQLExecDirect in
> C:\domini\m.net\inserzione3.php on line 115
> Error in odbc_exec( no cursor returned )
>
> Does the second qyury look syntactically wrong to you? May it be that some
> column name or quoting is wrong, or some value I try insert is not matching
> the column type? If so, why would this be a *syntax* error?
>
> Is it possible to query access via Php so that it will tell the internal
> strucure of the table?
> (this database was developed and left online by somebody else, that's why
> I don't have all this info)
>
> Any help is greatly appreciated, as are working sql statements for similar
> (php+odbc+access) cases.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Eigentümer: root Erwartete Gruppe: bin Erwartete Dateigröße (Byte): 2461 Erwartetes Ergebnis für sum(1) des Inhalts: 14161 Erwartete letzte Änderung: Aug 08 06:34:43 1999 Referenziert von den folgenden Packages: SUNWlibm Aktueller Status: installiert hope this helps, michael "Faine, Mark" wrote: > > Solaris 8 > Gcc 3.0.3 > > I cannot get mysql to compile without math_iso.h yet I cannot find > math_iso.h anywhere, does anyone know where this file is located, also, does > anyone know which Solaris Package contains libm.a it's missing also. > > -Mark > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/mysql.html , so I did not realize that > answer was there. I now seem to have a successfully built MySQL 3.23.47 > using what I believe is a 64-bit capable gcc-3.0.3. How might I verify that > I indeed have a 64-bit MySQL? > > TIA, > > Steven > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 have any advice? > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) on solaris 8. HTH, michael Steve Fulton wrote: > > Hi all, > > I've been trying to compile .51 and .52 under Solaris 8, and I get errors > under both versions. Here's the error under .52: > [...] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
