> why not answer the question another user made hours ago?
> under which account do you try to start mysqld?
>
Agreed. Chances are good that if he goes into the Windows Services control
panel and gets the properties of the mysql service, he will find that it is
configured to start under a Windo
>
> 1. MyISAM locks _tables_. That can cause other connections
> to be blocked. Solution: switch to InnoDB. Caution: There
> are a few caveats when switching; see
> https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/
>
> 2. As mentioned by Shawn, the Query Cache can be more
> -Original Message-
> From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com]
> Sent: September 18, 2012 7:31 AM
> To: mysql@lists.mysql.com
> Subject: [Possible Spam]Php programmer
>
> Hi,
>
> I need help, I'm working on a project that need time que
Several MySQL fora, including all the Usage fora, have been overrun by
spam to the point of unusability, with no sign of effective remediation.
This gives the impression that a process of letting MySQL die of
neglect has begun.
PB
--
MySQL General Mailing List
For list archives: http
ish) autoreply-spammer
> from the list nbecause the only thing i understand is some
> price in € and that our spm-firewall is tagging it
>
> Original-Nachricht
> Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1'
> (111)
>
Can anybody remove this (i think spanish) autoreply-spammer
from the list nbecause the only thing i understand is some
price in € and that our spm-firewall is tagging it
Original-Nachricht
Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1
list.com/> - everything you could possibly want (to buy)
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, October 25, 2010 3:53 PM
To: Patrick Thompson; gto...@ffn.com; mysql@lists.mysql.com
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
Patrick-
you'll w
From: "Joerg Bruehe"
Hi!
Octavian Rasnita wrote:
I have tried, but with no difference.
I have changed some indexes and made the queries run faster, but I still
found a problem:
I use a module that does paging and it makes a select(*) and this query
takes a very long time.
I have also t
So it seems this account was cracked/hacked. Some of you may have
received some bullshit email about buying a TV. Please ignore that
message as it was sent from whoever hacked this account. It's already
been rectified.
I apologize for the inconvenience.. damn hackers.
for those that care the send
It´s working.
The problem was related to grant permission.
Thank you.
Cheers,
Hugo
-Mensagem original-
De: Gavin Towey [mailto:gto...@ffn.com]
Enviada em: terça-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges
From: Jacob, Raymond A Jr [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, February 13, 2008 7:22 PM
>To: mysql@lists.mysql.com
>Subject: [SPAM] - MS SQL emulator for MySQL in order to support MS
>Project Server, Sharepoint... - Email found in subject
>
&g
>-Original Message-
>From: Olaf Stein [mailto:[EMAIL PROTECTED]
>Sent: Thursday, January 17, 2008 12:13 PM
>To: Peter (MySQL List); MySql
>Subject: [SPAM] - Re: Sun and mysql - Email found in subject
>
>You have a point.
>But,
l.com
Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email
found in subject - Email found in subject
Oracle and Sun has a tight relationship right? Wouldn't there be a
conflict of interest?
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesda
Oracle and Sun has a tight relationship right? Wouldn't there be a
conflict of interest?
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 10:03 AM
To: [EMAIL PROTECTED]
Cc: Jerome O. Macaranas; mysql@lists.mysql.com
Subject:
Richard Heyes schrieb:
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
??? why, this payment goes to current owners and investors, not to MySQL
itself ...
but anyway, using Suns structures and "power" will help of course ...
--
Sebastian
--
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-
Big fish eats the small fish.. :)
Will this bring good things to MySQL?
-Original Message-
From: John Meyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 8:58 AM
To: Brett Harvey; mysql@lists.mysql.com
Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Message-
From: Dušan Pavlica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 5:08 AM
To: Hartleigh Burton
Cc: MySql
Subject: {Spam?} Re: mysqldump problem with large innodb tables...
Try to look for Lost connection error in MySQL manual and it can give your some
hints like http
x27;Stephen Cook'
> Cc : 'Jerry Schwartz'; 'MySQL List'
> Objet : RE : SPAM ?
>
> Hi,
>
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> > that link ought to help you
>
>
> Looks a bit extreme, as long as I feel there is some value
Hi,
> http://lists.mysql.com/[EMAIL PROTECTED]
>
> that link ought to help you
Looks a bit extreme, as long as I feel there is some value to be part of
this list :-).
I suspect all members of the list experience the same problem; I feel it
would be more valuable to solve the problem than to n
x27;LP'" <[EMAIL PROTECTED]>; "'MySQL
List'"
Sent: Sunday, March 25, 2007 6:07 PM
Subject: RE : SPAM ?
Hi,
What's kind of the message you guys mentioned?
Its always the same message from the same author with the same content,
same date same hour, it's
Hi,
> What's kind of the message you guys mentioned?
Its always the same message from the same author with the same content,
same date same hour, its the one below:
> -Message d'origine-
> De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
> Envoyé : jeudi 22 mars 2007 17:53
> À : [EMAIL PRO
What's kind of the message you guys mentioned?
- Original Message -
From: "LP" <[EMAIL PROTECTED]>
To: "'MySQL List'"
Sent: Saturday, March 24, 2007 10:13 PM
Subject: Re: SPAM ?
Hi,
I also get the problem of keep receiving the
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you.
Jacques Brignon wrote:
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi
> Hi,
>
> I also get the problem of keep receiving the email from the email list
Yeah, same here. I keep getting e-mail from a list that I subscribed
to and confirmed my subscription for ...
Dang, how do I solve that.
;)
--
Martijn
--
MySQL General Mailing List
For list archives: http:/
Hi,
I also get the problem of keep receiving the email from the email list
Regards
KEVIN
- Original Message -
From: "Jacques Brignon" <[EMAIL PROTECTED]>
To: "'Jerry Schwartz'" <[EMAIL PROTECTED]>
Cc: "'MySQL List'"
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
> -Message d'origine-
> De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
> Envoyé : jeudi 22 mars 2007 17:53
> À : [EMAIL PROTECTED]; 'James Tu'
> Cc : 'MySQL List'
> Objet : RE: Finding
On 3/9/07, Gloria McMillan <[EMAIL PROTECTED]> wrote:
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain when I started these survey and guest book it was
2:11:15 AM -0700 deafmickey <[EMAIL PROTECTED]>
wrote:
I would like to create a MySQL to protect my subscribers and clients
from receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query("CREATE TABLE members(
members_id INT NOT NULL
MySQL to protect my subscribers and clients from
>> receiving a spam emails.
>>
>> I can create a new table for MySQL and write new script for PHP
>>
>> MySQL:
>> mysql_query("CREATE TABLE members(
>> members_id INT NOT NULL AUTO_INCREMENT,
>> PRI
--On September 9, 2006 12:11:15 AM -0700 deafmickey <[EMAIL PROTECTED]>
wrote:
I would like to create a MySQL to protect my subscribers and clients from
receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query("CREATE TA
I would like to create a MySQL to protect my subscribers and clients from
receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query("CREATE TABLE members(
members_id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
email_address VARCHAR(50)&
Spam detection software, running on the system "marmalade.snp.org", has
identified this incoming email as possible spam. The original message
has been attached to this so you can view it (if it isn't spam) or label
similar future email. If you have any questions, see
[EMAIL
Since a couple of recent stable versions back (and more recently, MySQL
5.0.22), MySQL has been returning the column length (C API) of the 'Type'
column of a "show columns from.." statement as being 196605 (almost 192KB),
when this column only really contains data in the region of 10 bytes, if
Thanks Brent.
I increased my wait_timeout.But now also my aborted clients seems
increasing than connections.As u said most of my front end code use
mysql persistent connect only.Can u clarify my one more doubt that when
to use persistent connect and when to use mysql_connect and their
advanta
[EMAIL PROTECTED]
To
mysql@lists.mysql.com
cc
Subject
{Spam?} Limiting results from joins
Hey list;
Consider this statement:
SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
= m.manufactor_id && p.product_id = i.product_id;
Now, each unique product_id from
2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길:
> Hi,
>
> > mysql> select * from user_todo_german_english where wordid = '86851' and
> > posn = '1' and pos = 'm' AND mb_id='curious';
> > +-++--+--+-+
> > | mb_id | wordid | posn | pos | date_col
Thankyou Gabriel.
So how does one set a column comment then?
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 20 Apr 2006, Gabriel PREDA wrote:
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> From: Gabriel PREDA <[EMAIL PRO
OTECTED] On Behalf Of jay
Sent: Monday, February 27, 2006 6:06 PM
To: Philip Hallstrom
Cc: mysql@lists.mysql.com
Subject: [SPAM] - Re: MYSQL: Unlimited Forums, Scalablity Issues, advice
please? - Bayesian Filter detected spam
Hi Philip, thanks for the reply.
Single master + many read only slaves w
:00" AND "2006-02-22 23:59:59")
GROUP BY p.id
ORDER by qty ASC
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 22, 2006 2:58 PM
To: MySql
Subject: [SPAM] - Re: Inner join with left join - Bayesian Filter
detected spam
> Is
I keep forgeting to "reply all". Sorry
- Message transféré de Jacques Brignon <[EMAIL PROTECTED]> -
Date : Tue, 31 Jan 2006 13:33:22 +0100
De : Jacques Brignon <[EMAIL PROTECTED]>
Adresse de retour :Jacques Brignon <[EMAIL PROTECTED]>
Sujet : RE: [SPA
]
Sent: Monday, January 30, 2006 9:19 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a
result set - Bayesian Filter detected spam
Oops! forgoten to include the list in the relply
--
Jacques Brignon
- Message transféré de Jacques Brignon <
t; mysql> call test20();
>> Query OK, 0 rows affected (0.00 sec)
>>
>> mysql>
>> mysql> select @fdata, hex(@fdata)
>> ->
>> -> ;
>> ++-+
>> | @fdata | hex(@fdata) |
>> ++-+
>> | ââ©âº
d Godsey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 19, 2006 3:33 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - convert help - Bayesian Filter detected spam
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
I notic
David Godsey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 3:33 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - convert help - Bayesian Filter detected spam
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
FROM section of your SELECT
statement and paste it in the UPDATE section and move the WHERE section
of the SELECT to the UPDATE.
-Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 11:30 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Adding data
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 9:47 AM
To: MySQL General
Subject: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in
subject
2006/1/11, George Law <[EMAIL PROTECTED]>:
> Hi All,
>
>
[snip]
>
> I have to work on an automatic way to rotate these t
Francesco Riosa wrote:
> And another one is (in inverse order for laziness):
>
> select
> (8 & 1) AS `0`
> , (8 & 2 > 1) AS `1`
> , (8 & 4 > 1) AS `2`
> , (8 & 8 > 1) AS `3`
> , (8 & 16 > 1) AS `4`
> , (8 & 32 > 1) AS `5`
> , (8 & 64 > 1) AS `6`
> , (8 & 128 > 1) AS `7`
> ;
>
but this one look
>
>
>
>
>>>> "Gordon Bruce" < [EMAIL PROTECTED] > 1/10/06 1:44 PM >>>
>>>>
> Actually CONV converts from any base to any base so if it is base 10
> then just replace the 16's with 10's.
>
> Too much ti
n just replace the 16's with 10's.
Too much time looking at dump's.
-Original Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to
t;>
Actually CONV converts from any base to any base so if it is base 10
then just replace the 16's with 10's.
Too much time looking at dump's.
-Original Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed
Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's solution
like this:
SELECT
MID(CONV(HEX(245),16,2),1,1) AS `7`,
MID(CONV(HEX(245),16,2),2,1) AS `6`,
MID(CONV(HEX(245),16
and 'phone' with the appropriate table and column name
respectively.
-Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 8:09 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - concat string and update question - Found word(s)
remove list in the T
.
mysql> SELECT ABS(2);
-> 2
mysql> SELECT ABS(-32);
-> 32
This function is safe to use with BIGINT values.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 12:19 PM
To: Mester József; mysql
Subject: [SPAM] - Re:
2005 12:24 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - Re: locating ibdata1 and *.ibd files in different
directories. - Bayesian Filter detected spam
Hello.
> symbolic links! Thats a neat solution. Question: when you say
> "symbolic links for databases" do you mean links to ib
On Friday 16 December 2005 00:34, Stephen Cook wrote:
> I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
>
> And my filters remove anything that isn't from one of the mailing lists
> I subscribe to.
Did the spam actually come through the list, or did it just
l.com
Subject: Re: [OT] SPAM
I got one from mysql@lists.mysql.com, and one from
[EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
> Stephen Cook wrote:
>
>> What's the deal with SPAM on the li
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam f
What's the deal with SPAM on the list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Scheidecker Antunes" <[EMAIL PROTECTED]>
10/27/2005 05:31 PM
To
mysql@lists.mysql.com
cc
Subject
{Spam?} MySQL and dates puzzle
Hello all,
I have a TA table to record TA UNAVAILABLE times.
This table is quite simple. It has a TAID number, a start date and an
end date.
tbl_sc
You might try UNION with the 1st statement pulling all products with
groupid = 0 and the 2nd pulling 1 product with groupid > 1.
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 3:31 PM
To: MySQL List
Subject: [SPAM] - Query help - Bayes
ROM
> INFORMATION_SCHEMA.TABLES WHERE table_schema =
> 'test';" it would return
> "foo" - not "FOO".
>
> HTH
>
> Mark
>
> Mark Leith
> Cool-Tools UK Limited
> http://www.cool-tools.co.uk
> http://leithal.cool-tools.co.uk
>
>
>
> Best regards.
>
> Yannick
>
> -Message d'origine-
> De : Mathias [mailto:[EMAIL PROTECTED]
> Envoyé : Sunday, June 26, 2005 6:25 PM
> À : [EMAIL PROTECTED]
> Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
> [EMAIL PROTECTED]
> Objet :
o:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 6:25 PM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
hi Yannick,
This is my ultimate help.
See this url, you have all in it :
http://dev
r
> mysql and to the things requested mainly because there is a security issue.
>
> Yannick
>
>
>
>
> -Message d'origine-
> De : Mathias [mailto:[EMAIL PROTECTED]
> Envoyé : Sunday, June 26, 2005 4:03 PM
> À : [EMAIL PROTECTED]
> Objet : RE: [SPAM
2005 4:03 PM
À : [EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
Sorry but you are not the administrator else you have the root password.
So why search midday at 14 ?
Just connect with root pass and see if mysql is here.
Else mysql is like the oth
password from mysql.test;
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql>
>
> -Message d'origine-
> De : Mathias [mailto:[EMAIL PROTECTED]
> Envoyé : Sunday, June 26, 2005 8:35 AM
> À : [E
abase 'mysql'
mysql>
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 8:35 AM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter det
ile file ?
>
> Yannick
>
> -Message d'origine-
> De : Mathias [mailto:[EMAIL PROTECTED]
> Envoyé : Sunday, June 26, 2005 12:36 AM
> À : [EMAIL PROTECTED]
> Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
> [EMAIL PROTECTED]
> Objet : RE: [SPAM] - U
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 12:36 AM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick
Message d'origine-
> De : Mathias [mailto:[EMAIL PROTECTED]
> Envoyé : Sunday, June 26, 2005 12:01 AM
> À : Mathias
> Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED];
> mysql@lists.mysql.com; [EMAIL PROTECTED]
> Objet : RE: [SPAM] - Unable to install mysql - Bayesian F
et the root password ? How can I flush the privilidges ?
Thanks
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 12:01 AM
À : Mathias
Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED];
mysql@lists.mysql.com; [EMAIL PROTECTED]
Objet : RE: [SPAM
[EMAIL PROTECTED]' (Using password:
> > YES)
> > fujitsu:/home/yannick #
> >
> > => If I have no access with root, I can not create any new database
> > That is the problem.
> >
> > -Message d'origine-
> > De : Nils Valenti
Message d'origine-
> De : Nils Valentin [mailto:[EMAIL PROTECTED]
> Envoyé : Saturday, June 18, 2005 2:57 PM
> À : mysql@lists.mysql.com; [EMAIL PROTECTED]
> Cc : [EMAIL PROTECTED]
> Objet : Re: [SPAM] - Unable to install mysql - Bayesian Filter detected
> spam
>
>
.
-Message d'origine-
De : Nils Valentin [mailto:[EMAIL PROTECTED]
Envoyé : Saturday, June 18, 2005 2:57 PM
À : mysql@lists.mysql.com; [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi yannick,
Not sure if you have
t; priviledge issue.
>
> BEst regards
>
> Yannick
>
>
> -Message d'origine-
> De : Yannick [mailto:[EMAIL PROTECTED]
> Envoyé : Monday, June 13, 2005 11:54 PM
> À : [EMAIL PROTECTED]
> Cc : mysql@lists.mysql.com
> Objet : RE: [SPAM] - Unable to install mysq
H.
Kevin Struckhoff
Customer Analytics Mgr.
NewRoads West
Office 818.253.3819 Fax 818.834.8843
[EMAIL PROTECTED]
-Original Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 10:08 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - discuss: user management
CTED]
Sent: Monday, June 13, 2005 11:42 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hey guys,
I am not able to install properly mysql. Please see below the technical
details or the bug report.
The installation goes well until I try to add
o far from having it working ut I still have this
priviledge issue.
BEst regards
Yannick
-Message d'origine-
De : Yannick [mailto:[EMAIL PROTECTED]
Envoyé : Monday, June 13, 2005 11:54 PM
À : [EMAIL PROTECTED]
Cc : mysql@lists.mysql.com
Objet : RE: [SPAM] - Unable to install m
7;mysql'@'localhost';
ERROR 1046: No Database Selected
mysql> select test;
ERROR 1054: Unknown column 'test' in 'field list'
mysql> use test
Database changed
mysql> GRANT ALL ON test TO 'mysql'@'localhost';
ERROR 1044: Access denie
member turned my email into the spam report immediately without
thinking. Now I am recieving these.*
I doubt that there's any connection. It's impossible to tell for sure,
but the message was probably rejected because of the capital letters and
multiple exclamation points in the su
[EMAIL PROTECTED] wrote:
This is what I call WAY OVER REACTING.
*This member turned my email into the spam report immediately without
thinking. Now I am recieving these.*
I doubt that there's any connection. It's impossible to tell
for sure, but the message was probably rejected
This is what I call WAY OVER
REACTING.
This member turned
my email into the spam report immediately without thinking. Now I am
recieving these.
ThanksDonny LairsonPresident29
GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183
-Original Message-From
Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT sta
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
[snip]
From: "Jay Blanchard" <[EMAIL PROTECTED]>
> So if I index a date field (given -mm-dd) and then
>
> SELECT `userNames`
> FROM `userTable`
> WHERE SUBSTRING(`userBirthDate`, 6, 5) = SUBSTRING(NOW(), 6, 5)
>
> it is still very fast. I have a table with several thousand records in
> it and I
T-SQL style procedural scripting will not be initially available outside
of stored procedures. Stored procedures are new to 5.0 (still under
development) so what you want to code is not available, yet. You will
have to make program branch choices in a programming language as the SQL
engine cur
Hi,
Apologies, yes I have RTFM, and should've clarified my question. I
actually need to do something more like this:
IF(@SomeValue = 1)
BEGIN
THEN
SELECT "Data" as Column1,
"MoreData" as Column2
ELSE
SELECT "SomeValue is not = 1" as Error
END IF
Thanks,
Luke Venediger.
On
[snip]
I'm trying to write a conditional statement in my query. Is the
following possible in MySQL?
IF(@SomeValue = 1)
THEN
SELECT "The value is 1";
ELSE
SELECT "The value is not 1";
END IF
I've tried different variations and nothing seems to be working (I'm
getting syntax errors). I'm using My
[snip]
How do I create table that uses timestamp in -dd-mm format as
primary id
(no duplicates)?
[/snip]
CREATE TABLE `tblFoo` (
`timeID` timestamp(14) NOT NULL,
PRIMARY KEY (`timeID`),
) TYPE=MyISAM;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with "\" (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
""Jay Blanchard"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
[snip]
What'
[snip]
What's the deal w/ backslash?
[/snip]
It is an escape character. In order to get things with backslashes, as
you have deduced, you
SELECT "\\"
Do you have a column '\'? If so, why?
Backslashes are often used in this way...
SELECT businessName FROM table WHERE businessName = 'Doc\'s';
[snip]
You haven't stated the resources required for the project in the query.
Try this ...
SELECT project.proj, project.rsrc, people.name
FROM project LEFT JOIN
people ON project.rsrc=people.rsrc
WHERE project.rsrc = 'wood'
AND project.rsrc = 'canvas'
Not tested, but limits people to thos who h
[snip]
I'm pretty sure this is a good starting point, but that's just matching
resource
to resource without excluding Lincoln from building an Ark (no canvas).
mysql> SELECT project.proj,project.rsrc,people.name FROM project LEFT
JOIN
people ON project.rsrc=people.rsrc;
+--+-+-
[snip]
$dbhost = 'localhost';
[/snip]
Try changing this to 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which flag did you use to define the datadir for configure? --datadir
doesn't do the trick. --localstatedir does. Also, you might want to
consider setting --prefix as well.
--V
sean c peters wrote:
The problem is that i did build 4.1.3 florm a source distribution, and set the
datadir via con
I know my emial; accounts been getting quite alot of spam, though it's been like that
for a while now for my self. All I know my email was harvested from other lists too;
which may have been the case for myself.
Chris
>
> From: Daniel Kasak <[EMAIL PROTECTED]>
> Date: 200
Hi all.
Over the last 2 days, both my home and work email addresses have been
hit with a sudden surge in spam, and the content in both cases is the
same. Another strange thing is that my home address got basically none -
until now.
I'm assuming my addresses have been harvested from this
1 - 100 of 183 matches
Mail list logo