I use mysql win32.
why I can change the grant table using anonymous (OBDC) user?
how can I protect the grant table
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Is the LOW_PRIORITY keyword necessary anywhere during INSERTs in 3.23? Can
we remove it completely from everywhere we used it whilst in 3.22? Thank
you.
Martin
-
Before posting, please check:
http://www.mysql.com/manual.php
On Tue, 20 Feb 2001, freelsq wrote:
I write a cgi problem of c++, and I compile it and run it normally in mysql 3.22.25.
but when I change the mysql to 3.23.32, I recompile the program and run it,
It display a error msg like this:
shell./test
./test.fgi: error in loading shared
why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)?
(this will help me to learn :)
tia
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi list.
I have tried unsubscribe from this list by sending a message
to
[EMAIL PROTECTED]
but, it don't works.
If there are someone of list managers reading this list. Please,
unsubscribe me.
Bye.
On Mon, Feb 19, 2001 at 10:22:58PM -0500, Paradox wrote:
I have a table with an integer auto increment primary key, INVNUM, and a
CHAR(48) field NAME.
Is there a way I can have my table presorted by the text field,
Yes, in 3.23.33 you can use myisamchk with the -R option. I don't have
a
Description:
Installation on a Debian SID fails : mysqld segfaults.
I've got a libdb2 installed yet in /usr and installed the patched
version in /usr/local. Maybe those two conflict ?
How-To-Repeat:
-Compiling DB before,
-Letting MySQL compile DB
Description:
create table user( u_id int(255) not null, name varchar(255));
Notice the lack of space between user and the ( if you add a space
in the statment will work. this problem only seems to happen when the
table is named user. create table blah( will work fine
On 20.02.2001 10:08:18 ited wrote:
why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)?
Because especially phpMyAdmin allows me to nicely see what's in the database and
administer it?
Hmm, I know, questions should not be answered by questions, but why would you
Hi,
Can anyone recommend some public domain Linux-based software that'll let
users who want to access a web site submit an email address and have an
auto-generated password be mailed to them at that address? What I want to
do is what you've probably seen on a dozen sites: if you want in, you
NEW CHINA {"YAHOO"*} STOCK PICK!
FOR IMMEDIATE RELEASE:
THE PENNY STOCK PICKER OFFERS THE HOTTEST INTERNET INVESTMENT OPPORTUNITIES!
Take Advantage of our Expert's SPECIAL MARKET UPDATES!
Find a stock worth $.30 cents that could be worth $10.00 in just six months - and ASK
OUR EXPERTS
Hello everybody,
About two hours ago I had a system crash and one of my MySQL databases was
extensively used at the same time. When the system went back up, the
table (the
table has 37000 rows) that was used at the time of the crash started
to give me
the error
: Got error: 1030: Got error 127
hi all
i use mysql-3.23.32
my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like
insert into Table
Hi all,
create table user( u_id int(255) not null, name varchar(255));
Notice the lack of space between user and the ( if you add a space
in the statment will work. this problem only seems to happen when the
table is named user. create table blah( will work fine
It looks like this is
Hi,
I've a table which is read very often..
Simplified table structure:
create table comments (
id int unsigned not null auto_increment primary key,
datedate not null,
comment varchar(255) not null
And you tried the web link that appears at the bottom of every e-mail as
well
- Original Message -
From: "Salvador Zarzo" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 17:17
Subject: Problem with list
Hi list.
I have tried unsubscribe from
Firstly, why do you have quotes around the numbers? I thought you said it
was bigint, not a string?
Secondly, if you are going reply/repost to the list, could you please
simplify it a bit. Provide field names, etc. Your insert is very difficult
to figure out especially with unmatched brackets,
Hello,
Can any of you explain me why, when i do this request :
select count(*)
from OBJET as t1 left join COLLECTION as t2
ON t1.numColl = t2.numColl
where t2.numSupp = 0;
I've got an error saying : Field numObj not found
note that numObj is the Key of table OBJET...
Thank's
--
Best
Hi!
Several reported Win32 specific bugs have been fixed and new ZIP file
has been made available on the mysqlgui site.
All those that use Win32 version of mysqlgui are urged to download and
install it.
As I am now VMWare-enabled, please forward me if you hit at some new
bugs.
Regards,
Leave the mailing list alone please.
If not I'll feel forced to ask all the kind hackers here including myself
to track your ass down and make sure you have some expenses.
I'm really really sorry for taking up your time and ya better be sorry ya
took mine.
If you want to mail potential customers
I have an MySQL table in which one of the fields is a list of different
catergorys. I want to change that catergory name to some thing else however
it appears in my table just over 900 times. Is there any way I can do some
sort of glabal search and replace in My SQL?
Mat
Joris Lambrecht writes:
to wich version are you referring ? 3.23.33 ?
No, mysqlgui 1.7.4.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL
jaco wrote:
I'm having problems with mysqldump too.
I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root,
typing ./mysqldump --all-databases backup.sql
as is explained on http://www.mysql.com/doc/m/y/mysqldump.html
The response is : ./mysqldump:
oh god, i think i'm in need of a break sorry 'bout that
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 2:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: New sub-version of Win32 version of mysqlgui
First, i am really sorry about that.
my fields is quite simple.
CREATE TABLE TEST (
A bigint(20) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20) unsigned DEFAULT '0' NOT NULL,
C2 bigint(20) unsigned DEFAULT '0' NOT NULL,
C3 bigint(20)
It means you forgot -lz.
You also need libz.so
Evan James Dembskey wrote:
Hi,
While trying to compile a program in C taken from the book Professional
Linux Programming (Matthew, N. Stones, R. (2000) 155) using this command
(also taken from the same book):
[root@evan /usr]#
Hi,
I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and
when I try to execute a query, the program stops and I get the following error:
Segmentation fault
Can you help me with this?
Thank's
--
Luis Pedro
Physics Departement of Unoversity of Lisbon
On Tue, Feb 20, 2001 at 06:56:28PM +0800, chchen wrote:
hi all
i use mysql-3.23.32
my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like
insert into Table
Hello,
Several of my tables are corrupted. I have a Win system.
How can I repair my DB's with isamchk. What would I have to enter to the command
line if I would like to check all DB's and all tables? The help says that I have
to specify the table on the command line - it gives the error "file
There is a new version of DBTools (1.0.8) available for download. For a
complete list of changes and download go to http://dbtools.vila.bol.com.br.
- This new version comes with an install script. I'd like to thank all the
3rd part effort to make this happens.
- Fixed a serious bug in the new
Luis Pedro writes:
Hi,
I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and
when I try to execute a query, the program stops and I get the following error:
Segmentation fault
Can you help me with this?
Thank's
--
Luis Pedro
Physics
Thanks for your response,
What benefit would that give me? Would a combined index be faster? I have
the three columns indexed anyway, and do not really want to dedicate more of
my index file to a duplication . it is getting to the 1G mark already, and I
have a 2G limit for any one file.
I have
Hello,
Is it possible to enable a MySQL replication between 2 or more severs where
I can write and read to all servers?
I know it is possible to install one master who I can do reading and writing
to. And slaves who I only can read from. But I want to write to these slaves
as well, and they
Hi:
I have got your email from the Web site and I am very interested in working for your
company. I
have a BS in Electrical Engineering and computer science and worked on my Master
degree
in Telecommunication engineering (not finished due to the lucrative market!). I have
also 7++
years of
All of your columns are indexed but in an SQL query, only one index can be
used...
So, if you build an index matching exactly the columns used in your query,
you will parse only the lines that match your query...
So, if I'm not wrong, you will only parse 11 or 17 lines depending on your
query and
Thanks for your replies.
Patrick: I will try the combined index, and see if it takes too much disk
space. Most queries return within 2 seconds, which is acceptable for me.
Therefore I'm not too concerned about the speed increase in using a combined
index as such.
What I am concerned about
Read the manual on replication, and pay special attention
to the warnings.
This will not work if you use autoincrement fields, unless you are VERY
careful.
Then it still may not work.
Fredrik Kristiansen wrote:
Hello,
Is it possible to enable a MySQL replication between 2 or more severs
Hi There,
I have recently been asked to implement per database quotas
for mysql for a large scale shared webhosting environmnet,
from the lists it seems pretty obvious that mysql cant achieve
this at the moment (without using filesystem quotas), file
system quotaing is pretty awkward with our
Has anyone been able to sucessfully make DBI and DBD::MySQL work under OSX -
Darwin? I'm not having any luck at all. I'm running Perl v5.6.0 built for
darwin. And I'm trying to install the MySQL modules version 1.2215, with
DBI version 1.14.0. My mysql database is version 3.23.28. When I
Thanks for all your help.
This has got the query time down to 5 seconds from 2 minutes!!
Much appreciated everyone.
Robin
-Original Message-
From: Tibor Simko [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 16:46
To: Robin Keech
Cc: '[EMAIL PROTECTED]'
Subject: Re: Slow Select
Hi all, I have two little problems:
1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like ! sql query "insert into dbase
values ('@qfield1', '@qfield2'...).
2.I need to split query results in multiple pages (e.g. with a next
button) so that my
Here is what our company uses to do the page division on adoptablekids.com I
have used it for a few other applications with minimum changes
This code would give you five per page.
sql detail=rhs pgsize="5"
select * from profile order by id DESC
/sql
perl
Where do I get this DBD::mySQL?
I've been searching for it and can't quite find it.
Ryan Gamo
Edwards Lifesciences
One Edwards Way
Irvine, CA 92614
GO
Hi
Attempting build on Tru64 V4.x using gcc V2.95.2 and gnumake v 3.x
Build mysql is quite troublesome.
The latest error appears to be gnu gcc V2.95.2 error. I am attempting build
number
7,345
The error I get is.
sql_acl.cc in function 'int
cpan.org
On Tue, 20 Feb 2001 [EMAIL PROTECTED] wrote:
Where do I get this DBD::mySQL?
I've been searching for it and can't quite find it.
Ryan Gamo
Edwards Lifesciences
One Edwards Way
Alan Halls ([EMAIL PROTECTED]) writes:
Here is what our company uses to do the page division on adoptablekids.com I
have used it for a few other applications with minimum changes
This code would give you five per page.
sql detail=rhs pgsize="5"
select * from profile
I did the following on my mysql server...
GRANT ALL PRIVILEGES ON database.* TO user@'web.web-ster.com' IDENTIFIED BY
'password'
FLUSH PRIVILEGES
So I know the privileges are current... But when I try and access the
database from this IP it says that "host 13ave.com" is not allowed to
I have a table that contains two datetime columns, and I need to determine
the time between the two dates. So, what I've been doing is just
subtracting what I know is the later date from the earlier date. But that's
obviously not the way to do it as my results don't relate to anything.
Here's
I have inserted 1234567890 in a float field. mySQL server rounded this
to 123457. Then i have inserted 99 in same field, and tis
was rounded to 100. Is this a bug or someyhing else? Field is
declared as "field1 float"
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
Yep that was it! Yesterday there was a messup with DNS that caused the
reverse DNS to be 13ave.com
I quickly changed it, but apparently MySQL cached that entry. It's been 24
hours, but still. As soon as I just did a flush-hosts it came right
up. Thanks!
At 12:12 PM 2/20/2001 -0800, Atle
This doesn't work, gives the same error.
Do we know if Microsoft just doesn't like MySQL?
Aaron Weiker
Programmer
CISP - Changing Internet Speed Performance
Phone: 419.724.5351 [EMAIL PROTECTED]
Pager: 419.218.0013 http://www.cisp.cc
Cell:
You could use the UNIX_TIMESTAMP() function to easily determine
the difference in seconds between the two dates.
select UNIX_TIMESTAMP( Datetime_A ) ...
and the do the time_a - time_b thing. there might be a simple query that
will work as well, but I don't know the mysql date queries that good
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.
Richard Reina wrote:
I posted
Martin Jeremic wrote:
I have inserted 1234567890 in a float field. mySQL server rounded this
to 123457. Then i have inserted 99 in same field, and tis
was rounded to 100. Is this a bug or someyhing else? Field is
declared as "field1 float"
--
Martin Jeremic - JSoft
Don't laugh,
Intel PI 166MHZ, 32MB RAM,10GB HD
FreeBSD4
MySQL3.23.33 from .tar.gz distribution
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Description:
On several occasions I reported problems with MySQL and our Webmail installation
(using the program IMP). All MySQL processes would lock. No process would be
shown to execute. The Only thing to correct the problem was to kill MySQL and
restart Apache.
People at MySQL
I am working on an auto-generating form in VB. Its time to add a mask control, if the
FieldType is a number.
I need input and display masks for each of the numeric field types. (for the Microsoft
MaskEdBox control that comes with VB 6).
If anyone is any good at masks, please help me out
Hello,
I have setup MySql and MyODBC on an NT4 machine and I have granted access for
several users to a database called test. I can open databases with a link table in
access, but I can't export them or edit the databases in design view. When I try to
change the database with design view
sounds strange, but if you do it this way, you should have no problems:
mysqldump test_database test_database.dump
mysql test_database test_database.dump
will import everything in test_database.dump into your database..
somehow, you had selected your database, but that got dropped ?
Atle
Yesterday, I was having fun writing mysql scripts and importing them.
I would do a drop database and re-import, editing the data in the
script.
Today, I couldn't for the life of me do an import on a mysql export
file, even using commands stored from yesterday, in bash_history.
I am getting
At 15:16 20/02/2001 -0700, Ryan Stout wrote:
Hi!
To have an updatable record set on Access, you need to have a
primary key or selected a column as primary key when you
make the linkage of the table.
Regards,
Miguel
Hello,
I have setup MySql and MyODBC on an NT4 machine and I have granted
On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote:
Don't laugh,
Intel PI 166MHZ, 32MB RAM,10GB HD
FreeBSD4
MySQL3.23.33 from .tar.gz distribution
The `make' or the `make install'?
The `make install' shouldn't take more than a few minutes, but the
initial `make' will take
In the last episode (Feb 20), Jeremy D. Zawodny said:
On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote:
Don't laugh,
Intel PI 166MHZ, 32MB RAM,10GB HD
FreeBSD4
MySQL3.23.33 from .tar.gz distribution
The `make' or the `make install'?
The `make install' shouldn't
Like pretty much all software, it quite possibly has security flaws.
A big bonus though, is that it binds port 3306 by default so you don't need
to run it as root. Create a completely seperate user and group for it and
run it under that uid/gid. Ensure none of your root system scripts interact
Hi mysql support,
I got the following error message whenever I tried to run mysqld
daemon.
It worked before but it's something wrong about getting passwd, I
think.
What caused this error ?
My system is Linux i686 system.
mysqld ended on Fri Feb 9 11:44:06 GMT 2001
mysqld started on Fri Feb 9
I've done it on a 486 with 64Mb memory and it took about an hour or an hour
and a half or so (it was a long time and I went off and did other things
while it was happening so my timing is not precise (oh that's make time for
the main part, make install much quicker) - and it was a few
mysql caches hostnames, so perhaps 13ave.com is connecting to your
database server as well?
say for instance:
13ave.com connects, mysql resolves that to
$ host 13ave.com
13ave.com has address 12.111.170.18
web.web-ster.com comes along, mysql sees the reverse and says 'Hey, I've
seen you before,
Get a FREE copy of the exciting 48-page booklet "Inside Secrets to Wealth
on the Web".
Just hit Reply and send a blank message with "Inside Secrets" on the
Subject line.
-
Before posting, please check:
I have big problem,
i have installed 3.22.23-1 for linux (cobalt server)
mysql works, mysqladmin works but i have a meassage in IE:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/tepekoy.php on line 28
then
Hi,
I am not familiar with the current state of MySQL
security. I know there were serious problems with
previous versions, but that was a year ago.
I am planning to install a program that use MySQL as
backend on our external server. There are other
important database server running on the
I would like to see if all the tables in my database have the "comment"
field equal to a given value. I understand that "show table status" command
is able to show us the "comment" field's value. I was wondering how we can
extract only this field when we do conduct our queries from a mysql
i am a very beginner level and i tried to set mysql up but i failed.
i downloaded the software from mysql.com but i couldnot find any setup icon.
what kind of compiler do i need?
i wonder to know whether you can send me some information how to set mysql
up.
thank you for your interest.
From what you've written, I'm guessing that you're using windoze so,
firstly, are you sure you downloaded the Windoze version and not the Unix
version? The other is, mysql has a very good manual on their website which
describes how to install.
- Original Message -
From: "Mehmet agar"
Dear Sirs :
Please I would want to konw How I can insert special
characters into a table,
Since the " and ' chars are used for delimiting values into
an insert statement I don´t know how I can put these as part
the string that I inserting.
I got this putting the data into a file, and then
Add \ in front of special chars. eg 'I can\'t do this'. This is explained
in the manual. Also, some programs have a function that will add it for
you, such as PHP.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 21,
Description:
Two compile problems. The second one has me stumped. I am pasting in error
info on both at the end of this form.
Problem #1: snprintf error in client/sql_string.cc. I substituted sprintf,
hope it's safe.
Problem #2:
At 1:24 AM + 2/21/01, [EMAIL PROTECTED] wrote:
Dear Sirs :
Please I would want to konw How I can insert special
characters into a table,
Since the " and ' chars are used for delimiting values into
an insert statement I dont know how I can put these as part
the string that I inserting.
Put
Hi,
I'm storing a text file in a TEXT column using the LOAD_FILE function like
this:
INSERT ... text_col=LOAD_FILE('filename')
Each line of the orig file ends with char 10.
When I SELECT it like
SELECT text_col INTO OUTFILE 'out_filename' ...
I find that each line has an extra "\" (char 92)
- Original Message -
From: "Joe and Nancy M" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 21:04
Subject: Re: need mysql sample to accomplish existing asp function
Rolf,
Sorry I worded that email in a confusing manner.
You most certainly
Having problems starting mysql on my linux box. I think I've tried just
about everything in the manual within reason. Please help out if anyone has
an idea.
The other day, mysql died on my system for no apparent reason. When I reboot
the machine, based on the script in /etc/rc.d/init.d/mysql,
we have two tables
1. servicecntr_nm
comp_cod int(11)
service_nm varchar(70)
city_cod varchar(13)
addr varchar(100)
pin int(11)
contact varchar(70)
serv_cod varchar(30)
2.service_prod_index
serv_cod varchar(30)
prod_no varchar(20)
now our aim is to find out all the service_nm that
Rolf Hopkins ([EMAIL PROTECTED]) writes:
Well now, that depends on what you want to use. You can use java, php, or
perl and there are others but make sure your ISP supports the language you
choose. I recommend php as it is the easiest of the three. Their web site
is www.php.net and
Fethiye Akbulut ([EMAIL PROTECTED]) writes:
I would like to see if all the tables in my database have the "comment"
field equal to a given value. I understand that "show table status" command
is able to show us the "comment" field's value. I was wondering how we can
extract only this
Johnny Withers ([EMAIL PROTECTED]) writes:
I have recently upgraded from MySQL 3.22.27 to 3.23.33.
I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram.
The following select statement worked fine in mysql 3.22.27:
SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode
FROM
since mysql have no limit with database.i can only limit the space in Filesystem
quotas.
but i didn't know the filesysterm about mysql database.where are them?is there any
documents about this?
010220 19:27:11 Aborted connection 21199 to db: 'vlndb' user: 'root' (Got
an error reading communication packets))
Has anyone experienced this error in MySQL and do you know what it means?
Kyle Higgins
USCO Logistics
UNIX Manager
Email: [EMAIL PROTECTED]
Sub selects are not yet supported. Please read the manual. A normal query
should also do the trick as well.
select t1.service_nm from servicecntr_nm
t1,service_prod_index t2 where t1.serv_cod=t2.serv_cod and t2.prod_no=11
and
t1.city_cod='in000501';
- Original Message -
From:
Yes, you have missed something. Somewhere into chapter 7 of the manual,
can't remember exactly where off the top of my head, it talks about adding
backslashes. It is to do with inserting text. It is required for special
characters.
- Original Message -
From: "Richard Vibert" [EMAIL
Rolf Hopkins ([EMAIL PROTECTED]) writes:
Try http://www.accessmysql.com/
Oh. Yet another person trying to sell you something that can be downloaded freely
elsewhere. yawn
Try http://www.mysql.com/downloads/gui-clients.html
Oh, sorry, that didn't answer the original poster's question, but
Huh? You got it 7 times faster by only extracting that query from the
for loop and changing it to a group by? Or did you do anything else?
Sorry there were some other unnecessary queries that were mistakenly in the
measurement..
Here is the missing EXPLAIN.
mysql EXPLAIN SELECT
I think you'll get better results if you don't quote your numbers. Quotes
should be used for text and dates (depending) but not numbers.
- Original Message -
From: "Arturo Busleiman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 11:54
Subject: MySQL Tables
On Wed, 21 Feb 2001, Rolf Hopkins wrote:
I think you'll get better results if you don't quote your numbers. Quotes
should be used for text and dates (depending) but not numbers.
tried, but same results.
* MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/
* MP OnLine? EL BBS?
I am experimenting with MySQL for both Linux and Windows 2000. The trouble is, I do
not Have Visual C to compile the BDB code under Windows 2K. Is there any place to
download them for Windows 2000 in a binary form? Or is there somebody who can compile
them for me?
Have you tried checktable? Are there many numbers giving weird results or
just one? Are you running an old version of Mysql? Any of the columns auto
inc by any chance.
BTW you really shouldn't "cut" your original message unless it isn't really
important. This is in case someone knows the
Hi all,
I am sorry for asking this off topic question but I just need some opinions
or answers from you all. The question is "What are the limitations of
software testing?"
Thanks for any helps in advance.
Calvin
-
Before
95 matches
Mail list logo