you probably forgot to do any one of the things described in the manual which
are required for permissions changes to take effect
- Original Message -
From: "Meital Issers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 6:04 PM
Subject: Access is denied
Hello
Hello,
I installed Mysql on NT workstation. The installation finished successfully.
I launched the winmysqladmin.exe file and define a user for my DB.
When I tried to connect to this DB with the user I have just defined I got an error :
" Access denied for user : 'usr@localhost'
I did the sam
Hello,
MySQL does not use precompiled queries so that it has to parse the text
of the query at each request.
Do you know why this choice has been done ? and if it is planned to add
this fonctionnality to the API and if not, why ?
--
Loïc
mel : [EMAIL PROTECTED]
toile : http://www.le-loarer.or
Hi there,
little problem. I have program (like phorums) and there is command
mark all posts as readed. On one board is about 4000 posts, and if is
new user and want mark all posts as readed - it's problem (big).
All is written in ANSI C (using C API functions). And here is main
problem: when i e
At 17:12 13/06/2001 -0400, Anita Rafaela Carrillo wrote:
Hola,
Usted puede usar MySQLGUI hecha por nuestro programador
Sinisa. La puede encontrar en:
http://www.mysql.com/downloads/gui-clients.html
Creo que debe preferir la opción ya compilada.
Saludos,
Miguel
>Hola.
>Hola.
>
>Soy estudiante d
Run it from the command line and it will work. You can DBLCLK on the
MySQLManager or the winmysqladmin though and the will pop open.
Cheers
-Original Message-
From: Martin Scherer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 8:43 PM
To: [EMAIL PROTECTED]
Subject: is this a
At 7:42 PM -0700 6/13/01, Martin Scherer wrote:
>When I attempt to start the windows version of any of the
>executables such as mysqladmin.exe the command line window comes up
>scrolls and disappears. Your help is requested. Thank you.
>Martin
Sounds like you're trying to run them by double-cl
on 6/13/01 17:12, Anita Rafaela Carrillo at [EMAIL PROTECTED]
wrote:
> Hola.
> Hola.
>
> Soy estudiante de Sistemas y necesito ayuda por favor.
>
> En que sitio puedo encontrar un frontal gráfico de MySql para Linux, necesito
> generar mi base de datos y diseñar las tablas de un sistema.
>
> A
When I attempt to start the windows version of any of the executables
such as mysqladmin.exe the command line window comes up scrolls and
disappears. Your help is requested. Thank you.
Martin
-
Before posting, please check:
>From the manual:
"The default database page size in InnoDB is 16 kB. By recompiling the
code one can set it from 8 kB to 64 kB. The maximun row length is
slightly less than a half of a database page, the row length also
includes BLOB and TEXT type columns. The restriction on the size of BLOB
an
I am aware that currently innobase tables can not have abritararly large
text/varchar fields and support for this will be released sometime in the
month of June. The application I am working with requires text fields
(usually less than 64k), and I desperatly need row level locking. Either I
contin
Dear Team,
Recently I came across MYSQL. But I do have some
doubts, hopes MYSQL support team could enlighten me.
1. Do MYSQL have any report writer? Just like ACE
report in Informix Engine.
2. Under Informix Env, it uses 4GL code to create
menu, manipulate data, how does MYSQL do that? Do
MYS
Hello,
what means an error 127 from table handler and an error 1030?
where can I get documentation from that issues?
Thanks for any help you can give me,
Cesar A. Cabrera E.
--
'http://www.utp.edu.co/Lince/
On Wed, Jun 13, 2001 at 03:25:55PM -0600, Matt Heaton wrote:
> I can't seem to find a specificatoin on order by rand() and have a question.
>
> Lets say a table has 10,000 rows in it, and I want to get one row that
> matches
>
> so I do a
>
> select * from table where number=1 order by rand() l
Dear support.
I own a webserver (not located @ home but with a virtual host) using php4
and mysql. Normally I do not have any trouble with the mysql but today I got
some strange errors from mysql during a session of an IRC bot (made in php):
2013: Lost connection to MySQL server during query
So
On Wed, Jun 13, 2001 at 02:14:48PM -0700, samuel wrote:
> Hi,
> I need a one way encryption for a 16 digits string.
> let's call $string the clear string, and e($string) the encypted string.
>
> I need e($string) to give always the same result for any $string,
> and I need e($string1) != e ($stri
You'll see exactly that error if you type the default date "-00-00"
*without* the quotes. If you included the quotes, then something is
quite odd indeed. This is such a basic statement in the book that
you can be sure any error would have been reported by now.
What version of MySQL are you
I have the following install of mysql on RedHat 6.2:
mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686)
The server was running for about two weeks until yesterday when the server
just stopped accepting connections. I rebooted the entire machine and on
startup of mysqld, the following is
On Wed, Jun 13, 2001 at 03:19:30PM -0400, Ken Menzel wrote:
>
> Hi Matt, I am trying it now! Thanks! Seems to work, I am running
> it on one of the QA servers now and I see it spawning many mysql
> processes! Very cool! BTW to anyone usings ports after a source
> install use DB_DIR=/usr/loc
I'm having some difficulting on 3.23.38, linux x86... When I write
the following query the HAVING clause is only listening to the 'AND
Samples >= 10' and displas all Avg_Xmit regardless if it's less than
or equal to 28800.
If I remove the 'AND Samples >= 10' I get the correct results, but of
cou
I can't seem to find a specificatoin on order by rand() and have a question.
Lets say a table has 10,000 rows in it, and I want to get one row that
matches
so I do a
select * from table where number=1 order by rand() limit 1;
What if 100 rows match? Does it first get all 100 rows and then ra
Hola.
Hola.
Soy estudiante de Sistemas y necesito ayuda por favor.
En que sitio puedo encontrar un frontal gráfico de MySql para Linux, necesito generar
mi base de datos y diseñar las tablas de un sistema.
At. Anita C. Gracias
_
Hi,
I need a one way encryption for a 16 digits string.
let's call $string the clear string, and e($string) the encypted string.
I need e($string) to give always the same result for any $string,
and I need e($string1) != e ($string2) for all ($string1,$string2),
having $string1!= string2.
Does
I somehow locked out the root account from MySQL. How can I get access back
as root on the Unix system?
James A Ridley
System Administrator
AIX ITO Midrange Support
Ameritech/SBC Telecommunications Inc.
(317)265-4252 work
(317)673-3670 pager
Tim,
I took out the dashes as another person suggested and that made it work. I
typed in "-00-00" because that is what it says to enter in my MySQL book
(by Michael Widenius).
Thanks,
Jeff
> From: Tim <[EMAIL PROTECTED]>
> Date: Wed, 13 Jun 2001 12:20:49 -0400 (EDT)
> To: Jeff Caron <[EMA
Tim,
I noticed that too. I only repeated it when I typed it into the email
message though, not my MySQL monitor.
Thanks,
Jeff
> From: Tim <[EMAIL PROTECTED]>
> Date: Wed, 13 Jun 2001 12:19:29 -0400 (EDT)
> To: Jeff Caron <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: Re: Newbie stump
At 1:31 PM -0500 6/13/01, David Simcik wrote:
>Nope, it says version 3.23.38. However, I should point out that I started
>the service (under NT) with the --skip-grant-tables option enabled. Was
>locked out of my database when I updated my password manually using a SQL
>Update on the User table, s
Good catch :)
> -Original Message-
> From: Don Read [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 6:44 AM
> To: Alok K. Dhir
> Cc: [EMAIL PROTECTED]; Chih-Lii Chen/Trans-EZ/TW
> Subject: RE: recursive select
>
>
>
> On 13-Jun-01 Alok K. Dhir wrote:
> > Ah recursion. Not
At 2:30 PM -0400 6/13/01, Dennis wrote:
>At 08:30 PM 06/12/2001, Philip Mak wrote:
>>[client]
>>port=3306
>>socket=/home/mysql/mysql.sock
>>
>>[mysqld]
>>port=3306
>>socket=/home/mysql/mysql.sock
>
>
>here are examples of variables that you could not deduce from using
>--help. the "socket" one,fo
Hi,
> Can somebody tell me why I cannot use php3 with mysql? I have just
> installed mysql (3.23.38) on a linux 6.2 machine. It is working fine.
> PHP3 was already installed when I installed mysql. Does it have to be the
> other way round? that is php first and then mysql? I also configured
> php
Hi,
> I am just curious to know whether you have any GUI for mysql for Windows
> NT/98? If so kindly send me the link where I could download it. I am curios
> to work on MYSQL.
Look at http://www.mysql.com/downloads/index.html - you will find what
you are searching ...
Thomas Karcher
-
Hi,
> I am trying to use MySQL GUI client on W2K to connect to MySQL server running on
>RedRat Linux 7.1 and I am getting the following error
> Host '192.168.0.152' is not allowed to connect to this MySQL server.
> Do I need to change something on my Linux?
Yes, you have to check your MySQL acc
Some months ago I had the same question and I looked at many different
Windows MySQL GUI clients.
The best one I know of is Mascon. They have a free version for download.
http://www.scibit.com/Products/Software/Utils/Mascon.asp
-Philip Mak ([EMAIL PROTECTED])
-
In order for this to work you must have privileged access
to the mysqld server on which you must be able to execute
a GRANT statement to allow access from your host. If
you do not have this privilege then you're out of luck.
Connecting from other hosts then the server host is
considered to be a s
I am getting the following error in my error log periodically,
010613 9:45:38 Aborted connection 1246 to db: 'databaset' user: 'user'
host: `localhost' (Got an error reading communication packets)
since upgrading from 3.22.32 to 3.23.36. The only application using the
database is a multithre
Hi,
I have installed mysql version 3.23.38 on solaris 2.7and then
installed and configured the snore to have mysql as the plug-in database.
I created a database 'snort' for snort and a user 'snort' that has
privileges to INSERT
and SELECT on that database.
I then built the structure of the dat
hey
eu estou acessando um banco de dados do mysql via delphi usando o winzeos
meu chefe pediu p/ instalar na máquina dele p/ ele ver como está
(ainda nao terminei tudo) e eu nao consigo instalar
pois ele da erro na hora de executar a query
eu ja coloquei a libmysql.dll no pc e nada
alguem poderi
Hi!
This release fixes a couple of bugs in InnoDB tables and a couple of
other minor bugs.
If you are not using InnoDB tables, you probably don't need to
upgrade.
Changes in release 3.23.39
--
* If one dropped and added an `AUTO_INCREMENT' column, the
`AUTO_IN
It went in Wed May 23 20:26:06 2001 UTC.
http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/mysql323-server/Makefile.diff?r1=1.114&r2=1.115
Matt
Ken Menzel wrote:
>
> Hi Matt, I am trying it now! Thanks! Seems to work, I am running
> it on one of the QA servers now and I see it spawnin
Hi All anyone ever get this? FreeBSD 4.3 OS, using default configure.
$ gmake -s
Making all in src
client.cc:21: redefinition of `union semun'
/usr/include/sys/sem.h:49: previous definition here
client.cc: In method `void Client::setup_pipe()':
client.cc:286: no matching function for call to `sem
Hi.
On Wed, Jun 13, 2001 at 02:55:07PM -0230, [EMAIL PROTECTED] wrote:
> On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> > On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
> > [...]
> > > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
> > >
> > > - th
Hi Matt, I am trying it now! Thanks! Seems to work, I am running
it on one of the QA servers now and I see it spawning many mysql
processes! Very cool! BTW to anyone usings ports after a source
install use DB_DIR=/usr/local/var you will get an error at the end of
make install, but it's OK
Hi there,
I'm trying to setup qmail with mysql database.
How can i work the install process on Redhat 6.2
is there a specific package (rpm) that i can install
quickly since i got a long way to go.
regards,
_
AVISO ! Le meilleur de l'Int
Hi
As far as i know, DON'T DO THIS
mysql with serveral instances accessing the same database will not work
as expected.
check
http://www.mysql.com/doc/M/u/Multiple_servers.html
we run mysql over nfs but only with one instance.
seems to be quite stable (db server freebsd - nfs server netapp file
Thanks to all of those who lent their advice. Seems that when you initialize
MySQL using the --skip-grant-tables option enabled, it disallows the ability
to use the GRANT command. I guess that makes perfect sense. I also forgot
the use the PASSWORD() function when I used SQL to update my root acco
Ya know, why is solaris such a pain in the butt. I
have issues, no one appears to be able so answer it.
When i compile this on linux, it works great.
WTF
--- Josh Rivel <[EMAIL PROTECTED]> wrote:
> Hi.
> I am trying to compile MySQL-3.23.38 on Solaris 8
> box.
> This is a Sun Netra T1 (1u rackmo
Is this French for "This is a MIME format message in multiple parts?" If
so, Franky, try sending your message in plain text, please.
Merci,
--
Barry C. Hawkins
Systems Consultant, MCSE 4.0
[EMAIL PROTECTED]
-Original Message-
From: franky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Jun
Try urSQL from http://www.urbanresearch.com/ursql
also see the MySQL website:
http://www.mysql.com/downloads/gui-clients.html
http://www.mysql.com/downloads/contrib.html#SEC592
On Wed, 13 Jun 2001, John Kennedy wrote:
> I am just curious to know whether you have any GUI for mysql for Windows
The command I used was:
mysql[2]mysql -u root -h som-host-name
ERROR 1130: Host 'some-host-name.bbn.com' is not allowed to connect to this
MySQL serv
er
>Date: Wed, 13 Jun 2001 14:18:46 -0400
>To: [EMAIL PROTECTED]
>From: Nancy Yang <[EMAIL PROTECTED]>
>Subject: mysql -h error
>Cc: Danny Vuke
At 08:30 PM 06/12/2001, Philip Mak wrote:
>[client]
>port=3306
>socket=/home/mysql/mysql.sock
>
>[mysqld]
>port=3306
>socket=/home/mysql/mysql.sock
here are examples of variables that you could not deduce from using --help.
the "socket" one,for example, was one that I asked about last week, whe
Jeff,
From what I have seen, implicit data type conversion is not present within
MySQL's SQL subset. However, I could be wrong. It could be that this is
one more area where the efficiency of MySQL is being paid for by the absence
of some of the RDBMS spiffs we have all come to know and l
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your
Walker, Brian wrote:
> I'm at wits end here, I've been through the documentation multiple times,
> asked questions on this list, but I still cannot get this server running.
> I've restarted the server and everything.
>
> The only thing I know is that the mysqld daemon crashes when I try to s
Upgrade to 3.23.39 first ( and make sure to use our binary). 3.23.35 has some
critical bugs.
--
MySQL Development Team
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /
Hi,
when I try the following command, I got is not allowed to connect to
this mysql server.
Any clue?
Nancy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Have you tried rebooting? I'm seeing the same problem with 3.23.38 (after
stopping the server with mysqladmin and then trying to restart with
safe_mysqld) but rebooting resets whatever it is that 3.23.38 is not
properly clearing on the shutdown.
Don't have this problem on another system running 3
Make sure that mysql owns its files and directories.
Furmaniuk, Michael wrote:
> I've installed the Solaris 2.7 binary and am trying to connect to the
> database after doing the setup, when I attempt to start the database I get a
> message that mysql ended and there is no process started. I u
so i'm trying to install mysql 3.23.38 on slackware linux, kernel 2.0.27
i'm installing from a tar.gz and have no previous mysql on this server.
so i'm ok to
scripts/mysql_install_db.sh
then i get the following 3 lines
scripts/mysql_install_db.sh: my_print_defaults: command not found
didn't find
Nope, it says version 3.23.38. However, I should point out that I started
the service (under NT) with the --skip-grant-tables option enabled. Was
locked out of my database when I updated my password manually using a SQL
Update on the User table, so I am trying to change that using the method
desc
you might checkout dbtools. It seems to work quite well for me. Had
some problems with setting permisions with it, but that was an earlier
version. http://dbtools.vila.bol.com.br
Also there is a myGUI in development from the My Sql team.
Check the downloads area http://www.mysql.com/downlo
Did you try taking out one of the 'last_name' field definitions?? It
looks like you have two there...
- TIM
> Hello-
>
> I'm just beginning to teach myself MySQL with the help of Michael Widenius'
> book "MySQL". I've entered the create table statement exactly as shown in
> the book (pg. 28 if
Also, I don' think "-00-00" is a valid Date. You might want to use
something else as a default.
- TIM
> Hello-
>
> I'm just beginning to teach myself MySQL with the help of Michael Widenius'
> book "MySQL". I've entered the create table statement exactly as shown in
> the book (pg. 28 if y
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> Hello.
>
> Only a minor correction:
>
> On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
> [...]
> > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
> >
> > - the PRIVILEGES keyword is redundant.
> > - da
Try this: update your ports, then build the mysql port with
"WITH_LINUXTHREADS=1". This should result in a FreeBSD native binary
linked against linuxthreads instead of libc_r, so it should use multiple
processors.
Matt
Ken Menzel wrote:
>
> Hi Rafael,
>This is not an easy task, there are r
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, yo
Thanks, Barry!
I entered the date without the dashes and was able to create the table just
fine. Do you have any idea why this makes a difference? Can't believe
everything you read in a book, I guess!
And yes, I did end the statement with the semicolon when I submitted it;)
Onward...
Jeff
>
http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html
Tyler
- Original Message -
From: John Kennedy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:31 AM
Subject: mysql GUI for windows NT/98 is it available?
> I am just curious to know whether you ha
My point was that this is a configuration file, text, not a program.
Still, there should be an appendix in the documentation that lists all
of the options rather than have this hunt-and-seek approach.
Quoting Paul DuBois <[EMAIL PROTECTED]>:
> At 8:15 PM -0400 6/12/01, William M. Quarles wrote
Hi.
I am trying to compile MySQL-3.23.38 on Solaris 8 box.
This is a Sun Netra T1 (1u rackmount, UltraSPARC-IIe CPU)
I've tried using both Sun's gcc (2.95.2) and gcc-2.95.2 from
www.sunfreeware.com, both with the same results.
For whatever reason, gcc is being reported as a cross compiler,
so mys
on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wrote:
> Hello-
>
> I'm just beginning to teach myself MySQL with the help of Michael Widenius'
> book "MySQL". I've entered the create table statement exactly as shown in
> the book (pg. 28 if you have the book) and I get an error message every
Go through http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html
This is a good starting point.
Look this over and you will see your error ;
Use a CREATE TABLE statement to specify the layout of your table:
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
->
For those who think I'm off the wall, here's what's driving me up it:
Had MySQL doing replication through stunnel for many months, flawlessly,
using MySQL 3.23.27 on master and slave. Now going to MySQL 3.23.37 on
master and 3.23.38 on slave, it's broken.
MySQL has some inconsistent weirdness ab
How do you do this?
--- Whit Blauvelt <[EMAIL PROTECTED]> wrote:
> Even if you have the zlib library, you may have to
> add the flag for it
> manually - it's not properly found by the configure
> routine as of 3.23.37,
> at least on Debian Linux 2.2.
>
> On Wed, Jun 13, 2001 at 03:11:42PM +0300,
Hi!
I have to correct immediately the release note: the new my.cnf parameter
name is
innodb_unix_file_flush_method.
It should be specified only in special cases if you are not satisfied with
disk
write performance. Read the InnoDB manual about the risks in specifying this
parameter. It is not a
Hi.
This is not really a MySQL related question, but something about C
basics, IMHO.
On Wed, Jun 13, 2001 at 04:38:28PM +0200, [EMAIL PROTECTED] wrote:
> hi all, im currently using a C program to access my mysql database.
> but i have a small question.
> How do i insert a variable into a query?
Hello.
On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote:
> Thank you all for your original suggestions, but I'm still having problems.
> I copied this verbatim from the MySQL docs and tried it on two seperate
> servers:
>
> mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
> -
However, it is important to know about my.cnf and where to put it, IMHO!
Quoting Whit Blauvelt <[EMAIL PROTECTED]>:
> On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote:
>
> > Make sure you have also read chapter 4.16, most importantly 4.16.5.
> it has
> > some important infor
I'm at wits end here, I've been through the documentation multiple times,
asked questions on this list, but I still cannot get this server running.
I've restarted the server and everything.
The only thing I know is that the mysqld daemon crashes when I try to start
it. I could not have another
At 10:16 AM -0500 6/13/01, David Simcik wrote:
>Thank you all for your original suggestions, but I'm still having problems.
>I copied this verbatim from the MySQL docs and tried it on two seperate
>servers:
>
>mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
> ->IDENTIFIED BY 'some_
sprintf(query,"select blah,blah from table_name where name =
'%s'",variable);
-Mensaje original-
De: Kenneth Johansen [mailto:[EMAIL PROTECTED]]
Enviado el: Miércoles, 13 de Junio de 2001 11:38 a.m.
Para: [EMAIL PROTECTED]
Asunto: howto insert a variable in a query in C?
hi all, im cu
I am just curious to know whether you have any GUI for mysql for Windows
NT/98? If so kindly send me the link where I could download it. I am curios
to work on MYSQL.
thanks
John
_
Get your FREE download of MSN Explorer at http://e
Hello!
I would like to specify my problem once again!
I have a field type: VARCHAR(100) NOT NULL
When I add new record in database everything works OK!
When I want to modify data in a field using ADO with:
RS.Fields(0).Value="Value"
function everything works OK again when I use the same or les
Hello.
On Wed, Jun 13, 2001 at 05:01:21PM +0200, you wrote
> hi,
> when i do : "find / -name mysqld.sock", it doesn't
> find nothing,
> i have read the article what u tell me, it wrote, for
> running server mysql, u put :"mysql" or
> "mysqld.server" i tried the both :when i put
> "mysqld.server",
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book "MySQL". I've entered the create table statement exactly as shown in
the book (pg. 28 if you have the book) and I get an error message every
time. This is very frustrating as I can't go any further with the tu
If PHP is compiled with its own MySQL support (as compared to using the
MySQL shared libraries - which are not in every MySQL distribution) it
expects mysql.sock to be in /tmp - whereas recent versions of MySQL put it
in /var/lib/mysql/. PHP will find it if you add "mysql.default_socket =
/var/lib
I cannot find the core file.. where is it?
BTW, system seems somtimes run out of file handles / max processes.
There is some more information to provide:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readab
Even if you have the zlib library, you may have to add the flag for it
manually - it's not properly found by the configure routine as of 3.23.37,
at least on Debian Linux 2.2.
On Wed, Jun 13, 2001 at 03:11:42PM +0300, Sinisa Milivojevic wrote:
> [EMAIL PROTECTED] writes:
> > >Description:
> > Una
Hi,
I am trying to add new charset in my preinstalled mysql-3.23.26-beta.
Manual says:
Add the character set name to the CHARSETS_AVAILABLE and COMPILED_CHARSETS
lists in configure.in.
But I CAN NOT find COMPILED_CHARSETS list there.
Please help me.
Regards,
Ivan Lulukyan
On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote:
> Make sure you have also read chapter 4.16, most importantly 4.16.5. it has
> some important information in it, too.
Those chapters have nothing directly regarding replication. If you're to the
point of worrying about replicat
I've installed the Solaris 2.7 binary and am trying to connect to the
database after doing the setup, when I attempt to start the database I get a
message that mysql ended and there is no process started. I use the
following (all things should be run with sudo on our server) -
> sudo ./bin/sa
hi all, im currently using a C program to access my mysql database.
but i have a small question.
How do i insert a variable into a query?
imagine:
*query="select blah,blah from table_name where name = variable";
im a bit in the dark on this one and would appriciate any/all suggestions.
regards
k
Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
->IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
ERROR 1047: Unknown command
Hi!
MySQL/InnoDB-3.23.39 binaries and source now available for Unix at
http://www.mysql.com. Windows binaries will be released in a few days.
InnoDB is a database backend which brings high-performance transactions
and row level locking to MySQL.
Main changes in InnoDB:
* CHECK TABLE now works
Hi.
Sounds as if you have to install a newer MySQL package. Use
rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0
to find out, which package contains the lib (for me, it is
MySQL-shared-3.23.36-2mdk, which contains libmysqlclient.so.10.0.0)
and install a more recent version (take it, for example,
I sounds like the data or index file may be getting larger than the
maximum file size allowed by the operating/filesystem.
What operating system and kernel version are you using, and what file
system?
How big are these files?
Rob wrote:
> One of my tables is corrupt and I tried all the usual
Hi all, I am a new subscriber of this list.
I have a question that have confuse me for a long time.
I am currently running MySQL-3.23.32 on Debian(woody)
with kernel 2.4.x on a i386 box /w 1G Ram..
We are currently runing two different kind of database on the
same server. One of them is a few ta
At 14.38 13/06/01 +0530, Suvarsha Walters wrote:
>Thanks a lot,
>
>But another problem. I did the changes in my.cnf and restarted mysql. It
>stops immediately, shows the following:
>
>Starting mysqld daemon with databases from /base1
>010613 14:22:38 mysqld ended
>
>But when I changed the 'datadi
Hi Drew,
Ok, your question may be a bit more complicated. When your CPU
load goes up to 90% are there many processes running? What version on
FreeBSD are you on (4.3 which is pretty good?)? Becuase there were
bugs in threads on the 4.2 FBSD release. There was a MySQL change
relating to the
Hi.
On Wed, Jun 13, 2001 at 01:47:53PM +0200, [EMAIL PROTECTED] wrote:
> Hi
>
> Sorry for this question but this is my first shot at this list.
>
> I have created a table that contains the following:
> CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT
>NULL,
>
>
1 - 100 of 129 matches
Mail list logo
