Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
I want to grant access to databases and tables to users,but only to a certin
databases and tables.
I red the how-to but both grant and revoke commands does not seems to work
(he execute the command but says that 0 records we
On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> I agree. It's really a drag that you can't use databases very well from
> within Perl very easily. I wish that someone would invent a database
> inferface for Perl. And it'd be really cool if they'd do it in such
> a way that the g
On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> I agree. It's really a drag that you can't use databases very well from
> within Perl very easily. I wish that someone would invent a database
> inferface for Perl. And it'd be really cool if they'd do it in such
> a way that the g
> > I am bothers me.
> It bothers me that that the MySQL people have a bias towards PHP.
> PHP is an inferior language. Deal with perl instead.
>
>
> Robert
Ouch.Death to all fanatics!!!
Do you have any question or are you just boiling?
It's just that M
It would be a huge help to get hold of MySql 4.1.
What's "shaken out" mean? Is 4.1 still mid-development, or is it in alpha,
more or less finished, and needs debugging?
Is there anyway soon that someone could build and release some binaries? I'd
be happy to do testing if 4.1 is in a semi-usable
On 11/9/02 11:31 PM, "Georg Richter" <[EMAIL PROTECTED]> wrote:
> Looks like you're not very familar with the spirit of Open Source:
>
> Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
> benefits and of course some disadvantages. But this competition helps each
> one to i
On Sunday 10 November 2002 14:12, Robert Macwange wrote:
> PHP is an inferior language. Deal with perl instead.
Looks like you're not very familar with the spirit of Open Source:
Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
benefits and of course some disadvantages.
On Sun, Nov 10, 2002 at 05:49:37AM +, andy thomas wrote:
>
> perl doesn't have anything like as much database support, which is
> why PHP has become popular in the web community.
Oh, let's not go down this road. Perl and PHP both have excellent
database support. And they're both incredibly p
On Sat, 9 Nov 2002, R. Hannes Niedner wrote:
> On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote:
>
> > I am bothers me.
> > It bothers me that that the MySQL people have a bias towards PHP.
> > PHP is an inferior language. Deal with perl instead.
> >
> > ...
On Sun, Nov 10, 2002 at 05:12:40AM -0800, Robert Macwange wrote:
>
> It bothers me that that the MySQL people have a bias towards PHP.
They don't.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 95 days, p
On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote:
> All,
>
> Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Well, if you pull the source code, it's there. But I suspect it'll be
a few months before you start seeing pre-built binaries available.
There's
On Sat, 2002-11-09 at 23:53, Chip Shabazian wrote:
> ok, here is my code without all of the html (sorry people). I'm trying
> to get a sum of the field runtime. With this code, I get "Resource id
> #3" as an error. Any help getting me to the proper result would be
> greatly appreciated.
>
> @$
ok, here is my code without all of the html (sorry people). I'm trying
to get a sum of the field runtime. With this code, I get "Resource id
#3" as an error. Any help getting me to the proper result would be
greatly appreciated.
".$dvd_time_result."";
?>
Thanks,
Chip
All,
Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Thanks,
Greg.
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
I'd suggest that he's just trolling.
-Original Message-
From: R. Hannes Niedner [mailto:hannes.niedner@;gmx.net]
Sent: Saturday, November 09, 2002 9:27 PM
To: MySQL Mailinglist
Subject: Re: PHP bias
On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote:
> I am bothers me.
> I
On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote:
> I am bothers me.
> It bothers me that that the MySQL people have a bias towards PHP.
> PHP is an inferior language. Deal with perl instead.
>
>
> Robert
Ouch.Death to all fanatics!!!
Do you have
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
-
Before posting, please check:
http://www.mysql.
Rick Mann wrote:
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
>You are missing something, I am afraid. To quite Sun's Javadoc for the
>PooledConnection class
Thank you so much for the quick reply.
Now I understand why the im
[HUNDREDS of lines clipped...]
PLEASE, folks, try to trim up your quotes a bit?
Adding one line while mindlessly quoting a thread that has itself been mindlessly
quoted at least a half-dozen levels deep may not bother those who get separate
messages, but those who get the digest version suffer
Mysql version: 3.23.53
Background: I've got a master and slave setup
and I'm switching to a new master server. In the process of switching I
need the new master to be a slave for awhile. However, after copying
over a snapshot of my data I found that mysql dies whenever the slave
thread sta
Ok, I can't figure out how to make my "select sum(runtime) from list"
query work properly. At the bottom is the entire page. I've tried a
few different things, but can't figure out how I'm SUPPOSED to set this
up.
Here is what I think are the relevant lines:
$dvd_time_query = "select sum(runtim
if you have a windows box that you can use as a
front end, download corereader from
http://www.corereader.com it lets you do point
and click queries, so you can quickly experiment
with simple queries.
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] writes:
>
> > Hi,
> > Does versi
although i make a living from their products and
corereader runs under windows, i really really
hate to give macrosoft a plug. but i keep seeing
this kind of question here, so here's what i do,
if you have the tools.
1. i fire up enterprise manager for ms sql
server, because it has a prett
You don't *need* a primary key on a table. You don't a key on a table
at all, if that's what you want.
You can turn off this error message without altering your table by
specifying --safe-updates=0 when you start the mysql client. This
option apparently is turned on by default in 4.x. The point
Hello all!
I am working on a site which is using mod_perl and a mysql database on
Linux with Apache. I am also putting cookies and user address information
into a "cookies" table to fill up form fields for subsequent visits.
Standard enough. Also, the database is on the same server as apache.
Now
hello everyone:
1) in my school groups are called forms, so I used it not to confuse you
2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any
3) now I have, and...
4) the query worked.
thanks for your help,
Emilio Pisanty
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
> -Original Message-
> From: 3mip1s4l
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
>
> > > tables have met with a 1175 error ("You are using safe update mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give us some more
>
Hi,
I don't see any "group" column in your table, are you displaying the right
table (describe pupils; instead of describe pupuils; ?).
A KEY column is a column which have an INDEX on it.
Regards,
Jocelyn
- Original Message -
From: "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]>
To: "R.
> > tables have met with a 1175 error ("You are using safe update mode and you
> > tried to update a table without a WHERE that uses a KEY column").
> Nothing is obvious and is hard to advise you if you don't give us some more
> info on the table structure and the update query you have trouble wi
On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]>
wrote:
> hello everyone:
>
> to begin with, I apologise for asking a question which is probably
> obvious. My name is Emilio Pisanty and I and one of the two makers of my
> school's website. recently we updated the database system
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on mysql) from
version 3.23 to version 4. since then, any attmepts we've made t
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
> You are missing something, I am afraid. To quite Sun's Javadoc for the
> PooledConnection class
Thank you so much for the quick reply.
Now I understand why the implementation of poo
OK, I lost my password. Snicker away.
I tried using the instructions I found in the MySQL manual and got hung
up on starting the MySQL server in an unsecured state. The instructions
say to start mysqld with the --skip-grant-tables option. When I do I
get a "Fatal Error: Please read "Security" se
On Sat, 2002-11-09 at 14:45, john wrote:
>
>
> Ok.. I got the /etc/my.cnf under control, but now when I do this:
>
> root@rock:/etc# mysqladmin -u root -h rock password *
> mysqladmin: connect to server at 'rock' failed
> error: 'Host 'rock.biohazard.org' is not allowed to connect to this
>
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL server'
Then I tried this:
root@rock:/etc# mysql
I dont have a my.cnf file, so I "touched" /etc/my.conf still doesnt
work. Where do
I find a .cnf file to copy over?
and
root@rock:/var/run/mysql# ls
mysql.sock= << it exists.
What could my problem be..? I even upgraded. I am using Slackware 8.1
with 2.4.19 kernel. Maybe that will help.
Thanks s
MySQL must be the owner of the data dir. Check the owner of MySQL data
dir.
It was, but I have since changed it to root and it works fine now. Any
idea why this would be?
drwxr-xr-x 12 root mysql4096 Nov 8 18:00 ./
drwxr-xr-x 15 root root 4096 Nov 8 20:12 ../
drwxr-x
On 11/9/02 3:01 AM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote:
> Greetings
>
> I have problems executing very simple UPDATE query. I do not know whether it
> is a bug or not, but it works in Access and also works with mySQL, but only
> from access using linked tables.
> Query is as followes:
>
>
Hi,
What error you get when try to stop mysql daemon ?..or tell us what is in
mysqld.log?
Maybe we can help you.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMA
create the users again or whatever you had before.
Thomas
On Sat, 9 Nov 2002 09:38:32 -0700 "System Administrator a.k.a. The Root of the
Problem" <[EMAIL PROTECTED]> wrote:
> since my of my customers are reporting that they are getting:
>
> Search Results for 'T5Y1M4'
> Access denied for user
since my of my customers are reporting that they are getting:
Search Results for 'T5Y1M4'
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were
found for 'T5Y1M4'.
Searching again for the two-digit postal code 'T5'.
WHAT must I do to correct his??
On Sat, Nov 09, 2002
Thanks you all for your nice suggestions. The thing is, for some reason, I
could not stop the mysqld using 'mysqld stop'. Any insight about why this
would fail?
Another question, which might not be a *pure* mysql one, is: I ran a
script to load my mysql database, but it has not finished the job fo
Beauford,
Saturday, November 09, 2002, 8:27:58 AM, you wrote:
B> I just reinstalled Slackware and now have the unenviable task of getting
B> Mysql working. What a major pain in the ***. Anyway, here are the
B> errors. I have read manuals, searched the web, as well as the
B> newsgroups, and still c
Daya,
Saturday, November 09, 2002, 2:28:07 PM, you wrote:
DKD> Hi can anybody tell me how can i insert rtf data in my sql, since it
DKD> contains escape characters
DKD> like this
DKD> {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
DKD> Verdana;}{\f1\fnil\fcharset2 Webdings;
SpyProductions,
Friday, November 08, 2002, 10:50:33 PM, you wrote:
SST> Well hells bells!
SST> Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
SST> page? :)
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Eugene,
Saturday, November 09, 2002, 1:33:39 AM, you wrote:
EB> May be this was reported already.
EB> I have windows 2000 using mysql version 4.0.3-beta-nt
EB> When I ran a query like
EB> select distinct a.* from tasks a, gnrlasoc b;
EB> mysqld-nt.exe crashes.
EB> I know this query makes no
Looks as if security got tightened and now next to no databases with
Web/php are geting accessed. What needs to be fixed?
Customers are yelling.
Rectification needed ASAP!
forwarded message --
Hi ,
I corrected the core mysql tables (there was nothing in them)
Your root password for my
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are name
As Far As I Know
> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are named "mysqld"...less one "mysqld_safe"
> which
Yes.All processes are named "mysqld"...less one "mysqld_safe" which is "main
guilty" for keeping mysql daemon in "life".
P.S.
Please tell me (if you wish)...what means AFAIK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EM
Hi can anybody tell me how can i insert rtf data in my sql, since it
contains escape characters
like this
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}}
{\colortbl ;\red0\green0\blue0;\red0\green0\bl
just kill mysqld_safe and then the mysqld process :)
(but AFAIK all the mysql thread are names mysqld ??)
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, November
...because not all mysql processes are named "mysql" and is one (and you
know about this) which is for safe running(mysqld_safe or safe_mysqld) which
create new threads when another is "killed".
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e
Hi,
Why not trying killall -9 mysqld ?
Regards,
Jocelyn
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 12:08 PM
Subject: Re: mysqld refuse to die
> Hi,
> If you really wish to ki
Hi,
If you really wish to kill the mysql daemon in this way :
You should try :
ps -ef |grep "mysql"
...show all the mysqld processes and after this must enumarate all pid of
processes in a single kill command.
E.g.
kill -9 1024 1056 ...(processes which are open).
But it's more "health" if you can s
Greetings
I have problems executing very simple UPDATE query. I do not know whether it
is a bug or not, but it works in Access and also works with mySQL, but only
from access using linked tables.
Query is as followes:
UPDATE Table_name SET Field_name = Left(Field_name, 4) & 'a' &
Right(Field_name
I use navicat http://www.mysqlstudio.com/.
ing. stefano scattini
-Messaggio originale-
Da: tmb [mailto:topmailbox@;yahoo.com]
Inviato: venerdì 8 novembre 2002 13.18
A: [EMAIL PROTECTED]
Oggetto: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP; the
command it is not execute and it remain pending (the prompt of mysql doesn't
return); instead all is normal under 3.53.
Which is the problem ?
tks & regards
-
Massi
b4712.xici.net
ÓʼþÄÚÈÝÓëÒÔÏÂÎÄ×ÖÎÞ¹Ø=
ÓÅÁªÍøÂç http://www.chinamysql.com רҵÌṩ¸÷ÀàÐéÄâÖ÷»ú£¬²»ÂúÒâ¿É»ñÍË¿î¡£
Ç¿ÊÆÌײͣº100MÖ÷»úËͶ¥¼¶ÓòÃû£¬ËÍ10¸ö10MÆóÒµÓÍÏ䣬¼ÓËÍ20¸ö¶þ¼¶ÓòÃû£¬½öÐè318Ôª/Ä꣡
ÈýÁú֤ȯͶ×Ê http://3long.sayba.com
ΪÄú
Greeting to all. Here is some data on my server :
[student:99] /usr/local/bin> mysqladmin -u root -p version
9:18
Enter password: ***
mysqladmin Ver 8.23 Distrib 3.23.52, for hp-hpux11.00 on hppa2.0w
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes wit
On Sat, 9 Nov 2002, Jack Chen wrote:
> I have just figured out:
>
> kill -9 xxx (process number)
>
Hi!
Did you try just 'kill xxx'? How about 'mysqladmin shutdown'? 'kill -9' is
an extremely cruel way to bring a server down. You may get corrupted
databases that way, although sometimes it's the o
62 matches
Mail list logo
