RE: [Suspected Spam][Characteristics] Re: NET START MYSQL QUESTION?
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 Windows account other than the System account, and that the Windows account in question either does not have the required privileges or it is locked. I'd probably just change it to start under the System account. --Erio Disclaimer - May 12, 2013 This email and any files transmitted with it are confidential and intended solely for Reindl Harald,mysql@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of Physicians' Managed Care or Physician Select Management. Warning: Although Physicians' Managed Care or Physician Select Management has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: [Suspected Spam][Characteristics] RE: Slow Response -- What Does This Sound Like to You?
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 trouble
than it is worth. However 90 seconds cannot be blamed on the
QC. Still, shrink it or turn it off:
* If frequently writing to tables, turn it off (type=OFF _and_ size=0)
* If less frequently, then decide which queries will benefit,
add SQL_CACHE to them, set type=DEMAND and size=50M (no larger).
3. Meanwhile, try to make that long query more efficient.
Can you show it to us, together with SHOW CREATE TABLE, SHOW
TABLE STATUS, and EXPLAIN ?
Thanks for the feedback, Rick.
There are 1200+ tables in the database, so I don't think you want a SHOW CREATE
TABLE, SHOW TABLE STATUS, EXPLAIN for all of them. :-) The query in question is
always some variation of the following. From looking at this, which table(s)
would you like to see this information for?
# Time: 130507 18:14:26
# User@Host: site150_DbUser[site150_DbUser] @ cognos08.mycharts.md
[192.168.10.85]
# Query_time: 82 Lock_time: 0 Rows_sent: 1 Rows_examined: 914386
select (mod(dayofweek(`Query1`.`Appointment_Date`)+7-1,7)), {fn CONCAT({fn
CONCAT({fn CONCAT(cast(extract(hour from
`Time_Difference_Query`.`Created_Date`) as char(25)), ':')},
cast(extract(minute from `Time_Difference_Query`.`Created_Date`) as
char(25)))}, ':')}, `Time_Difference_Query`.`Created_Date`,
`Query1`.`Appointment_Provider_Name` from (select distinct
`EMR_ENCOUNTER`.`encType` as Encounter_Type , case when
`EMR_ENCOUNTER`.`encLock` = 0 then 'UnLocked' else 'Locked' end as
Chart_Lock_Status , `EMR_ENCOUNTER`.`notesDoneTime` as Notes_Done_Time ,
`EMR_ENCOUNTER`.`dateOut` as Notes_Done_Date , `EMR_ENCOUNTER`.`timeIn` as
Appointments_Checked_In , `EMR_ENCOUNTER`.`timeOut` as
Appointments_Checked_Out , `EMR_ENCOUNTER`.`depTime` as
Appointments_Departure_Time , `EMR_ENCOUNTER`.`arrivedTime` as
Appointments_Arrived_Time , `EMR_ENCOUNTER`.`endTime` as
Appointment_End_Time , `EMR_ENCOUNTER`.`startTime` as
Appointment_Start_Time , `EMR_ENCOUNTER`.`date` as Appointment_Date ,
`EMR_ENCOUNTER`.`encounterID` as Encounter_ID , `EDI_FACILITIES`.`Name` as
Facility_Name , `APPOINTMENT_PROVIDER`.`uid` as Appointment_Provider_ID ,
{fn CONCAT({fn CONCAT({fn CONCAT({fn CONCAT(`APPOINTMENT_PROVIDER`.`ulname`, ',
')}, `APPOINTMENT_PROVIDER`.`ufname`)}, ' ')},
`APPOINTMENT_PROVIDER`.`uminitial`)} as Appointment_Provider_Name from
(`enc` `EMR_ENCOUNTER` LEFT OUTER JOIN `edi_facilities` `EDI_FACILITIES` on
`EMR_ENCOUNTER`.`facilityId` = `EDI_FACILITIES`.`Id`) LEFT OUTER JOIN
(`doctors` `APPOINTMENT_DOCTOR` INNER JOIN `users` `APPOINTMENT_PROVIDER` on
`APPOINTMENT_DOCTOR`.`doctorID` = `APPOINTMENT_PROVIDER`.`uid`) on
`EMR_ENCOUNTER`.`doctorID` = `APPOINTMENT_DOCTOR`.`doctorID` where
`EMR_ENCOUNTER`.`encType` = 2 and `EMR_ENCOUNTER`.`date` between
cast('2011-01-01' as date) and cast('2013-05-07' as date) and
`EMR_ENCOUNTER`.`patientID` 8663 and `EMR_ENCOUNTER`.`VisitType` 'PTDASH'
and `EMR_ENCOUNTER`.`deleteFlag` = 0 and `APPOINTMENT_PROVIDER`.`UserType` = 1
and `APPOINTMENT_PROVIDER`.`delFlag` = 0 and `EDI_FACILITIES`.`DeleteFlag` = 0)
`Query1` LEFT OUTER JOIN (select distinct `Addressed_Query`.`moddate` as
Locked_Date , `Created_Query`.`moddate` as Created_Date ,
`Created_Query`.`encounterid` as encounterid , `Created_Query`.`reason` as
reason , `Created_Query`.`Patient_Name` as Patient_Name from (select
distinct `SQL1`.`moddate` as moddate , `SQL1`.`encounterid` as encounterid
, `SQL1`.`actionflag` as actionflag , `SQL1`.`ufname` as ufname ,
`SQL1`.`ulname` as ulname , `SQL1`.`reason` as reason , {fn CONCAT({fn
CONCAT(`SQL1`.`ulname`, ', ')}, `SQL1`.`ufname`)} as Patient_Name from
(select users.ufname,users.ulname,cast(reason as char(30)) as reason,
telenc_loghist.actionflag,telenc_loghist.encounterid,telenc_loghist.moddate
from telenc_loghist
inner join enc on
enc.encounterid=telenc_loghist.encounterid
inner join users on users.uid=enc.patientid where
actionflag in(0) and enc.date between '2011-01-01' and '2013-05-07') `SQL1`)
`Created_Query` LEFT OUTER JOIN (select distinct `Q2`.`moddate` as moddate ,
`Q2`.`encounterid` as encounterid , `Q2`.`actionflag` as actionflag from
(select
telenc_loghist.actionflag,telenc_loghist.encounterid,telenc_loghist.moddate
from telenc_loghist
inner join enc on
enc.encounterid=telenc_loghist.encounterid where actionflag in(4) and enc.date
between '2011-01-01' and '2013-05-07') `Q2`) `Addressed_Query` on
`Created_Query`.`encounterid` = `Addressed_Query`.`encounterid` where NOT
`Addressed_Query`.`moddate` is null) `Time_Difference_Query` on
`Query1`.`Encounter_ID` = `Time_Difference_Query`.`encounterid` where
RE: [Possible Spam]Php programmer
-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 query in Mysql. I
want
to display a time in php page, that took mysql to execute 100 000 records
Sent from my BlackBerryR wireless device
-
S naMlgi
oltrishp/s.s.mylTuucb t/isylomq
Taken from the PHP website:
?php
function microtime_float()
{
list($usec, $sec) = explode( , microtime());
return ((float)$usec + (float)$sec);
}
$time_start = microtime_float();
# do your query here
$time_end = microtime_float();
$time = $time_end - $time_start;
echo It took $time seconds to do whatever you just did\n;
?
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
MySQL fora overrun by spam
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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: SPAM: please remove gregario.es from the list
hi The message sid this : Dear, inform you that your email _ * has not been delivered to the recipient * _ because there is no mailbox in the domain A greeting. I have many problems sending mail , any problem or any ideas? 2011/4/2 Reindl Harald h.rei...@thelounge.net 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' (111) Datum: 2 Apr 2011 17:17:20 +0200 Von:no-re...@gregario.es An: h.rei...@thelounge.net Estimad@, le informamos que su mensaje de correo electrónico _*no ha sido entregado al destinatario*_ ya que no existe el buzón de correo en el dominio Un saludo. Consigue gratis tu bono de 30 € para utilizar con Google Adwords http://www.googld.es/ Te regalamos una camiseta personalizada con tu foto http://clk.tradedoubler.com/click?p(22814)a(1548325)g(1076669)url(http://www.vistaprint.es/male-female-tshirts.aspx) -- Mit forever My Blog http://www.redcloverbi.wordpress.com My Faborite Webhttp://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm http://www.technologyreview.com/
SPAM: please remove gregario.es from the list
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' (111) Datum: 2 Apr 2011 17:17:20 +0200 Von:no-re...@gregario.es An: h.rei...@thelounge.net Estimad@, le informamos que su mensaje de correo electrónico _*no ha sido entregado al destinatario*_ ya que no existe el buzón de correo en el dominio Un saludo. Consigue gratis tu bono de 30 € para utilizar con Google Adwords http://www.googld.es/ Te regalamos una camiseta personalizada con tu foto http://clk.tradedoubler.com/click?p(22814)a(1548325)g(1076669)url(http://www.vistaprint.es/male-female-tshirts.aspx) signature.asc Description: OpenPGP digital signature
RE: [SPAM] RE: mySql versus Sql Server performance
Thanks Martin, though I'm somewhat confused by your message - there are no
joins in the query (unless the longtext s thought of that way) and the Explain
seems to indicate the query is using the ItemsById primary index (which is what
I would expect).
Patrick
myListhttp://www.mylist.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 want to determine if your predicates are implementing indexes or FTS
with EXPLAIN statement
http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
you'll need a plan to determine if the join-type of resultsets returned from
the Queries are NL, Hashed or sort-merge
http://en.wikipedia.org/wiki/Join_%28SQL%29
Each one has pros/cons dependening on the cardinality of the inner resultset vs
the outer resultset
hth
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: patrick.thomp...@channelintelligence.com
To: gto...@ffn.com; mysql@lists.mysql.com
Date: Mon, 25 Oct 2010 15:31:26 -0400
Subject: RE: mySql versus Sql Server performance
Query:
SELECT *
FROM Item
WHERE CollectionID = 'a0d3937b-f5a8-0640-dec8-bdd60f7f4775' AND ExternalID =
'fred1'
Explain Extended:
select '17304' AS `ID`,'fred1' AS
`ExternalID`,'a0d3937b-f5a8-0640-dec8-bdd60f7f4775' AS `CollectionID`,NULL AS
`ItemTypeVersion`,'Item
xmlns=http://cipl.codeplex.com/CIPlItem1.xsd;Valid1/ValidItemStatus100/ItemStatusExternalIDfred1/ExternalIDModifiedDate2010-10-25T15:06:55.7188551-04:00/ModifiedDatePersonType
xmlns=http://cipl.codeplex.com/CIPlOther1.xsd;AddressUSAddressTypeCityStringCelebration
1/String/CityCountryStringUSA/String/CountryStateStringFL/String/StateStreetString1170
Celebration blvd
1/String/StreetZipInt3234748/Int32/Zip/USAddressType/AddressAlternateAddresses
Count=2USAddressTypeCityStringCelebration
1/String/CityCountryStringUSA/String/CountryStateStringFL/String/StateStreetString1170
Celebration blvd
1/String/StreetZipInt3234748/Int32/Zip/USAddressTypeUSAddressTypeCityStringSeattle
1/String/CityCountryStringUSA/String/CountryPhoneNumbers
Count=2PhoneNumberTypeAreaCodeInt32206/Int32/AreaCodeNumberInt327819281/Int32/NumberTags
Count=1Stringnever answered
1/String/Tags/PhoneNumberTypePhoneNumberTypeAreaCodeInt32206/Int32/AreaCodeNumberInt329991971/Int32/NumberTags
Count=1Stringcell
1/String/Tags/PhoneNumberType/PhoneNumbersStateStringWA/String/StateStreetString12070
Lakeside pl
1/String/StreetZipInt3298126/Int32/Zip/USAddressType/AlternateAddressesCreateDateDateTime2010-10-25T15:06:55.7168549-04:00/DateTime/CreateDateNameStringfred1/String/NameTags
Count=4Stringfirst/StringStringsecond/StringStringthird/StringString1/String/Tags/PersonType/Item'
AS `ObjectText`,'2010-10-25 15:06:55' AS `EnteredDate`,'2010-10-25 15:06:55'
AS `LastModDate` from `ciplitemwell0404`.`item` where
(('a0d3937b-f5a8-0640-dec8-bdd60f7f4775' =
'a0d3937b-f5a8-0640-dec8-bdd60f7f4775') and ('fred1' = 'fred1'))
Explain:
1, 'SIMPLE', 'Item', 'const', 'PRIMARY,ItemsByID', 'PRIMARY', '889',
'const,const', 1, ''
Table definition:
CREATE TABLE `ciplitemwell0404`.`item` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ExternalID` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`CollectionID` varchar(40) CHARACTER SET utf8 NOT NULL,
`ItemTypeVersion` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`ObjectText` longtext NOT NULL,
`EnteredDate` datetime NOT NULL,
`LastModDate` datetime NOT NULL,
PRIMARY KEY (`CollectionID`,`ExternalID`),
UNIQUE KEY `ID` (`ID`),
KEY `ItemsByID` (`CollectionID`,`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29687 DEFAULT CHARSET=latin1;
This is just the retrieve side - which seems to be around 1.5 times slower
than the equivalent Sql Server numbers.
The update is much
Re: [Spam][78.6%] Re: Differences between 2 MySQL instances
From: Joerg Bruehe joerg.bru...@sun.com 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 tried to do select(id) where the id column is the primary key, but it runs very slow also. I have also seen that select(*) with various where conditions is still very slow. Is there any trick to make the select(*) queries run faster within an InnoDB table? You should accept the fact that 5.1 has improvements over 5.0, some of them being better optimization resulting in faster execution. Upgrade the 5.0 installation to 5.1 to profit from the newer version. I have tried the select(*) with InnoDB under 5.1, but it is still very slow (dozens of seconds) while with MyISAM is instant. I know that InnoDB works differently and cannot do that select so fast, but... dozens of seconds is too much. I have succeeded to make the main select very fast, but then the select(*) needed for paging the results is hundreads times slower. I have also tried select SQL_CALC_FOUND_ROWS and select found_rows() but it is much slower than a simple select(*). Thanks. Octavian __ Information from ESET NOD32 Antivirus, version of virus signature database 5224 (20100624) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
sorry for the spam
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 senders IP is 115.49.95.201 mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RES: [SPAM] RE: Remote connection
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 connection 1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect If you continue to have problems, give us the exact steps you have tried and the exact error message you are receiving. Please try to connect using the mysql command line. Regards, Gavin Towey -Original Message- From: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ***SPAM*** RE: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice..
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 to 'root'@'ip of my machine' and flushed it, it worked fine. But I have a qestion below: GRANT ALL PRIVILEGES ON *.* to 'root'@'IP'; FLUSH PRIVILEGES; However, Would '*.def.com' work in the place of IP?, as I feel that giving privileges for each IP for each machine that is going to access the mysql server would be tedious and not recommended choice. Please let me know. Regards Ahmad -Original Message- From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 3:34 PM To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 - Innovation Group) Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice.. Ok It means that DNS not configured so better give the IP address instead of hsostname and check using in mysql as Show grants for [EMAIL PROTECTED]; This should show u the grants Thanks Regards, Dilipkumar MphasiS an EDS Company | No 25,Steeple Reach,Cathedral Road | Chennai | India | 91 44 28113801 |Extn 2216 Mobile: 9884430998 | 9962029004 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 3:30 PM To: Parikh, Dilip Kumar; mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: RE: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice.. Hi, I did that too, I executed the command - GRANT ALL PRIVILEGES ON *.* to 'root'@'localhost' ; I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where abc.def.com is my machine name But both of these did not work, I did not mention this in my earlier mail. Can you please let me know if there is any other way out. Regards Ahmad -Original Message- From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 3:26 PM To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 - Innovation Group) Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice.. Importance: High Hi all, First try checking out the grant for the particular user ? Show grants for user@'abc.def.com'; If u don't find the results u can give grant as :- Grant select on *.* to user@'abc.def.com' identified by ''; Flush privileges; Thanks Regards, Dilipkumar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 3:21 PM To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: Problem - Host 'abc.def.com' is not allowed to connect to this MySQL server, Please advice.. Importance: High Hi All, I am facing a particular problem which i have explained here. Can you please let me know a solution for this. From my web application, I am trying to connect the MySQL server by using the IP address as the server name, and it says the following error: Host 'abc.def.com' is not allowed to connect to this MySQL server Options that I tried: (from the information availabe on internet) a) I tried modifying the hosts file in WinNT directory to include this host name (assuming that it was not understanding the IP), but it did not work b) I tried adding a record with the IP as host and user as root in user table of mysql database it did not work c) I tried adding a record with the 'abc.def.com' as host and user as root in user table of mysql database it did not work d) I tried enabling Remote Access in MySQL Server instance config wizard but since the root users password is not set, it is not allowing me go forward (i.e. the next button is disabled) e) If I try to reset the password while configuring the MySQL Server Instance, it does not allow me to do so f) I tried adding a record with the '%' as host and user as root in user table of mysql database it did not allow me to add the record Regards Ahmad Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject
http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) -Original Message- 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 I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibility mode existed for/in MySQL. Does such a beast exist? In particular, I wanted to use MySQL as backend database for MS Project Server and Sharepoint, and other applications that use MS SQL as their backend database. Again, I apologize for asking this question. I could not figure out the correct string to search for such software. thank you This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Sun and mysql - Email found in subject
-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, facebook makes NO money at this time, has about 400 employees and Microsoft estimates its values at 15 billion dollars. I simply think this is nuts. Maybe I am too old with 30, but I have never even been to facebook. It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. With a perfect business plan I bet it will. Just because 50 million people know a website, it does not mean it makes money automatically. Yes, I agree but once this 50 million visits the website and it would be a different story. Olaf On 1/17/08 11:37 AM, Peter (MySQL List) [EMAIL PROTECTED] wrote: On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http
RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
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 Brett Harvey wrote: http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 No offense, but this is definitely not off topic when it comes to MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
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-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in 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 This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject
I was lurking on Sun's website.. they are also carrying PostgreSQL in their line of products.. Great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.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: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in 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 This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: {Spam?} Re: mysqldump problem with large innodb tables...
Have you considered using the archive storage engine? I have gotten 30:1
compression using it.
Create table archive_multimedia engine=Archive as select * from multimedia
table
John Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475
-Original 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://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Dusan
Hartleigh Burton napsal(a):
Hi All,
I have a database which is currently at ~10GB in it's test phase. It
is containing uncompressed audio and is expected to reach 1.5TB in no
time at all. I am just running some backup tests and I have been
having lots of problems creating an accurate backup.
I have tried both MySQL Administrator mysqldump, both applications
drop out on the same table, the table `trackdata` which contains ~9GB
worth of data. There is no single row any larger than 50MB, most
average around 40MB. Windows 2000 Server, MySQL v5.0.37-community-nt
and all tables are InnoDB.
If anyone can help me out with this problem the assistance is greatly
appreciated. I have scoured google and various other sources and not
found much information that has been useful to me. I hope I have
enough info below... if more is required let me know.
mysqldump example
P:\mysqldump -u username -p mraentertainment mraentertainment.sql
--opt --verbose --max_allowed_packet=500M --hex-blob
--single_transaction --net_buffer_length=100M Enter password: **
-- Connecting to localhost...
-- Retrieving table structure for table albums...
-- Sending SELECT query...
...
-- Retrieving rows...
-- Retrieving table structure for table trackdata...
-- Sending SELECT query...
-- Retrieving rows...
mysqldump: Error 2013: Lost connection to MySQL server during query
when dumping table `trackdata` at row: 1
my.ini configuration file
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
log-bin=itd002-bin
server-id=1
port=3306
wait_timeout=86400
max_allowed_packet=100M
basedir=C:/Program Files/MySQL/MySQL Server 5.0/
datadir=C:/Program Files/MySQL/MySQL Server 5.0/Data/
default-character-set=latin1
default-storage-engine=INNODB
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=77M
thread_cache_size=8
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=154M
key_buffer_size=130M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#skip-innodb
innodb_additional_mem_pool_size=6M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=3M
innodb_buffer_pool_size=252M
innodb_log_file_size=126M
innodb_thread_concurrency=8
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
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 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
What's kind of the message you guys mentioned? - Original Message - From: LP [EMAIL PROTECTED] To: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:13 PM Subject: Re: SPAM ? 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' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:45 PM Subject: SPAM ? 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 a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, its the one below: -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 a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
I assume someone send the copy of the message. So that we get the duplications. Since we all reply to all the mail senders. - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: 'Banyan He' [EMAIL PROTECTED]; 'LP' [EMAIL PROTECTED]; 'MySQL List' mysql@lists.mysql.com 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 the one below: -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 a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 nuke the list. It is to be noticed that if you sort your inbox by date, the problem can remain undetected for a while as long as all the messages have the same date and time (look for messages from Jerry Schwartz [EMAIL PROTECTED] dated 22/03/2007 17:53); I received another 50 of them since my last post. As long as Jerry does not seem to receive the messages about the problem, if he cannot be contacted otherwise is there a way to block his messages or to unsubscribe this address until the problem is fixed? -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE : RE : SPAM ? SOLVED
Hi, For those who said they were experiencing the same problem than me, I think I found the solution. My mail client is currently configured to leave the messages on the server and it seems that the message causing the problem has something specific preventing my mail server and mail client to flag it as already sent, as a result it keeps being sent again and again to my client. Solution: delete the message on the server. -- Jaqcues Brignon -Message d'origine- De : Jacques Brignon [mailto:[EMAIL PROTECTED] Envoyé : dimanche 25 mars 2007 15:21 À : '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 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 nuke the list. It is to be noticed that if you sort your inbox by date, the problem can remain undetected for a while as long as all the messages have the same date and time (look for messages from Jerry Schwartz [EMAIL PROTECTED] dated 22/03/2007 17:53); I received another 50 of them since my last post. As long as Jerry does not seem to receive the messages about the problem, if he cannot be contacted otherwise is there a way to block his messages or to unsubscribe this address until the problem is fixed? -- Jacques Brignon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SPAM ?
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 a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with Spam on MySQL guest book
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 Apache PHP. If anybody has a way that I can add to my PHP code to filter out spam, please let me know. I do not know which of the many MySQL lists to send this to, so if this is not the correct list, I also apologize and ask you to please redirect me to the right list. Thanks, Gloria McMillan
Re: Problems with Spam on MySQL guest book
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 and am certain when I started these survey and guest book it was Apache PHP. If anybody has a way that I can add to my PHP code to filter out spam, please let me know. I do not know which of the many MySQL lists to send this to, so if this is not the correct list, I also apologize and ask you to please redirect me to the right list. well i think that you should ask in a php list but any way you could try a CAPTCHA http://www.roscripts.com/PHP_captcha_script,news,88,ID,news_details Thanks, Gloria McMillan -- http://www.obed.org.mx --- blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL: Spam Free (Send/Receive) Emails. HOW?
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)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. Thank you so much. Mel -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6221195 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--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 TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. Thanks Mel Michael Loftis wrote: --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 TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--On September 9, 2006 4:28:29 AM -0700 deafmickey [EMAIL PROTECTED] wrote: What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. *blinks* OK nevermind. You're not going to be capable of doing what you want to do. What you want to do requires control of the mail server, and an understanding of how they work. There are plenty of howto's and FAQs that cover all of this elsewhere though. MTA == Mail Transfer Agentyou might know it as an SMTP server. Thanks Mel Michael Loftis wrote: --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 TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW-- tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds. -- Samuel Butler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
**** Probably Spam (6.1) **** Slow performance - any suggestions?
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 PROTECTED] for details. Content preview: Hi, I'm seeing what to me appears to be very slow performance when inserting/ updating / deleting into a 15M row innodb table. I'm using mysql 5.0 on Solaris 10 with 8GB RAM. MySQL is compiled 32bit so has 4GB available. [...] Content analysis details: (6.1 points, 5.2 required) pts rule name description -- -- 0.1 FORGED_RCVD_HELO Received: contains a forged HELO 1.1 SPF_FAIL SPF: sender does not match SPF record (fail) [SPF failed: Please see http://www.openspf.org/why.html?sender=mysqllists%40albanach.comip=65.40.219.158receiver=localhost] 0.9 J_CHICKENPOX_44BODY: 4alpha-pock-4alpha 0.1 TW_HK BODY: Odd Letter Triples with HK -0.2 BAYES_40 BODY: Bayesian spam probability is 20 to 40% [score: 0.2484] 2.0 RCVD_IN_SORBS_DUL RBL: SORBS: sent directly from dynamic IP address [65.40.219.158 listed in dnsbl.sorbs.net] 1.9 RCVD_IN_NJABL_DUL RBL: NJABL: dialup sender did non-local SMTP [65.40.219.158 listed in combined.njabl.org] ---BeginMessage--- Hi, I'm seeing what to me appears to be very slow performance when inserting/ updating / deleting into a 15M row innodb table. I'm using mysql 5.0 on Solaris 10 with 8GB RAM. MySQL is compiled 32bit so has 4GB available. The table structure is as follows: f_id (int6) | v_id (int9) The primary key is an index on f_id and v_id There's also an index on v_id An insert of about 50,000 rows takes about 15 seconds which seems long - I'd have expected most of this to be happening in memory. A small sql script that reads and updates the table shows the following output when run with time from the command line: real0m53.457s user0m0.035s sys 0m0.038s Any suggestion why the real time is so much higher than user sys time? Below is the output from show innodb status and the innodb section from my.cnf As indicated in the my.cnf file below, My innodb data is all in its own partition loaded with forcedirectio Thanks for any suggestions! Russell = 060829 0:10:46 INNODB MONITOR OUTPUT = Per second averages calculated from the last 8 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 1534, signal count 1513 Mutex spin waits 212, rounds 20947, OS waits 101 RW-shared spins 22911, OS waits 529; RW-excl spins 47142, OS waits 904 TRANSACTIONS Trx id counter 0 74514 Purge done for trx's n:o 0 74512 undo n:o 0 0 History list length 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 11 MySQL thread id 3, query id 19 localhost root SHOW INNODB STATUS FILE I/O I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1220 OS file reads, 177 OS file writes, 89 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, is empty Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 7470761, used cells 371755, node heap has 375 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 3 1075228472 Log flushed up to 3 1075228472 Last checkpoint at 3 1075228472 0 pending log writes, 0 pending chkp writes 61 log i/o's done, 0.00 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 2109874514; in additional pool allocated 5845504 Buffer pool size 115200 Free buffers 112987 Database pages 1838 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1320, created 518, written 1206 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -- ROW OPERATIONS -- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 9, state: waiting for server activity Number of rows inserted 114100, updated 1, deleted
[Spam-Probable]MySQL 5.0.22 and show columns bug?
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 even. This is not only a bug, but extremely wasteful, as most client apps will therefore provide to allocate megs of ram for the potential data in this column to display even the simpliest of tables' column listing. Not only that, but many MySQL client apps will predetermine the correct manner of data display depending on the size of the data, i.e. use a normal text display vs a blob editor to display the subsequent information. I'm refering here to the st_mysql_field C API structure and specifically the 'length' member as defined in mysql.h. However, other columns seems fine with correct lengths, it just seems the person responsible for checking the result of the show columns into this structure has not done a very good job, as the column type text can not possibly take even 1KB of space, doesnt matter which charset you use, nevermind 192KB per column row displayed! Kind Regards SciBit MySQL Team http://www.scibit.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: *****SPAM***** Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same
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 advantages and disadvantages. Now my connections is 1509317 and my aborted clients is 1747365.Is it a problem?Please let me know. -Lakshmi.M.P. Brent Baisley wrote: You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default is 28800 I think), but is fine if you have a reason for setting it so low. Your threads_created number is fairly low, so you're not having a problem of constantly creating threads to handle connections, which can really hurt. I don't know what your front end is written in. But you may want to increase the wait_timeout or call mysql_close when you are done with your database connection. I'm guessing that since your aborted clients number is higher than the number of connections, you're using persistant connections. Which means connections are reused if still available. - Original Message - From: Lakshmi [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 3:42 AM Subject: Aborted clients status variable seems increasing -how to tune the server to reduce the same Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: {Spam?} Limiting results from joins
How about:
select * from products p
inner join manufactors m on p.manufactor_id=m.manufactor_id
inner join items i on p.product_id=i.product_id and i.item_updated=1
Donna
Kim Christensen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/12/2006 06:15 AM
Please respond to
[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 products can have more than one
entry in the items table, but I only want to fetch the one which
fullfills a certain criteria. In this case, I want the statement only
to JOIN the row if the column item_updated from the items table
equals 1.
Is this the proper way to solve this:
SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
= m.manufactor_id p.product_id = i.product_id i.item_id =
(SELECT item_id FROM items i2 WHERE i2.item_updated = 1);
I find the above solution VERY slow, almost as if I have missed out on
a very fundamental part of the logic - but it does get the work done.
How could I speed this up, or solve it in another statement?
Regards
--
Kim Christensen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
CONFIDENTIALITY NOTICE:This email is intended solely for the person or
entity to which it is addressed and may contain confidential and/or
protected health information. Any duplication, dissemination, action
taken in reliance upon, or other use of this information by persons or
entities other than the intended recipient is prohibited and may violate
applicable laws. If this email has been received in error, please notify
the sender and delete the information from your system. The views
expressed in this email are those of the sender and may not necessarily
represent the views of IntelliCare.
Re: [SPAM] Re: bug in simple select, what is going on?
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| +-++--+--+-+ | curious | 86851 |1 |0 | 2006-04-22 08:14:12 | +-++--+--+-+ 1 row in set, 1 warning (0.00 sec) 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| +-++--+--+-+ | curious | 86851 |1 |0 | 2006-04-22 08:14:12 | +-++--+--+-+ 1 row in set, 1 warning (0.00 sec) there are clear warnings, what are they ? mysql show warnings; +-+--+---+ | Level | Code | Message | +-+--+---+ | Warning | 1292 | Truncated incorrect DOUBLE value: 'm' | +-+--+---+ 1 row in set (0.00 sec) mysql -- my site a href=http://www.myowndictionary.com;myowndictionary/a was made to help students of many languages learn them faster. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] Re: describe table : improvement
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 PROTECTED] Subject: [SPAM] Re: describe table : improvement COLUMN COMMENTs are not the same as TABLE COMMENT... For TABLE COMMENT you should use: SHOW TABLE STATUS LIKE 'table_name' *Gilles *(the starter of the thread) wanted COLUMN COMMENTs. -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL: Unlimited Forums, Scalablity Issues, advice please? - Bayesian Filter detected spam
Let's try to characterize the load and sizing. If the posts are mostly text. 100 forums X 100,000 posts X 2,000 bytes per post = 20GB large but not huge We have people reading the posts. Even speed readers will take minutes to read the new posts. Maybe 1 in 10 - 100 readers will do a new post. A person writing a new post will take at least 5 minutes to type the 2000 bytes. So, while this site might have 100's to 1000's of concurrent users, the load profile on the database is much lower than a dynamic database driven web site where users are constantly searching/linking and the time spent on a specific page is seconds. I suspect if you watch some typical forum activity and build a crude database interaction model, you will find that even with 1000's of connected users the database server will need to run less than 100 relatively simple selects per second and many of them will be served by the query cache. This is a very rushed analysis with lots of assumptions, but if close then I think you are looking at at most a pair of dual dual-core 4GB systems running Master Slave replication. -Original Message- From: J. Pow [mailto:[EMAIL PROTECTED] 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 would only solve the problem of handling many many concurrent read accesses, by distributing the load across all slaves. However, I guess the real problem, is that the writes would still need to be performed across ALL databases, and the DB would be HUGE, would it not? Lets say I host 100 forums, with 100k posts each, every write would need to be replicated to as many slaves as I have. Thanks! Jay Philip Hallstrom wrote: Hi there, I am in the midst of creating a forums hosting site. 1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of subforums that simulate full forums would do. 2. Also regarding scalablity, I hope to Add capacity as and when its needed. So i'll have one server running initially, and when it gets too crowded, i'll get two servers etc. 3. I will be providing a user with a dashboard that allows him to view all his subscribed posts across ALL forums. So lets say a user is a member of 25 forums, this dashboard view will allow the user to view all his posts across all the forums. Does anyone have advice that could point me in the right direction? I have solved the scalability issue WITHIN a forum (code can handle million + posts easy), but I havent solved the issue of scaling MULTIPLE separate forums. What about having a single write master with many read-only slaves? Then modify your code so that posts go to the master and everything else happens on the slaves? Also, does there exist any php package that helps ease the process of deciding which Server/database to connect to? For example, someone accesses FORUM A, so the script would automatically know to direct all queries to the DB in SERVER 1 etc, and if i try to access FORUM J, it would connect to SERVER 2 etc. I could easily hard code this, but I was thinking what if internal IP addresses change, or I decide to migrate a busy forum to a server of its own etc, so perhaps there is a better available packaged solution designed for this task. Create a table on a central server that contains this mapping. This server could also hold the login tables as well... Just a thought. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Inner join with left join - Bayesian Filter detected spam
If you want to see all of the products {even those that have never been
ordered} then you need to SELECT ... FROM products ... LEFT JOIN orders
I think you also have to do a LEFT JOIN on order_items
And pull prod_name from products {don't know what the column name in
products is}.
SELECT o.id, oi.prod_name, sum(oi.quantity) as qty
FROM products as p
LEFT JOIN order_items as oi
ON (p.id = oi.product_id)
LEFT JOIN orders as o
ON (o.id = oi.order_id)
WHERE o.status NOT IN ('cancelled', 'pending', 'ghost')
AND
(o.created BETWEEN 2005-01-01 00:00: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 this what you mean?
SELECT
p.prod_name,
count(oi.product_id) AS mycount
FROM ORDERS AS o
INNER JOIN products ON o.id=p.id
LEFT JOIN order_items AS oi ON (p.id = oi.product_id)
WHERE o.status NOT IN ('cancelled', 'pending', 'ghost')
GROUP BY oi.product_id
ORDER BY mycount;
Well, sort of, here is what I managed to coble together, which gets me
pretty close, it is just what I want, other than it is missing products
with
a zero count. This tells me those products have not been ordered ever,
but
I would like to know what they are.
SELECT o.id, oi.prod_name, sum(oi.quantity) as qty
FROM orders as o
INNER JOIN order_items as oi
ON (o.id = oi.order_id)
LEFT JOIN products as p
ON (p.id = oi.product_id)
WHERE o.status NOT IN ('cancelled', 'pending', 'ghost')
AND
(o.created BETWEEN 2005-01-01 00:00:00 AND 2006-02-22 23:59:59)
GROUP BY oi.product_id
ORDER by qty ASC
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trans.: RE: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a result set - Bayesian Filter detected spam
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: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a result set - Bayesian Filter detected spam À : Gordon Bruce [EMAIL PROTECTED] Thanks. That looks OK from the point of view of generating the row number. But when this is done if my result set is tens of thousands row long, how do I find the row number of the record satisfying a conditon (like name = something) without storing the result of the query in a temp table and query that table to find the row and its number? -- Jacques Brignon Selon Gordon Bruce [EMAIL PROTECTED]: You can use a user variable [EMAIL PROTECTED] in the sample below} to number the rows in the result set. mysql set @row:=0; Query OK, 0 rows affected (0.00 sec) mysql select @row:[EMAIL PROTECTED], city_Name from citiesw limit 10; +--+-+ | @row:[EMAIL PROTECTED] | city_Name | +--+-+ |1 | !fajji !fasan | |2 | 'aadeissa | |3 | 'abas | |4 | 'abas | |5 | 'abasabad | |6 | 'abd al qader | |7 | 'abdullah kalay | |8 | 'abdullah kalay | |9 | 'abruyeh| | 10 | 'adel bagrou| +--+-+ 10 rows in set (0.00 sec) -Original Message- From: Jacques Brignon [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] - Date : Mon, 30 Jan 2006 16:16:53 +0100 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: Finding the row number satisfying a conditon in a result set À : Jake Peavy [EMAIL PROTECTED] Selon Jake Peavy [EMAIL PROTECTED]: On 1/30/06, Jacques Brignon [EMAIL PROTECTED] wrote: I would like some advice on the various and best ways of finding the rank of the row which satisfies a given condition in a rsult set. Let's assume that the result set includes a field containing an identifier from one of the table used in the query and that not two rows have the same value for this identifier but that the result set does not contains all the sequential values for this identifier and/or the values are not sorted in any predictable order. The brute force method is to loop through all the rows of the result set, until the number is found to get the rank of the row. That does not seem very clever and it can be very time consuming if the set has a lot of rows. use ORDER BY with a LIMIT of 1 your subject line needs work though - a row number has no meaning in a relational database. -jp Thanks for the tip, I am going to think to it as I do not see right away how this solves the problem. I agree with your comment, This is precisely because the result row number is not in the database that I need to find it. The problem I am trying to solve is the following: A query returns a result set with a number of rows, lets say 15000 as an example. I have an application wich displays those 10 by 10 with arrows based navigation capabilities (first page, previous page, next page, last page). I also have a search capability and I need to find in which set of 10 results the row I search for will be diplayed in order to show directly the appropriate page and to know what is the rank of this row in the result set or in the page to show the searched result row selected. As an example the row having a customer id of 125, would have the row # 563 in the result set (not orderd by customer id but by some other criterion like name) and would therefore be displayed in the page showing result rows 561 to 570 When I say row I do not mean a row in any table but a row in the result set produced by the query which can touch several tables. None of the fields of the result set contains the row number, it is just the number of time I have to loop through the result set to get the row in the set which matches my criterion. I hope this makes my question clearer. I am sure this is a pretty common problem, but I have not yet figured out the clever way to tackle it! -- Jacques Brignon - Fin du message transféré - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] - Fin du message
RE: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a result set - Bayesian Filter detected spam
You can use a user variable [EMAIL PROTECTED] in the sample below} to number the rows in the result set. mysql set @row:=0; Query OK, 0 rows affected (0.00 sec) mysql select @row:[EMAIL PROTECTED], city_Name from citiesw limit 10; +--+-+ | @row:[EMAIL PROTECTED] | city_Name | +--+-+ |1 | !fajji !fasan | |2 | 'aadeissa | |3 | 'abas | |4 | 'abas | |5 | 'abasabad | |6 | 'abd al qader | |7 | 'abdullah kalay | |8 | 'abdullah kalay | |9 | 'abruyeh| | 10 | 'adel bagrou| +--+-+ 10 rows in set (0.00 sec) -Original Message- From: Jacques Brignon [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] - Date : Mon, 30 Jan 2006 16:16:53 +0100 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: Finding the row number satisfying a conditon in a result set À : Jake Peavy [EMAIL PROTECTED] Selon Jake Peavy [EMAIL PROTECTED]: On 1/30/06, Jacques Brignon [EMAIL PROTECTED] wrote: I would like some advice on the various and best ways of finding the rank of the row which satisfies a given condition in a rsult set. Let's assume that the result set includes a field containing an identifier from one of the table used in the query and that not two rows have the same value for this identifier but that the result set does not contains all the sequential values for this identifier and/or the values are not sorted in any predictable order. The brute force method is to loop through all the rows of the result set, until the number is found to get the rank of the row. That does not seem very clever and it can be very time consuming if the set has a lot of rows. use ORDER BY with a LIMIT of 1 your subject line needs work though - a row number has no meaning in a relational database. -jp Thanks for the tip, I am going to think to it as I do not see right away how this solves the problem. I agree with your comment, This is precisely because the result row number is not in the database that I need to find it. The problem I am trying to solve is the following: A query returns a result set with a number of rows, lets say 15000 as an example. I have an application wich displays those 10 by 10 with arrows based navigation capabilities (first page, previous page, next page, last page). I also have a search capability and I need to find in which set of 10 results the row I search for will be diplayed in order to show directly the appropriate page and to know what is the rank of this row in the result set or in the page to show the searched result row selected. As an example the row having a customer id of 125, would have the row # 563 in the result set (not orderd by customer id but by some other criterion like name) and would therefore be displayed in the page showing result rows 561 to 570 When I say row I do not mean a row in any table but a row in the result set produced by the query which can touch several tables. None of the fields of the result set contains the row number, it is just the number of time I have to loop through the result set to get the row in the set which matches my criterion. I hope this makes my question clearer. I am sure this is a pretty common problem, but I have not yet figured out the clever way to tackle it! -- Jacques Brignon - Fin du message transféré - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - convert help - Bayesian Filter detected spam
I just added a user variable @fdata to get visabilility outside of the procedure and this is what I get. mysql delimiter // mysql create procedure test20 () -BEGIN - DECLARE fdata BLOB; - DECLARE foffset INT UNSIGNED; - DECLARE flength INT UNSIGNED; - DECLARE tmp_int BIGINT UNSIGNED; - - SELECT 0xABCDEF0123456789 INTO fdata; - SELECT 14 INTO foffset; - SELECT 7 INTO flength; - - SELECT SUBSTR(BINARY(fdata), - FLOOR(foffset/8)+1, - CEIL((flength + (foffset %8 ))%8)) - INTO fdata; - set @fdata:=fdata; - END// Query OK, 0 rows affected (0.00 sec) mysql mysql delimiter ; mysql mysql call test20(); Query OK, 0 rows affected (0.00 sec) mysql mysql select @fdata, hex(@fdata) - - ; ++-+ | @fdata | hex(@fdata) | ++-+ | ═∩☺#E | CDEF012345 | ++-+ 1 row in set (0.00 sec) -Original Message- From: 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. I noticed that if I have binary data and I: select data1; I get 0 (not what I'm expecting). Here is a test procedure I wrote: create procedure test20 () BEGIN DECLARE fdata BLOB; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE tmp_int BIGINT UNSIGNED; SELECT 0xABCDEF0123456789 INTO fdata; SELECT 14 INTO foffset; SELECT 7 INTO flength; SELECT SUBSTR(BINARY(fdata), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))%8)) INTO fdata; SELECT HEX(fdata); SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); END The last two selects are added to show what I would like to do, but have not been able to get it to work. Any help would be great. Thanks in advance. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - convert help - Bayesian Filter detected spam
Gordon, ... SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); ... Are you looking for... SELECT CAST(0xABCDEF0123456789 AS UNSIGNED); +--+ | CAST(0xABCDEF0123456789 AS UNSIGNED) | +--+ | 12379813738877118345 | +--+ SELECT HEX(12379813738877118345); +---+ | HEX(12379813738877118345) | +---+ | ABCDEF0123456789 | +---+ PB - Gordon Bruce wrote: I just added a user variable @fdata to get visabilility outside of the procedure and this is what I get. mysql delimiter // mysql create procedure test20 () -BEGIN - DECLARE fdata BLOB; - DECLARE foffset INT UNSIGNED; - DECLARE flength INT UNSIGNED; - DECLARE tmp_int BIGINT UNSIGNED; - - SELECT 0xABCDEF0123456789 INTO fdata; - SELECT 14 INTO foffset; - SELECT 7 INTO flength; - - SELECT SUBSTR(BINARY(fdata), - FLOOR(foffset/8)+1, - CEIL((flength + (foffset %8 ))%8)) - INTO fdata; - set @fdata:=fdata; - END// Query OK, 0 rows affected (0.00 sec) mysql mysql delimiter ; mysql mysql call test20(); Query OK, 0 rows affected (0.00 sec) mysql mysql select @fdata, hex(@fdata) - - ; ++-+ | @fdata | hex(@fdata) | ++-+ | ═∩☺#E | CDEF012345 | ++-+ 1 row in set (0.00 sec) -Original Message- From: 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. I noticed that if I have binary data and I: select data1; I get 0 (not what I'm expecting). Here is a test procedure I wrote: create procedure test20 () BEGIN DECLARE fdata BLOB; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE tmp_int BIGINT UNSIGNED; SELECT 0xABCDEF0123456789 INTO fdata; SELECT 14 INTO foffset; SELECT 7 INTO flength; SELECT SUBSTR(BINARY(fdata), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))%8)) INTO fdata; SELECT HEX(fdata); SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); END The last two selects are added to show what I would like to do, but have not been able to get it to work. Any help would be great. Thanks in advance. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - convert help - Bayesian Filter detected spam
I forgot to do reply all, sorry peter for the duplicate: Thank you for the responses to my question, however with a little poking around after the suggestions, I still am unable to do the conversion. mysql select 0xABCDEF0123456789 into @fdata; Query OK, 1 row affected (0.00 sec) mysql select hex(@fdata); +--+ | hex(@fdata) | +--+ | ABCDEF0123456789 | +--+ 1 row in set (0.00 sec) mysql select cast(@fdata AS UNSIGNED); +--+ | cast(@fdata AS UNSIGNED) | +--+ |0 | +--+ 1 row in set, 1 warning (0.00 sec) mysql Essentially what I am trying to accomplish is I have a BLOB column that can have arbitrarily large data, and I am using SUBSTR to pull out sections of it, and some of it needs to be masked and bit shifted. I can pull out the data I'm interested in, however to do the masking and bit shifting it appears I need it to be an integer of some kind. So I am taking blob data and trying to convert it to an integer type (unsigned) so I can do those bitwise operations. So I am putting the data into a variable like: SELECT SUBSTR(BINARY(blob_col),offset,length)) into fdata; //example This works fine. I can view this data. The problem I am having is I can't convert it to UNSIGNED to do some further bitwise operations on the data. Thanks for any further help. Gordon, ... SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); ... Are you looking for... SELECT CAST(0xABCDEF0123456789 AS UNSIGNED); +--+ | CAST(0xABCDEF0123456789 AS UNSIGNED) | +--+ | 12379813738877118345 | +--+ SELECT HEX(12379813738877118345); +---+ | HEX(12379813738877118345) | +---+ | ABCDEF0123456789 | +---+ PB - Gordon Bruce wrote: I just added a user variable @fdata to get visabilility outside of the procedure and this is what I get. mysql delimiter // mysql create procedure test20 () -BEGIN - DECLARE fdata BLOB; - DECLARE foffset INT UNSIGNED; - DECLARE flength INT UNSIGNED; - DECLARE tmp_int BIGINT UNSIGNED; - - SELECT 0xABCDEF0123456789 INTO fdata; - SELECT 14 INTO foffset; - SELECT 7 INTO flength; - - SELECT SUBSTR(BINARY(fdata), - FLOOR(foffset/8)+1, - CEIL((flength + (foffset %8 ))%8)) - INTO fdata; - set @fdata:=fdata; - END// Query OK, 0 rows affected (0.00 sec) mysql mysql delimiter ; mysql mysql call test20(); Query OK, 0 rows affected (0.00 sec) mysql mysql select @fdata, hex(@fdata) - - ; ++-+ | @fdata | hex(@fdata) | ++-+ | ââ©âº#E | CDEF012345 | ++-+ 1 row in set (0.00 sec) -Original Message- From: 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. I noticed that if I have binary data and I: select data1; I get 0 (not what I'm expecting). Here is a test procedure I wrote: create procedure test20 () BEGIN DECLARE fdata BLOB; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE tmp_int BIGINT UNSIGNED; SELECT 0xABCDEF0123456789 INTO fdata; SELECT 14 INTO foffset; SELECT 7 INTO flength; SELECT SUBSTR(BINARY(fdata), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))%8)) INTO fdata; SELECT HEX(fdata); SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SELECT HEX(tmp_int); END The last two selects are added to show what I would like to do, but have not been able to get it to work. Any help would be great. Thanks in advance. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006
RE: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in subject
One huge problem with this approach. The new table doesn't have any of the indexes that were present in the previous table. You may be better off to build a script that renames the current tables followed with the full CREATE TABLE statement(s). Do a SHOW CREATE TABLE current table; Then take that output and put it in a script RENAME TABLE current_table TO new_table_name; CREATE TABLE . ON 5.0 you can use PREPARED STATEMENTS if you want to control the new table names. See 13.7. SQL Syntax for Prepared Statements Beginning with MySQL 4.1.3, an alternative interface to prepared statements is available: SQL syntax for prepared statements. This interface is not as efficient as using the binary protocol through a prepared statement API, but requires no programming because it is available directly at the SQL level: -Original Message- From: Pooly [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 tables every week. Is there an easy way with SQL to create a new table based on the schema of an existing table? I believe CREATE TABLE newtbl SELECT blah... is what you're after : http://dev.mysql.com/doc/refman/5.0/en/create-table.html FTFM : You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl SELECT * FROM orig_tbl; -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Adding data from one table to another - Bayesian Filter detected spam
You probably want a multi table update assuming you are running at least 4.0.x. Add the column(s) to A with an ALTER TABLE UPDATE A INNER JOIN B ON (... SETA.col_name = B.col_name, A.col_name_2 = B.col WHERE .. You can copy the join structure from the 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 from one table to another - Bayesian Filter detected spam I have two tables with data on people in them. Table A is a subset of table B, However, there is data about these people in table B that is not in table A. with a simple select I can do a join and get a result set with all the data I need to show, but what I would like to do is change table A so it also has one of the fields from table B. Adding the field to table A is trivial , but how do I then populate that new field with data from the table B? -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam
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 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,2),3,1) AS `5`,
MID(CONV(HEX(245),16,2),4,1) AS `4`,
MID(CONV(HEX(245),16,2),5,1) AS `3`,
MID(CONV(HEX(245),16,2),6,1) AS `2`,
MID(CONV(HEX(245),16,2),7,1) AS `1`,
MID(CONV(HEX(245),16,2),8,1) AS `0` ;
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
Hope this helps.
Gordon Bruce wrote:
If by Decimal you mesn HEXIDECIMAL you can use CONV
where the 1st arg is the HEX value,
2nd arg is From Base
and 3rd arg is To Base.
You will have to suround the aliases with `'s if you really want
the names to be numeric.
mysql select MID(CONV('A5',16,2),1,1) AS `7`,
-MID(CONV('A5',16,2),2,1) AS `6`,
-MID(CONV('A5',16,2),3,1) AS `5`,
-MID(CONV('A5',16,2),4,1) AS `4`,
-MID(CONV('A5',16,2),5,1) AS `3`,
-MID(CONV('A5',16,2),6,1) AS `2`,
-MID(CONV('A5',16,2),7,1) AS `1`,
-MID(CONV('A5',16,2),8,1) AS `0` ;
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to binary and have the result be returned as a separate field
for
each bit? For example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
- Thanks
--
Bill Dodson
Parkline, Inc. http://www.parkline.com
phone: 304-586-2113 x149
fax: 304-586-3842
email: [EMAIL PROTECTED]
Email Disclaimer
The information in any email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to the email
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any action or omission taken by you in reliance on it, is prohibited and
may be unlawful. If you have received an email message in error, please
notify the sender immediately by email, facsimile or telephone and
return and/or destroy the original message.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam
Thanks Gordon and Bill but this has one big problem
If my decimal number is 8 the result ends up,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 0 | 0 | | | | |
+---+---+---+---+---+---+---+---+
when what i really need is,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
+---+---+---+---+---+---+---+---+
Any thoughts?
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 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 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,2),3,1) AS `5`,
MID(CONV(HEX(245),16,2),4,1) AS `4`,
MID(CONV(HEX(245),16,2),5,1) AS `3`,
MID(CONV(HEX(245),16,2),6,1) AS `2`,
MID(CONV(HEX(245),16,2),7,1) AS `1`,
MID(CONV(HEX(245),16,2),8,1) AS `0` ;
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
Hope this helps.
Gordon Bruce wrote:
If by Decimal you mesn HEXIDECIMAL you can use CONV
where the 1st arg is the HEX value,
2nd arg is From Base
and 3rd arg is To Base.
You will have to suround the aliases with `'s if you really want
the names to be numeric.
mysql select MID(CONV('A5',16,2),1,1) AS `7`,
- MID(CONV('A5',16,2),2,1) AS `6`,
- MID(CONV('A5',16,2),3,1) AS `5`,
- MID(CONV('A5',16,2),4,1) AS `4`,
- MID(CONV('A5',16,2),5,1) AS `3`,
- MID(CONV('A5',16,2),6,1) AS `2`,
- MID(CONV('A5',16,2),7,1) AS `1`,
- MID(CONV('A5',16,2),8,1) AS `0` ;
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to binary and have the result be returned as a separate field
for
each bit? For example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
- Thanks
--
Bill Dodson
Parkline, Inc. http://www.parkline.com
phone: 304-586-2113 x149
fax: 304-586-3842
email: [EMAIL PROTECTED]
Email Disclaimer
The information in any email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to the email
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any action or omission taken by you in reliance on it, is prohibited and
may be unlawful. If you have received an email message in error, please
notify the sender immediately by email, facsimile or telephone and
return and/or destroy the original message.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam
Well I solved the problem by using LPAD but it would be nice if there was a
more elegant way of handling this problem.
Thanks for the help.
Ed Reed [EMAIL PROTECTED] 1/10/06 2:52 PM
Thanks Gordon and Bill but this has one big problem
If my decimal number is 8 the result ends up,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 0 | 0 | | | | |
+---+---+---+---+---+---+---+---+
when what i really need is,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
+---+---+---+---+---+---+---+---+
Any thoughts?
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 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 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,2),3,1) AS `5`,
MID(CONV(HEX(245),16,2),4,1) AS `4`,
MID(CONV(HEX(245),16,2),5,1) AS `3`,
MID(CONV(HEX(245),16,2),6,1) AS `2`,
MID(CONV(HEX(245),16,2),7,1) AS `1`,
MID(CONV(HEX(245),16,2),8,1) AS `0` ;
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
Hope this helps.
Gordon Bruce wrote:
If by Decimal you mesn HEXIDECIMAL you can use CONV
where the 1st arg is the HEX value,
2nd arg is From Base
and 3rd arg is To Base.
You will have to suround the aliases with `'s if you really want
the names to be numeric.
mysql select MID(CONV('A5',16,2),1,1) AS `7`,
- MID(CONV('A5',16,2),2,1) AS `6`,
- MID(CONV('A5',16,2),3,1) AS `5`,
- MID(CONV('A5',16,2),4,1) AS `4`,
- MID(CONV('A5',16,2),5,1) AS `3`,
- MID(CONV('A5',16,2),6,1) AS `2`,
- MID(CONV('A5',16,2),7,1) AS `1`,
- MID(CONV('A5',16,2),8,1) AS `0` ;
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to binary and have the result be returned as a separate field
for
each bit? For example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
- Thanks
--
Bill Dodson
Parkline, Inc. http://www.parkline.com
phone: 304-586-2113 x149
fax: 304-586-3842
email: [EMAIL PROTECTED]
Email Disclaimer
The information in any email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to the email
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any action or omission taken by you in reliance on it, is prohibited and
may be unlawful. If you have received an email message in error, please
notify the sender immediately by email, facsimile or telephone and
return and/or destroy the original message.
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam
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`
;
Ed Reed wrote:
Well I solved the problem by using LPAD but it would be nice if there was a
more elegant way of handling this problem.
Thanks for the help.
Ed Reed [EMAIL PROTECTED] 1/10/06 2:52 PM
Thanks Gordon and Bill but this has one big problem
If my decimal number is 8 the result ends up,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 0 | 0 | | | | |
+---+---+---+---+---+---+---+---+
when what i really need is,
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
+---+---+---+---+---+---+---+---+
Any thoughts?
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 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 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,2),3,1) AS `5`,
MID(CONV(HEX(245),16,2),4,1) AS `4`,
MID(CONV(HEX(245),16,2),5,1) AS `3`,
MID(CONV(HEX(245),16,2),6,1) AS `2`,
MID(CONV(HEX(245),16,2),7,1) AS `1`,
MID(CONV(HEX(245),16,2),8,1) AS `0` ;
Results:
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
Hope this helps.
Gordon Bruce wrote:
If by Decimal you mesn HEXIDECIMAL you can use CONV
where the 1st arg is the HEX value,
2nd arg is From Base
and 3rd arg is To Base.
You will have to suround the aliases with `'s if you really want
the names to be numeric.
mysql select MID(CONV('A5',16,2),1,1) AS `7`,
- MID(CONV('A5',16,2),2,1) AS `6`,
- MID(CONV('A5',16,2),3,1) AS `5`,
- MID(CONV('A5',16,2),4,1) AS `4`,
- MID(CONV('A5',16,2),5,1) AS `3`,
- MID(CONV('A5',16,2),6,1) AS `2`,
- MID(CONV('A5',16,2),7,1) AS `1`,
- MID(CONV('A5',16,2),8,1) AS `0` ;
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to binary and have the result be returned as a separate field
for
each bit? For example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
+---+---+---+---+---+---+---+---+
- Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam
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 looks better: select (8 1) AS `0` , (8 1 1) AS `1` , (8 2 1) AS `2` , (8 3 1) AS `3` , (8 4 1) AS `4` , (8 5 1) AS `5` , (8 6 1) AS `6` , (8 7 1) AS `7` ; http://dev.mysql.com/doc/refman/4.1/en/bit-functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - concat string and update question - Found word(s) remove list in the Text body
Try this UPDATE people SETphone = CASE WHEN LEFT(phone,4) = '405_' THEN MID(phone,5,20) WHEN LEFT(phone,3) = '405' THEN MID(phone,4,20) ELSE phone END FROM people WHERE LEFT(phone,3) = '405' AND LENGTH(phone) 7; This way you don't accidentally replace '405' contained in the rest of the phone number. Also, if the phone numbers contain punctuation you will need to change the '7' in the LENGTH criteria. You will have to replace 'people' 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 Text body I have a table of people and their phone numbers, some have the area code and others do not. Everyone in this table lives in the same area code, so I would like to remove the area code from the phone number field. Basically replace '(405)' or '405-' with '' is there an easy way to do that in a query with out writing code? I know how to do it with code but would like an easier way if some one knows the SQL better than I do. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: SQL Question - Bayesian Filter detected spam
Why not just use the ABS Function update ev98nv_tm set mome=ABS(b) where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; 12.4.2. Mathematical Functions All mathematical functions return NULL in the event of an error. ABS(X) Returns the absolute value of X. 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: SQL Question - Bayesian Filter detected spam - Original Message - From: Mester József [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; mysql mysql@lists.mysql.com Sent: Friday, January 06, 2006 12:07 PM Subject: Re: SQL Question Hy If you know which values are supposed to be negative, wouldn't it be easier to do updates to your data to change all of those values to negatives? That should only need to be done once. Then use the normal SQL sum() function to add all of the values together. Thank you. Actually my first thing was update but my SQL knowledge is weak and I don't want to mess the database. I started a script which is update bad records on a copy of that database. However I didn't solve the update problem. My script is in (PL/SQL): integer a; integer b; varchar tr; varchar ra; varchar ke; varchar moti; begin select tm.tr,tm.ra,tm.ke,tm.moti,tm.mome into tr,ke,moti,a from ev98nv_tm tm where MOTI like 'Rakt.kozi-' or MOTI like 'Kiadas -' and tm.EV like '2005' if (a 0) then a=b; b = 0- b; update ev98nv_tm set mome=b where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; end; But it is not working. The Primary index is tr+ra+ke+moti Rhino I'm sorry but I've just got too much to do to help you today. Perhaps Gleb's suggestion can help you do the summing as you originally wanted or perhaps someone else can jump in with suggestions. Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date: 05/01/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: locating ibdata1 and *.ibd files in different directories. - Bayesian Filter detected spam
The following takes a little effort, but it should get you close to dump
file size.
On 5.0.x you can use Information_schema.columns to get average row
length for MyISAM tables. Take that plus the punctutation {~35 + 3* #
cols for insert per row if you enclose your columns in 's} in the
insert statements generated by mysqldump times the number of rows and
that will give you the size of the MyISAM tables.
For INNODB use
mysql select avg(length(concat( col1, col2,...))) AS Avg_Len, count(*)
- from table ;
+--+--+
| Avg_Len | count(*) |
+--+--+
| 107.5588 | 3514429 |
+--+--+
1 row in set (1 min 1.31 sec)
I would also use Information_schema.columns to get the column names so I
would not have to type them.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 20, 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 ibd files, ibdata1
file, either, or something else?
I've meant symbolic links for databases. See:
http://dev.mysql.com/doc/refman/5.0/en/symbolic-links.html
Is mysql smart enough not to use my indices when importing until after
the import, or should I de-activate my indices until after the import?
mysqldump from 5.0.17 distribution sets FOREIGN_KEY_CHECKS to 0; for
your version you can check this by yourself.
Also, is there a formula of what I can expect the size of the dumped
files to be?
For a pity, I don't know any formula, even approximate.
Nathan Gross wrote:
On 12/20/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Please, next time answer to the list as well.
Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First
time I noticed the 'reply to all' option in Gmail. Thanks.
As far as I know, you can't specify the location of ibd files,
they're s=
tored in the
database directory, however, you can use symbolic links for databases
to =
have
them in another place.
symbolic links! Thats a neat solution. Question: when you say
symbolic links for databases do you mean links to ibd files, ibdata1
file, either, or something else?
all databases? So the question is if I can locate the ibdata1 file
somew=
here else.
Have you tried just to change the value of innodb_home_dir to the new
location, and move there ibdata1 file?
And leave the original subdirs(databases) in the original place? I can
try. This means though, that the absolute db paths are coded into the
ibdata file.
ibd files. BUT, the ibdata1 file is still 7 gig and being
If you want do decrease the size of ibdata1 file, you should dump all
your InnoDB tables, stop the server, remove all existing tablespace
files, configure a new tablespace, restart the server, import the dump
files. In such a way you'll move all your tables which are in ibdata1
tablespace to may ibd files in databases. See:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
Is mysql smart enough not to use my indices when importing until after
the import, or should I de-activate my indices until after the import?
Also, is there a formula of what I can expect the size of the dumped
files to be?
Thank you much!
-nat
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 list? I don't see any. Maybe my spam filter is better than yours? What exactly are you asking anyway? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [OT] SPAM
Hi Stephen, Unfortunately this is not a moderated list. Basically anybody can join, send an email and then vanish. Nothing much to be done about it. I would however note, this is only about the third time in a couple of years listening that I've seen anything. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Stephen Cook [mailto:[EMAIL PROTECTED] Sent: Friday, 16 December 2005 11:05 AM To: Daniel Kasak Cc: mysql@lists.mysql.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 list? I don't see any. Maybe my spam filter is better than yours? What exactly are you asking anyway? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [OT] SPAM
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 fake the From to make simple filters think it did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[OT] SPAM
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]
Re: {Spam?} MySQL and dates puzzle
I think there are four cases to consider (hopefully the picture will
come through okay).
starttime|--|endtime The time span in consideration
*-* Case 1: ta has mtg that
starts before starttime, mtg ends between starttime and endtime 1
*--* Case 2: mtg starts before
starttime, mtg ends after endtime 2
*-* Case 3: mtg starts and mtg
ends between startime and endtime 3
*---*Case 4: mtg starts between
starttime and endtime, mtg ends after endtime 4
However the four can be reduced to two:
a. A meeting starts before the starttime and ends after the starttime
(cases 1 and 2)
or
b. A meeting starts between the starttime and the endtime (cases 3 and
4).
So to check if the TA is busy between 17:30 and 18:10
SELECT count(TAID) as total
FROM tbl_schedule
where TAID = 1
and ((starts '2005-10-27 17:30' and ends '2005-10-27 17:30')
or (starts = '2005-10-27 17:30' and starts '2005-10-27 18:10'))
Regards,
Donna
C.F. 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_schedule {
TAID integer,
starts datetime,
ends datetime }
A valid entry would be a TA whose id is 1 and between 17:00 and 18:00 he
is busy.
So:
1,'2005-10-27 17:00:00','2005-10-27 18:00:00'
Each ta can have more than one entry per day. He might be a busy TA and
have a lot
of meetings scheduled. The meetings do not have to be 1 hour length,
they can be 5 or 10 minutes.
So something like this would also be valid:
1,'2005-10-27 17:05:00','2005-10-27 17:10:00'
Now, I need to check, given a start and end dates, if that would overlap
with some record already present
in the database.
If I want to know if the TA is busy between 17:30 and 18:10 I could I
issue something like this:
SELECT count(TAID) as total FROM tbl_schedule where (TAID = 1) AND
(('2005-10-27 17:30' BETWEEN starts AND ends) OR ('2005-10-27 18:10'
BETWEEN starts AND ends))
It would return a number not zero as total if the dates are between the
registered database. However, this does not work properly.
Here's a case when it does not work:
Say I want to check between 14:00 and 20:00. The TA is busy from 17:00
and 18:00, hence if I try to schedule a meeting that will go
from 14:00 to 20:00 with the statement above it would return 0 as total.
This is not good because I need to know that given 14:00 to 20:00 that
would
not overlap with any previous engagement on the database. Since the TA
is busy from 17:00 to 18:00 I must know that I cannot schedule anything
like
that.
Can anyone help me on this issue? How can I check given a start and end
datetime that it does not overlap with what is in the database?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
CONFIDENTIALITY NOTICE:This email is intended solely for the person or
entity to which it is addressed and may contain confidential and/or
protected health information. Any duplication, dissemination, action
taken in reliance upon, or other use of this information by persons or
entities other than the intended recipient is prohibited and may violate
applicable laws. If this email has been received in error, please notify
the sender and delete the information from your system. The views
expressed in this email are those of the sender and may not necessarily
represent the views of IntelliCare.
RE: [SPAM] - Query help - Bayesian Filter detected spam
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 - Bayesian Filter detected spam
Hi, I have this query below, and I have been pulling my hair out for the
past couple of hours trying to get it to do what I want. As is, it
works, but I need it to consider other conditions. One of the columns
in the products table is called groupid. I need it to pull all products
with a groupid of 0 and only 1 product with a groupid 0 (doesn't
matter which one). Any help will save my sanity. ;)
SELECT products.*, MIN(pricing.price) as price , products_lng.product as
product_lng, products_lng.descr as descr_lng, products_lng.full_descr as
fulldescr_lng, IF(variants.variantid IS NOT NULL,'Y','') as is_variant,
IF(classes.classid IS NOT NULL,'Y','') as is_product_options,
MIN(v_pricing.price) as v_price, products_lng.product as product_lng,
products_lng.descr as descr_lng, products_lng.full_descr as
fulldescr_lng, IF(variants.variantid IS NOT NULL,'Y','') as is_variant,
IF(classes.classid IS NOT NULL,'Y','') as is_product_options,
MIN(v_pricing.price) as v_price FROM products, pricing ,
products_categories, categories LEFT JOIN products_lng ON
products_lng.productid = products.productid AND products_lng.code = 'US'
LEFT JOIN classes ON classes.productid = products.productid LEFT JOIN
variants ON variants.productid = products.productid LEFT JOIN pricing as
v_pricing ON v_pricing.variantid = variants.variantid AND
v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE
pricing.productid=products.productid AND pricing.quantity=1 AND
pricing.membership IN ('','') AND products.product_type 'C' AND
products.product_type 'B' AND (pricing.variantid = 0 OR
(variants.variantid = pricing.variantid AND variants.avail 0)) AND
products_categories.productid=products.productid AND
products_categories.categoryid = categories.categoryid AND
categories.membership IN ('','') AND
products_categories.categoryid='412' AND (products_categories.main='Y'
OR products_categories.main!='Y') AND products.forsale='Y' AND
(products.avail0 OR products.product_type NOT IN ('','N')) GROUP BY
products.productid ORDER BY products_categories.orderby ASC,
products.product ASC LIMIT 10, 10
--
John C. Nichel
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM?]: Case issue in Information_schema
Thx. That answered my question. karam --- Mark Leith [EMAIL PROTECTED] wrote: Hi Karam, I'm not sure what you mean by All the tables, columns and values are given in CAPS lock... Certainly, all of the INFORMATION_SCHEMA tables and their columns are defined in upper case. This probably won't change.. However, any values are stored in the case that they were created in. For example, if you created a table in test called foo, and were to SELECT table_name FROM 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 -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: 10 August 2005 15:26 To: mysql@lists.mysql.com Subject: [SPAM?]: Case issue in Information_schema Hello, I was just checking INFORMATION_SCHEMA in 5.0.10. All the tables, columns and values are given in CAPS lock. The case is not important in Windows but it is in Linux. Do I assume that even in Linux it will be in CAPS and the case is not going to change in near future? Karam -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/2005 __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql |
+---+
| columns_priv |
| db|
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic|
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name|
| time_zone_transition |
| time_zone_transition_type |
| user |
+---+
15 rows in set (0.00 sec)
mysql select host,user,password from mysql.user;
+---+--+---+
| host | user | password |
+---+--+---+
| localhost | root | *Exxx5D8x37183xxx5EBADF2A |
| localhost | yannick| |
| localhost | xxx| *Ex |
+---+--+---+
1 row in set (0.00 sec)
have you tried an update ?
mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass')
WHERE User='yannick' AND Host='localhost';
mysql FLUSH PRIVILEGES;
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
I would love to do it but this is the answer :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test');
ERROR 1133: Can't find any matching row in the user table
mysql
I also succeeded to enter with mysqladministrator. (Without password !)
The strange thing is that when I go to user admin he tells me: could not
retrieve user privilege info . It looks like there is not file for username
and passwords. If I try to add a user, the program shut.
Where should I check if there is such user file 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] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
It works only if I put NO password. If I put the password of yannick it
doesn't work. But here as well, I must confuse the username yannick in
mysql
and the user yannick in linux.
I can not ask the administrator what password he put because I am the
administrator of this computer !! :))
Also, I have just installed MysqlAdministrator and here as well, I can not
access the server... Same error messages.
How can I add set 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] - Unable to install mysql - Bayesian Filter detected
spam
Another thing :
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/home/yannick #
is normal:
try fujitsu:/home/yannick # mysql -u yannick -p
Mathias
Selon Mathias [EMAIL PROTECTED]:
Hi ,
You did a confusion between root for mysql (wihich is SA or DBA group)
and
the
root of the OS.
have you ever installed mysql in windows. there is a root user even in
windows.
What you must do is to ask the person who installed for the Mysql root
password and check the users created in the database. If the root
password
haven't been set, do it and flush privileges.
Selon Yannick [EMAIL PROTECTED]:
Nils,
Thanks for your support but still not working.
All I need is to have MYSQL installed with a root password.
For exemple, I can never login when I am a root user. I always need to
be a
user like yannick
I can also not make any request other the localhost as when I add -h
fujitsu, he makes re request on fujitsu.local.
How can I check the 4 databases to see what host has been used
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hey Mathias,
See the results below. I just have 1 database called test;
There is no user database.
mysql
mysql use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql select database
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
at line 1
mysql quir
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'quir' at line 1
mysql quit
Bye
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 163 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql use test
Database changed
mysql show tables;
Empty set (0.00 sec)
mysql select host,user,password from mysql.user;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql select host,user,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
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql |
+---+
| columns_priv |
| db|
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic|
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name|
| time_zone_transition |
| time_zone_transition_type |
| user |
+---+
15 rows in set (0.00 sec)
mysql select host,user,password from mysql.user;
+---+--+---+
| host | user | password |
+---+--+---+
| localhost | root | *Exxx5D8x37183xxx5EBADF2A |
| localhost | yannick| |
| localhost | xxx| *Ex |
+---+--+---+
1 row in set (0.00 sec)
have you tried an update ?
mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass')
WHERE User='yannick' AND Host='localhost';
mysql FLUSH PRIVILEGES;
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
I would love to do it but this is the answer :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test');
ERROR 1133: Can't find any matching row in the user table
mysql
I also succeeded to enter with mysqladministrator. (Without password !)
The strange thing is that when I go to user admin he tells me: could not
retrieve user privilege info . It looks like there is not file for
username
and passwords. If I try to add a user, the program shut.
Where should I check if there is such user file 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] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login
:
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
It works only if I put NO password. If I put the password of yannick it
doesn't work. But here as well, I must confuse the username yannick in
mysql
and the user yannick in linux.
I can not ask the administrator what password he put because I am the
administrator of this computer !! :))
Also, I have just installed MysqlAdministrator and here as well, I
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
You are not granted access to mysql.
So ask your root user to modify your password.
impossible else.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Hey Mathias,
See the results below. I just have 1 database called test;
There is no user database.
mysql
mysql use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql select database
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
at line 1
mysql quir
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'quir' at line 1
mysql quit
Bye
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 163 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql use test
Database changed
mysql show tables;
Empty set (0.00 sec)
mysql select host,user,password from mysql.user;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql select host,user,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
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql |
+---+
| columns_priv |
| db|
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic|
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name|
| time_zone_transition |
| time_zone_transition_type |
| user |
+---+
15 rows in set (0.00 sec)
mysql select host,user,password from mysql.user;
+---+--+---+
| host | user | password |
+---+--+---+
| localhost | root | *Exxx5D8x37183xxx5EBADF2A |
| localhost | yannick| |
| localhost | xxx| *Ex |
+---+--+---+
1 row in set (0.00 sec)
have you tried an update ?
mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass')
WHERE User='yannick' AND Host='localhost';
mysql FLUSH PRIVILEGES;
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
I would love to do it but this is the answer :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test');
ERROR 1133: Can't find any matching row in the user table
mysql
I also succeeded to enter with mysqladministrator. (Without password !)
The strange thing is that when I go to user admin he tells me: could not
retrieve user privilege info . It looks like there is not file for
username
and passwords. If I try to add a user, the program shut.
Where should I check if there is such user file 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] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login
:
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
It works only if I put NO password. If I put the password of yannick
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi,
I'm not sure you understand the issue. I have the root in linux but not in
mysql !
All I want is to install mysql on my linux suse 9.0. Of course, I have the
root access one the server !
As discussed below, I can not add any password on my sql.
All I want is to know how to do it ! I've followed the tutorial of the
installation and reinstalled it 3 times at least. However, I can never enter
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] - 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 other databases in /var/lib/mysql/mysql
I really can't see how an administrator haven't the administrator password
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
How can I do this ? I am the admin of this pc.
We've tested it before I think and it did not work. I still think it is
because there is no user file. Where can I found this file ? Where is it
on
the pc ?
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 10:38 AM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
You are not granted access to mysql.
So ask your root user to modify your password.
impossible else.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Hey Mathias,
See the results below. I just have 1 database called test;
There is no user database.
mysql
mysql use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql select database
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
''
at line 1
mysql quir
- ;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'quir' at line 1
mysql quit
Bye
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 163 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql use test
Database changed
mysql show tables;
Empty set (0.00 sec)
mysql select host,user,password from mysql.user;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql select host,user,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
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql |
+---+
| columns_priv |
| db|
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic|
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name|
| time_zone_transition |
| time_zone_transition_type |
| user |
+---+
15 rows in set (0.00 sec)
mysql select host,user,password from mysql.user;
+---+--+---+
| host | user | password |
+---+--+---+
| localhost | root | *Exxx5D8x37183xxx5EBADF2A |
| localhost | yannick| |
| localhost | xxx| *Ex |
+---+--+---+
1 row in set (0.00 sec)
have you tried an update ?
mysql UPDATE mysql.user SET Password=OLD_PASSWORD('newpass')
WHERE User='yannick' AND Host='localhost';
mysql FLUSH PRIVILEGES;
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
I would love to do it but this is the answer
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.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter 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] - 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 other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql quir - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec) mysql select host,user,password from mysql.user; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql select host,user,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 À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam Hi, you should have a list in the user table of mysql database : mysql use mysql Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 15 rows in set (0.00 sec) mysql select host,user,password from mysql.user; +---+--+---+ | host | user | password
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hey, Thanks for your help till so far but I'm still with my issue ! Is there any other support possible? FYI, I just reinstalled it with a higher version and the same issue is comming. I can not access mysql as root ! Please have a close look below : fujitsu:/home/yannick # mysql -u root--- # means I am as root on Linux. ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) fujitsu:/home/yannick # su yannick --- Here I move to a local user : yannick [EMAIL PROTECTED]:~ mysql -u root ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED]:~ --- Meaning I can not login with root --- The goal being to add a root password on mysql. as explained here : http://dev.mysql.com/doc/mysql/en/default-privileges.html However, [EMAIL PROTECTED]:~ mysql --- Now it works but with anonymous account. Low privilidges. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 4.1.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql This means that I just have an anonymous account. 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 : 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.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter 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] - 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 other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql quir - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables - ; ERROR 1046: No Database Selected mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql use test Database changed mysql show tables; Empty set (0.00 sec
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Try : fujitsu:/home/yannick # mysql -u root -p Then ENTER fujitsu:/home/yannick # mysql -u root -h localhost -P 3306 -p Then ENTER Mathias Selon Yannick [EMAIL PROTECTED]: Hey, Thanks for your help till so far but I'm still with my issue ! Is there any other support possible? FYI, I just reinstalled it with a higher version and the same issue is comming. I can not access mysql as root ! Please have a close look below : fujitsu:/home/yannick # mysql -u root--- # means I am as root on Linux. ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) fujitsu:/home/yannick # su yannick --- Here I move to a local user : yannick [EMAIL PROTECTED]:~ mysql -u root ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) [EMAIL PROTECTED]:~ --- Meaning I can not login with root --- The goal being to add a root password on mysql. as explained here : http://dev.mysql.com/doc/mysql/en/default-privileges.html However, [EMAIL PROTECTED]:~ mysql --- Now it works but with anonymous account. Low privilidges. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 4.1.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | test | +--+ 1 row in set (0.00 sec) mysql This means that I just have an anonymous account. 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 : 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.mysql.com/doc/mysql/en/unix-post-installation.html And all you want is here : http://www.mysql.com/search/?q=Installation If you're root, install mysql as root. At the end, change the mysql root password to a password different from the linux root. Then create other users and databases. Mathias Selon Yannick [EMAIL PROTECTED]: Hi, I'm not sure you understand the issue. I have the root in linux but not in mysql ! All I want is to install mysql on my linux suse 9.0. Of course, I have the root access one the server ! As discussed below, I can not add any password on my sql. All I want is to know how to do it ! I've followed the tutorial of the installation and reinstalled it 3 times at least. However, I can never enter 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] - 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 other databases in /var/lib/mysql/mysql I really can't see how an administrator haven't the administrator password Mathias Selon Yannick [EMAIL PROTECTED]: Mathias, How can I do this ? I am the admin of this pc. We've tested it before I think and it did not work. I still think it is because there is no user file. Where can I found this file ? Where is it on the pc ? Yannick -Message d'origine- De : Mathias [mailto:[EMAIL PROTECTED] Envoyé : Sunday, June 26, 2005 10:38 AM À : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam You are not granted access to mysql. So ask your root user to modify your password. impossible else. Mathias Selon Yannick [EMAIL PROTECTED]: Hey Mathias, See the results below. I just have 1 database called test; There is no user database. mysql mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql show tables - ; ERROR 1046: No Database Selected mysql select database - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql quir - ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'quir' at line 1 mysql quit Bye [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 163 to server version: 4.0.15-Max Type 'help;' or '\h
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Nils,
Thanks for your support but still not working.
All I need is to have MYSQL installed with a root password.
For exemple, I can never login when I am a root user. I always need to be a
user like yannick
I can also not make any request other the localhost as when I add -h
fujitsu, he makes re request on fujitsu.local.
How can I check the 4 databases to see what host has been used for which
username ?
If needed, I can also give you a telnet session to check what is going
wrong. I have already installed it 3 times and always the same result... I
don't beleive on an installation problem but on an authentification issue.
Thanks for you support.
Yannick
See details below:
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 111 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many tutorials
online which explain how to proberly setup user accounts.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
yannick
etc. are all separate users with different rights. So the combination of
username, hostname and password is to be thought of as a set.
have alook at below links, which I hope help you kichstart and troubleshoot
any issues you are having.
http://www.devshed.com/c/b/MySQL/
http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/
http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php
I hope that you find this info useful.
Best regards
Nils Valentin
Tokyo / Japan
http;//www.be-known-online.com
On Tuesday 14 June 2005 06:58, Yannick wrote:
Kevin,
In addition to that, the ZORUM database works because when I stop mysql,
the following site stops working :
http://www.wxy.nl/zorum_3_5/ with the database ZORUM
Here PHPadmin doesn't give me any privilege to create anything :
http://www.wxy.nl/phpMyAdmin/
I beleive I'm not to 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 mysql - Bayesian Filter detected
spam
Kevin,
Thanks for your answer. See below the results :
* I' really wondering if there is not any missing files.
* The mysql.soc file is complettly empty
* I can only access myssql when I am not in root.
* I can only see 1 database test when I know there is others like zorum
which is working
* The command Grant doesn't work.
The result is that I can never access any database.
I have been folowing the installatin process but it still does not work.
Do you mind to have a look at the details below and advice on which files
I
should have a look.
Thanks in advance.
Yannick
fujitsu:/etc # mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:/etc mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc su
Password:
fujitsu:/etc # mysql -u mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/etc # mysql -u yannick
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql -u yannick
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick');
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql SET PASSWORD FOR 'yannick' = PASSWORD('Yannick');
ERROR 1133: Can't find any matching row in the user table
mysql
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi , You did a confusion between root for mysql (wihich is SA or DBA group) and the root of the OS. have you ever installed mysql in windows. there is a root user even in windows. What you must do is to ask the person who installed for the Mysql root password and check the users created in the database. If the root password haven't been set, do it and flush privileges. Selon Yannick [EMAIL PROTECTED]: Nils, Thanks for your support but still not working. All I need is to have MYSQL installed with a root password. For exemple, I can never login when I am a root user. I always need to be a user like yannick I can also not make any request other the localhost as when I add -h fujitsu, he makes re request on fujitsu.local. How can I check the 4 databases to see what host has been used for which username ? If needed, I can also give you a telnet session to check what is going wrong. I have already installed it 3 times and always the same result... I don't beleive on an installation problem but on an authentification issue. Thanks for you support. Yannick See details below: [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 111 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many tutorials online which explain how to proberly setup user accounts. [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] yannick etc. are all separate users with different rights. So the combination of username, hostname and password is to be thought of as a set. have alook at below links, which I hope help you kichstart and troubleshoot any issues you are having. http://www.devshed.com/c/b/MySQL/ http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/ http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: Kevin, In addition to that, the ZORUM database works because when I stop mysql, the following site stops working : http://www.wxy.nl/zorum_3_5/ with the database ZORUM Here PHPadmin doesn't give me any privilege to create anything : http://www.wxy.nl/phpMyAdmin/ I beleive I'm not to 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 mysql - Bayesian Filter detected spam Kevin, Thanks for your answer. See below the results : * I' really wondering if there is not any missing files. * The mysql.soc file is complettly empty * I can only access myssql when I am not in root. * I can only see 1 database test when I know there is others like zorum which is working * The command Grant doesn't work. The result is that I can never access any database. I have been folowing the installatin process but it still does not work. Do you mind to have a look at the details below and advice on which files I should have a look. Thanks in advance. Yannick fujitsu:/etc # mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/etc # su mysql [EMAIL PROTECTED]:/etc mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye [EMAIL PROTECTED]:/etc mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED]:/etc mysql -u mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye [EMAIL PROTECTED]:/etc su Password: fujitsu:/etc # mysql -u mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/etc # mysql -u yannick ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/etc # su mysql [EMAIL PROTECTED]:/etc mysql -u yannick
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Another thing : fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/home/yannick # is normal: try fujitsu:/home/yannick # mysql -u yannick -p Mathias Selon Mathias [EMAIL PROTECTED]: Hi , You did a confusion between root for mysql (wihich is SA or DBA group) and the root of the OS. have you ever installed mysql in windows. there is a root user even in windows. What you must do is to ask the person who installed for the Mysql root password and check the users created in the database. If the root password haven't been set, do it and flush privileges. Selon Yannick [EMAIL PROTECTED]: Nils, Thanks for your support but still not working. All I need is to have MYSQL installed with a root password. For exemple, I can never login when I am a root user. I always need to be a user like yannick I can also not make any request other the localhost as when I add -h fujitsu, he makes re request on fujitsu.local. How can I check the 4 databases to see what host has been used for which username ? If needed, I can also give you a telnet session to check what is going wrong. I have already installed it 3 times and always the same result... I don't beleive on an installation problem but on an authentification issue. Thanks for you support. Yannick See details below: [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 111 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many tutorials online which explain how to proberly setup user accounts. [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] yannick etc. are all separate users with different rights. So the combination of username, hostname and password is to be thought of as a set. have alook at below links, which I hope help you kichstart and troubleshoot any issues you are having. http://www.devshed.com/c/b/MySQL/ http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/ http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: Kevin, In addition to that, the ZORUM database works because when I stop mysql, the following site stops working : http://www.wxy.nl/zorum_3_5/ with the database ZORUM Here PHPadmin doesn't give me any privilege to create anything : http://www.wxy.nl/phpMyAdmin/ I beleive I'm not to 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 mysql - Bayesian Filter detected spam Kevin, Thanks for your answer. See below the results : * I' really wondering if there is not any missing files. * The mysql.soc file is complettly empty * I can only access myssql when I am not in root. * I can only see 1 database test when I know there is others like zorum which is working * The command Grant doesn't work. The result is that I can never access any database. I have been folowing the installatin process but it still does not work. Do you mind to have a look at the details below and advice on which files I should have a look. Thanks in advance. Yannick fujitsu:/etc # mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/etc # su mysql [EMAIL PROTECTED]:/etc mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye [EMAIL PROTECTED]:/etc mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED]:/etc mysql -u mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 to server version: 4.0.15-Max Type 'help
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Mathias, Did what you asked : [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED]:~ mysql -u yannick -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 134 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works only if I put NO password. If I put the password of yannick it doesn't work. But here as well, I must confuse the username yannick in mysql and the user yannick in linux. I can not ask the administrator what password he put because I am the administrator of this computer !! :)) Also, I have just installed MysqlAdministrator and here as well, I can not access the server... Same error messages. How can I add set 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] - Unable to install mysql - Bayesian Filter detected spam Another thing : fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) fujitsu:/home/yannick # is normal: try fujitsu:/home/yannick # mysql -u yannick -p Mathias Selon Mathias [EMAIL PROTECTED]: Hi , You did a confusion between root for mysql (wihich is SA or DBA group) and the root of the OS. have you ever installed mysql in windows. there is a root user even in windows. What you must do is to ask the person who installed for the Mysql root password and check the users created in the database. If the root password haven't been set, do it and flush privileges. Selon Yannick [EMAIL PROTECTED]: Nils, Thanks for your support but still not working. All I need is to have MYSQL installed with a root password. For exemple, I can never login when I am a root user. I always need to be a user like yannick I can also not make any request other the localhost as when I add -h fujitsu, he makes re request on fujitsu.local. How can I check the 4 databases to see what host has been used for which username ? If needed, I can also give you a telnet session to check what is going wrong. I have already installed it 3 times and always the same result... I don't beleive on an installation problem but on an authentification issue. Thanks for you support. Yannick See details below: [EMAIL PROTECTED]:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 111 to server version: 4.0.15-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql fujitsu:/home/yannick # mysql ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many tutorials online which explain how to proberly setup user accounts. [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] yannick etc. are all separate users with different rights. So the combination of username, hostname and password is to be thought of as a set. have alook at below links, which I hope help you kichstart and troubleshoot any issues you are having. http://www.devshed.com/c/b/MySQL/ http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/ http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: Kevin, In addition to that, the ZORUM database works because when I stop mysql, the following site stops working : http://www.wxy.nl/zorum_3_5/ with the database ZORUM Here PHPadmin doesn't give me any privilege to create anything : http://www.wxy.nl/phpMyAdmin/ I beleive I'm not to 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 mysql - Bayesian Filter detected spam Kevin, Thanks for your answer. See below the results : * I' really wondering if there is not any missing files. * The mysql.soc
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Since you can connect as yannick without password, just set it after login :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
It works only if I put NO password. If I put the password of yannick it
doesn't work. But here as well, I must confuse the username yannick in mysql
and the user yannick in linux.
I can not ask the administrator what password he put because I am the
administrator of this computer !! :))
Also, I have just installed MysqlAdministrator and here as well, I can not
access the server... Same error messages.
How can I add set 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] - Unable to install mysql - Bayesian Filter detected
spam
Another thing :
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/home/yannick #
is normal:
try fujitsu:/home/yannick # mysql -u yannick -p
Mathias
Selon Mathias [EMAIL PROTECTED]:
Hi ,
You did a confusion between root for mysql (wihich is SA or DBA group) and
the
root of the OS.
have you ever installed mysql in windows. there is a root user even in
windows.
What you must do is to ask the person who installed for the Mysql root
password and check the users created in the database. If the root
password
haven't been set, do it and flush privileges.
Selon Yannick [EMAIL PROTECTED]:
Nils,
Thanks for your support but still not working.
All I need is to have MYSQL installed with a root password.
For exemple, I can never login when I am a root user. I always need to
be a
user like yannick
I can also not make any request other the localhost as when I add -h
fujitsu, he makes re request on fujitsu.local.
How can I check the 4 databases to see what host has been used for which
username ?
If needed, I can also give you a telnet session to check what is going
wrong. I have already installed it 3 times and always the same result...
I
don't beleive on an installation problem but on an authentification
issue.
Thanks for you support.
Yannick
See details below:
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 111 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many
tutorials
online which explain how to proberly setup user accounts.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
yannick
etc. are all separate users with different rights. So the combination of
username, hostname and password is to be thought of as a set.
have alook at below links, which I hope help you kichstart and
troubleshoot
any issues you are having.
http://www.devshed.com/c/b/MySQL/
http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/
http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php
I hope that you find this info useful.
Best regards
Nils Valentin
Tokyo / Japan
http;//www.be-known-online.com
On Tuesday 14 June 2005 06:58, Yannick wrote:
Kevin,
In addition to that, the ZORUM database works because when I stop
mysql,
the following site stops working :
http://www.wxy.nl/zorum_3_5/ with the database ZORUM
Here PHPadmin doesn't give me any privilege to create anything :
http://www.wxy.nl/phpMyAdmin/
I beleive I'm not to far from having it working ut
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Mathias,
I would love to do it but this is the answer :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('test');
ERROR 1133: Can't find any matching row in the user table
mysql
I also succeeded to enter with mysqladministrator. (Without password !)
The strange thing is that when I go to user admin he tells me: could not
retrieve user privilege info . It looks like there is not file for username
and passwords. If I try to add a user, the program shut.
Where should I check if there is such user file 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] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http://dev.mysql.com/doc/mysql/en/set-password.html for more details.
I advice to set it to another password than your yannick linux one.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Mathias,
Did what you asked :
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
[EMAIL PROTECTED]:~ mysql -u yannick -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 134 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
It works only if I put NO password. If I put the password of yannick it
doesn't work. But here as well, I must confuse the username yannick in
mysql
and the user yannick in linux.
I can not ask the administrator what password he put because I am the
administrator of this computer !! :))
Also, I have just installed MysqlAdministrator and here as well, I can not
access the server... Same error messages.
How can I add set 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] - Unable to install mysql - Bayesian Filter detected
spam
Another thing :
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/home/yannick #
is normal:
try fujitsu:/home/yannick # mysql -u yannick -p
Mathias
Selon Mathias [EMAIL PROTECTED]:
Hi ,
You did a confusion between root for mysql (wihich is SA or DBA group)
and
the
root of the OS.
have you ever installed mysql in windows. there is a root user even in
windows.
What you must do is to ask the person who installed for the Mysql root
password and check the users created in the database. If the root
password
haven't been set, do it and flush privileges.
Selon Yannick [EMAIL PROTECTED]:
Nils,
Thanks for your support but still not working.
All I need is to have MYSQL installed with a root password.
For exemple, I can never login when I am a root user. I always need to
be a
user like yannick
I can also not make any request other the localhost as when I add -h
fujitsu, he makes re request on fujitsu.local.
How can I check the 4 databases to see what host has been used for
which
username ?
If needed, I can also give you a telnet session to check what is going
wrong. I have already installed it 3 times and always the same
result...
I
don't beleive on an installation problem but on an authentification
issue.
Thanks for you support.
Yannick
See details below:
[EMAIL PROTECTED]:~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 111 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
fujitsu:/home/yannick # mysql
ERROR 1045: Access denied for user: '[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 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 found the problem yet, any way there are many
tutorials
online which explain how to proberly setup user accounts.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
yannick
etc. are all separate users with different rights. So the combination
of
username, hostname and password is to be thought of as a set.
have alook at below links, which I hope help
Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Hi yannick,
Not sure if you have found the problem yet, any way there are many tutorials
online which explain how to proberly setup user accounts.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
yannick
etc. are all separate users with different rights. So the combination of
username, hostname and password is to be thought of as a set.
have alook at below links, which I hope help you kichstart and troubleshoot
any issues you are having.
http://www.devshed.com/c/b/MySQL/
http://www.devshed.com/c/a/MySQL/The-MySQL-Grant-Tables/
http://www.php-mysql-tutorial.com/mysql-tutorial/add-new-mysql-user.php
I hope that you find this info useful.
Best regards
Nils Valentin
Tokyo / Japan
http;//www.be-known-online.com
On Tuesday 14 June 2005 06:58, Yannick wrote:
Kevin,
In addition to that, the ZORUM database works because when I stop mysql,
the following site stops working :
http://www.wxy.nl/zorum_3_5/ with the database ZORUM
Here PHPadmin doesn't give me any privilege to create anything :
http://www.wxy.nl/phpMyAdmin/
I beleive I'm not to 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 mysql - Bayesian Filter detected
spam
Kevin,
Thanks for your answer. See below the results :
* I' really wondering if there is not any missing files.
* The mysql.soc file is complettly empty
* I can only access myssql when I am not in root.
* I can only see 1 database test when I know there is others like zorum
which is working
* The command Grant doesn't work.
The result is that I can never access any database.
I have been folowing the installatin process but it still does not work.
Do you mind to have a look at the details below and advice on which files I
should have a look.
Thanks in advance.
Yannick
fujitsu:/etc # mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:/etc mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc su
Password:
fujitsu:/etc # mysql -u mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # mysql -u yannick
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql -u yannick
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick');
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql SET PASSWORD FOR 'yannick' = PASSWORD('Yannick');
ERROR 1133: Can't find any matching row in the user table
mysql
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql
mysql UPDATE mysql.user SET Password = PASSWORD('Yannick')
- ;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
fujitsu:/bin # mysqlshow
mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # mysql -e SELECT Host,Db,User FROM db mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # bin/mysqld_safe --user=mysql --log
bash: bin/mysqld_safe: Aucun fichier ou rpertoire de ce type
[1] 16599
[1] Exit 127bin/mysqld_safe --user=mysql --log
fujitsu:/bin # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
fujitsu:/bin #
mysql SHOW DATABASES;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql GRANT ALL ON menagerie.* TO 'mysql'@'localhost';
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
mysql GRANT ALL ON test TO '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 denied for user: '@localhost' to database 'test'
mysql
-Message d'origine-
De : Kevin
RE: [SPAM] - discuss: user management - Bayesian Filter detected spam
Danny, Although my experience with MySQL user management is limited to just maintaining a handful of users, I find it rather overly-complex because of the need to maintain a table of users and 'from where' they can have access, and to what databases they can have access to. For example, I just installed MySQL Administrator on my laptop and then I had to add rows allowing me to access MySQL from my laptop. The ODBC connection setup should suffice. For every instance of MySQL, you have to have an entry in the user table for every user from every access point. Then multiply that by the number of databases in each instance and you can see that administration of the users can get out of hand. If I had to choose between the 3 methods listed below, I would choose #2 if there was a large number of roles and users. I would definitely stay away from option #3 no matter what. HTH. 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 - Bayesian Filter detected spam hi, i would like to discuss 'user management' in mysql. Working with Oracle you can assign users to roles giving them privileges provided by that role. MySql doesn't have Roles. I have read (Managing and Using MySql, O'Reilly) 3 options on managing users having multiple roles in a MySql environment: 1. Giving the user a Single user ID and assign the privileges to that user ID 2. Create role-bases users and have different people share the same user ID for a given role. 3. Create multiple user IDs for each role played by each user (dannys_arch as an architect, dannys_dev as a developer). Which of these 3 options is the most preferable one or are there more options which you can use. What are the advantages and disadvantages on working with one of these 3 options? how do you handle hostnames when working with random ip-addresses on your site. Or just plain simple (or stupid) what are your experiences on user management in a MySql environment. Best regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Kevin,
Thanks for your answer. See below the results :
* I' really wondering if there is not any missing files.
* The mysql.soc file is complettly empty
* I can only access myssql when I am not in root.
* I can only see 1 database test when I know there is others like zorum
which is working
* The command Grant doesn't work.
The result is that I can never access any database.
I have been folowing the installatin process but it still does not work.
Do you mind to have a look at the details below and advice on which files I
should have a look.
Thanks in advance.
Yannick
fujitsu:/etc # mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:/etc mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc su
Password:
fujitsu:/etc # mysql -u mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # mysql -u yannick
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql -u yannick
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick');
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql SET PASSWORD FOR 'yannick' = PASSWORD('Yannick');
ERROR 1133: Can't find any matching row in the user table
mysql
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql
mysql UPDATE mysql.user SET Password = PASSWORD('Yannick')
- ;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
fujitsu:/bin # mysqlshow
mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # mysql -e SELECT Host,Db,User FROM db mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # bin/mysqld_safe --user=mysql --log
bash: bin/mysqld_safe: Aucun fichier ou répertoire de ce type
[1] 16599
[1] Exit 127bin/mysqld_safe --user=mysql --log
fujitsu:/bin # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
fujitsu:/bin #
mysql SHOW DATABASES;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql GRANT ALL ON menagerie.* TO 'mysql'@'localhost';
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
mysql GRANT ALL ON test TO '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 denied for user: '@localhost' to database 'test'
mysql
-Message d'origine-
De : Kevin Struckhoff [mailto:[EMAIL PROTECTED]
Envoyé : Monday, June 13, 2005 9:55 PM
À : [EMAIL PROTECTED]
Cc : mysql@lists.mysql.com
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Yannick,
MySQL is very picky in how it handles security, or at least different.
It has an extra layer of complexity, compared to say, the Informix
RDBMS, which uses the OS user/password and grant statements. With that
being said, have you run the post-install steps to add users to the
mysql database grant tables user db? Refer to section 2.9 of the MySQL
Reference Manual, especially section 2.9.3. Good Luck.
Kevin Struckhoff
Customer Analytics Mgr.
NewRoads West
Office 818.253.3819 Fax 818.834.8843
[EMAIL PROTECTED]
-Original Message-
From: Yannick [mailto:[EMAIL PROTECTED]
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 the root user :
[EMAIL PROTECTED]:/usr/bin mysqladmin -u root -h fujitsu password x
mysqladmin: connect to server at 'fujitsu' failed
error: 'Host 'fujitsu.local' is not allowed to connect to this MySQL
server'
[EMAIL PROTECTED]:/usr/bin mysqladmin -u root -h 192.168.234.2 password
xx
mysqladmin: connect to server at '192.168.234.2' failed
error: 'Host '192.168.234.2' is not allowed to connect to this MySQL
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Kevin,
In addition to that, the ZORUM database works because when I stop mysql, the
following site stops working :
http://www.wxy.nl/zorum_3_5/ with the database ZORUM
Here PHPadmin doesn't give me any privilege to create anything :
http://www.wxy.nl/phpMyAdmin/
I beleive I'm not to 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 mysql - Bayesian Filter detected
spam
Kevin,
Thanks for your answer. See below the results :
* I' really wondering if there is not any missing files.
* The mysql.soc file is complettly empty
* I can only access myssql when I am not in root.
* I can only see 1 database test when I know there is others like zorum
which is working
* The command Grant doesn't work.
The result is that I can never access any database.
I have been folowing the installatin process but it still does not work.
Do you mind to have a look at the details below and advice on which files I
should have a look.
Thanks in advance.
Yannick
fujitsu:/etc # mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc mysql -u root
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:/etc mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED]:/etc su
Password:
fujitsu:/etc # mysql -u mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/etc # mysql -u yannick
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
fujitsu:/etc # su mysql
[EMAIL PROTECTED]:/etc mysql -u yannick
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.15-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('Yannick');
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql SET PASSWORD FOR 'yannick' = PASSWORD('Yannick');
ERROR 1133: Can't find any matching row in the user table
mysql
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql
mysql UPDATE mysql.user SET Password = PASSWORD('Yannick')
- ;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
fujitsu:/bin # mysqlshow
mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # mysql -e SELECT Host,Db,User FROM db mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
fujitsu:/bin # bin/mysqld_safe --user=mysql --log
bash: bin/mysqld_safe: Aucun fichier ou répertoire de ce type
[1] 16599
[1] Exit 127bin/mysqld_safe --user=mysql --log
fujitsu:/bin # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
fujitsu:/bin #
mysql SHOW DATABASES;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql GRANT ALL ON menagerie.* TO 'mysql'@'localhost';
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
mysql GRANT ALL ON test TO '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 denied for user: '@localhost' to database 'test'
mysql
-Message d'origine-
De : Kevin Struckhoff [mailto:[EMAIL PROTECTED]
Envoyé : Monday, June 13, 2005 9:55 PM
À : [EMAIL PROTECTED]
Cc : mysql@lists.mysql.com
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Yannick,
MySQL is very picky in how it handles security, or at least different.
It has an extra layer of complexity, compared to say, the Informix
RDBMS, which uses the OS user/password and grant statements. With that
being said, have you run the post-install steps to add users to the
mysql database grant tables user db? Refer to section 2.9 of the MySQL
Reference Manual, especially section 2.9.3. Good Luck.
Kevin Struckhoff
Customer Analytics Mgr.
NewRoads West
Office 818.253.3819 Fax 818.834.8843
[EMAIL PROTECTED]
-Original Message-
From: Yannick [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 11:42 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Unable to install
RE: [SPAM] - Unable to install mysql - Bayesian Filter detected spam
Yannick, MySQL is very picky in how it handles security, or at least different. It has an extra layer of complexity, compared to say, the Informix RDBMS, which uses the OS user/password and grant statements. With that being said, have you run the post-install steps to add users to the mysql database grant tables user db? Refer to section 2.9 of the MySQL Reference Manual, especially section 2.9.3. Good Luck. Kevin Struckhoff Customer Analytics Mgr. NewRoads West Office 818.253.3819 Fax 818.834.8843 [EMAIL PROTECTED] -Original Message- From: Yannick [mailto:[EMAIL PROTECTED] 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 the root user : [EMAIL PROTECTED]:/usr/bin mysqladmin -u root -h fujitsu password x mysqladmin: connect to server at 'fujitsu' failed error: 'Host 'fujitsu.local' is not allowed to connect to this MySQL server' [EMAIL PROTECTED]:/usr/bin mysqladmin -u root -h 192.168.234.2 password xx mysqladmin: connect to server at '192.168.234.2' failed error: 'Host '192.168.234.2' is not allowed to connect to this MySQL server' [EMAIL PROTECTED]:/usr/bin Continuously, and I've tried lots of combinations, he is failing to connect to the server. Please give me so hints for me to be able to install it. Best regards Yannick [EMAIL PROTECTED] SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: yannick To: mysql@lists.mysql.com Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Yannick Vauloup Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.15 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.15, for suse-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.15-Max Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 min 8 sec Threads: 1 Questions: 14 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.045 C compiler:gcc (GCC) 3.3.1 (SuSE Linux) C++ compiler: g++ (GCC) 3.3.1 (SuSE Linux) Environment: machine, os, target, libraries (multiple lines) System: Linux fujitsu 2.4.21-286-default #1 Sat Apr 2 08:57:10 UTC 2005 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Lecture des spécification à partir de /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs Configuré avec: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/l ocal --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib --e nable-languages=c,c++,f77,objc,java,ada --disable-checking --enable-libgcj - -with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib --with-system-zli b --enable-shared --enable-__cxa_atexit i586-suse-linux Modèle de thread: posix version gcc 3.3.1 (SuSE Linux) Compilation info: CC='gcc' CFLAGS='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -DPIC -fPIC' CXX='g++' FLAGS='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -felide-constructor s -fno-exceptions -fno-rtti -fPIC -DPIC' LDFLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x1 root root 1469811 2003-09-24 01:05 /lib/libc.so.6 -rw-r--r--1 root root 13553180 2003-09-23 18:04 /usr/lib/libc.a -rw-r--r--1 root root 204 2003-09-23 18:04 /usr/lib/libc.so lrwxrwxrwx1 root root 20 2005-02-22 14:05 /usr/lib/libc-client.so - libc-client.so.2002d -rwxr-xr-x1 root root 770436 2003-09-23 20:29 /usr/lib/libc-client.so.2002d Configure command: ./configure '--disable-shared' '--enable-thread-safe-client' '--with-mysqld-ldflags=-static' '--with-client-ldflags=-static' '--without-berkeley-db' '--with-extra-tools' '--without-innodb' '--enable
FW: GWAVA Sender Notification (Spam)
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, April 08, 2005 12:51 PMSubject: GWAVA Sender Notification (Spam) A message sent by you was blocked by GWAVA - Content protection for Novell GroupWise. The message was blocked for the following reason(s): Spam The message contained the following information: Subject: RE: WARNING abuser on this list? From: [EMAIL PROTECTED] Recipient(s): [No To Addresses] [No Cc Addresses] [EMAIL PROTECTED], [EMAIL PROTECTED] The following information details the events that prevented delivery of this message: Event Details Spam The message was identified as potential spam
Re: FW: GWAVA Sender Notification (Spam)
[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 because of the capital letters and multiple exclamation points in the subject line -- which means the person who posted the original complaining message probably got the same sort of bounce. -- Keith Ivey [EMAIL PROTECTED] Smokefree DC http://www.smokefreedc.org Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FW: GWAVA Sender Notification (Spam)
Yes I received the same email about being a spammer. Somebody on the list told me that our email headers get rewritten and sometimes you get this email about being a spammer. Laurie At 02:29 PM 4/8/2005, Keith Ivey wrote: [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 because of the capital letters and multiple exclamation points in the subject line -- which means the person who posted the original complaining message probably got the same sort of bounce. -- Keith Ivey [EMAIL PROTECTED] Smokefree DC http://www.smokefreedc.org Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
{Spam?} Cannot start replication - can someone help?
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 for the slave. mysql SHOW GRANTS FOR [EMAIL PROTECTED]; +--- ---+ | Grants for [EMAIL PROTECTED] | +--- ---+ | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'server8'@'MyServer8IP' IDENTIFIED BY PASSWORD 'xxx' | +--- ---+ 1 row in set (0.00 sec) But when I stop and start the slave, I get: 050316 8:56:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.04' at position 79, relay log './server8-relay-bin.01' position: 4 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host 'server5.picado.com' (1)' errno: 2005 retry-time: 60 retries: 86400 When I try from the command line, I get it to work without problem: [EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.10-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Both /etc/my.cnf files are listed below [EMAIL PROTECTED] mysql]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M skip-networking sort_buffer=2M log-bin server-id=2 log-slave-updates log-warnings replicate-ignore-db=mysql replicate-do-db=anguillaguide [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [EMAIL PROTECTED] mysql]# cat /etc/my.cnf [mysqld] old-passwords max_connections = 500 key_buffer = 16M myisam_sort_buffer_size = 64M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 3M table_cache = 1500 thread_cache_size = 128 wait_timeout = 14400 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 skip-innodb log-bin=mysql-bin server-id=1 [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M Chris Mason Anguilla -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: {Spam?} Cannot start replication - can someone help?
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 statement on server5 for the slave. mysql SHOW GRANTS FOR [EMAIL PROTECTED]; +--- ---+ | Grants for [EMAIL PROTECTED] | +--- ---+ | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'server8'@'MyServer8IP' IDENTIFIED BY PASSWORD 'xxx' | +--- ---+ 1 row in set (0.00 sec) But when I stop and start the slave, I get: 050316 8:56:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.04' at position 79, relay log './server8-relay-bin.01' position: 4 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host 'server5.picado.com' (1)' errno: 2005 retry-time: 60 retries: 86400 When I try from the command line, I get it to work without problem: [EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.10-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql You have master set to server5.picado.com, not server5.domain.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** Re: efficient query for: it's your birthday today
[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 get back ... 30 rows in set (0.00 sec) on my test machine this variation takes approx. 0.18 seconds... Have you tried: SELECT SQL_NO_CACHE `userNames` FROM `userTable` WHERE SUBSTRING(`userBirthDate`, 6, 5) = SUBSTRING(NOW(), 6, 5) To prevent the use of the query cache? Otherwise you will get very fast results, just because the query is not executed at all, but the result is returned from the cache... [/snip] That first result was a non-cached query on a dual processor server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** Conditional statement: IF
[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 MySQL 4.0.18. Any help would be greatly appreciated. [/snip] Have you RTFM? SELECT IF(@SomeValue = 1, 'The value is 1', 'The value is not 1') http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: **[SPAM]** Conditional statement: IF
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 Fri, 22 Oct 2004 09:39:21 -0500, Jay Blanchard [EMAIL PROTECTED] wrote: [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 MySQL 4.0.18. Any help would be greatly appreciated. [/snip] Have you RTFM? SELECT IF(@SomeValue = 1, 'The value is 1', 'The value is not 1') http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: **[SPAM]** Conditional statement: IF
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 currently does not support that construction in ad hoc SQL scripts. However, you were shown two methods by which a query can return optional values. Perhaps you can minimize your round-trips to the server by using one of those methods. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Luke Venediger [EMAIL PROTECTED] wrote on 10/22/2004 01:48:41 PM: 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 Fri, 22 Oct 2004 09:39:21 -0500, Jay Blanchard [EMAIL PROTECTED] wrote: [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 MySQL 4.0.18. Any help would be greatly appreciated. [/snip] Have you RTFM? SELECT IF(@SomeValue = 1, 'The value is 1', 'The value is not 1') http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** Date as Primary ID
[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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** Backslash \ in query
[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'; Because the apostrophe in Doc's would cause the field to be read as 'Doc', but escaping the apostrophe allows it to be searched properly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: **[SPAM]** Backslash \ in query
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'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'; Because the apostrophe in Doc's would cause the field to be read as 'Doc', but escaping the apostrophe allows it to be searched properly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** matching people with projects via resources
[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; +--+-+-+ | proj | rsrc| name| +--+-+-+ | ark | wood| noah| | ark | wood| lincoln | | ark | canvas | noah| | ark | canvas | davinci | | cabin| wood| noah| | cabin| wood| lincoln | | monalisa | canvas | noah| | monalisa | canvas | davinci | | monalisa | paint | davinci | | jeans| canvas | noah| | jeans| canvas | davinci | | jeans| sewingmachi | NULL| +--+-+-+ [/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 have only all of the resources. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** RE: **[SPAM]** matching people with projects via resources
[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 have only all of the resources. [/snip] Will not workmany-to-many relationship... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: **[SPAM]** Help with PHP to MySQL db connection
[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]
Re: [Probable SPAM] Re: datadir specification, etc
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 configure to be /var/mysql-4.1.3/, and it doesnt read my.cnf from there anyway. In regard to the section of the manual mentioned: http://dev.mysql.com/doc/mysql/en/Option_files.html It states: DATADIR represents the location of the MySQL data directory. Typically this is `/usr/local/mysql/data' for a binary installation or `/usr/local/var' for a source installation. Note that this is the data directory location that was specified at configuration time, not the one specified with --datadir when mysqld starts. Use of --datadir at runtime has no effect on where the server looks for option files, because it looks for them before processing any command-line arguments. So, even by specifying the datadir at the command line when starting mysql, according to this documentation, mysql wont even bother looking in the command line specified datadir for a my.cnf On Friday 13 August 2004 10:15, V. M. Brasseur wrote: In my experience, where the my.cnf file is concerned, mysqld does not care what you define for the value of the --datadir flag. The order of precedence for locating my.cnf files is: 1) /etc/my.cnf 2) my.cnf in the COMPILED-IN DEFAULT datadir 3) .my.cnf in the user's $HOME That compiled-in default makes all the difference. You can start mysqld with as many different renditions of the --datadir flag as you want, but if one of them isn't the default path which was compiled in at build time (using the --localstatedir flag for configure) then mysqld will not automatically locate any my.cnf file in the specified datadir. For instance, I start all my servers with a --datadir=/path/to/mysql/data flag and have a my.cnf file in that directory. However, depending upon the platform and installation, the mysqld server will be looking in a number of different (and often non-existent) locations for the my.cnf file instead, such as /usr/local/mysql/var or similar. This is something which has caused many headaches on the machines I administer, occassionally leading to an intricate web of links to allow the server to locate the appropriate file. These links are not the only way to direct the server towards the appropriate my.cnf file. To be honest, they're only a hack and I wouldn't recommend them. One way to handle this is to rebuild MySQL from a source distribution, using the appropriate configure flags to set new default paths to be compiled into the binaries. A much easier way is to use the --defaults-file and/or --defaults-extra-file flags when starting the mysqld server. These flags--and not the value of any datadir flag--are what really tell mysqld where to locate the options file(s) it should use. The one drawback I've found with these flags is remembering to use the same flag(s) on any client programs which are run and training users to do the same. This has been enough of a pain to make it worth my while to deal with the web of links at this point. When all the machines are upgraded to MySQL 4.0.20 later this year, they will be receiving self-compiled binaries with our own flavor of default paths so none of these workarounds will be necessary. For more information about this sort of thing, check this page in the manual: http://dev.mysql.com/doc/mysql/en/Option_files.html Also, Paul DuBois' MySQL book has good information presented in a very accessible manner. Cheers, --V sean c peters wrote: I am 100% convinced that mysql 4.1.3 beta is not properly reading the my.cnf configuration files. If i remove the /etc/my.cnf file and try to start mysql 4.1.3 with (im working from /usr/local/mysql-4.1.3/bin) ./mysqld_safe i get the following output: (mccoy is the name of the machine im on) touch: /usr/local/mysql-4.1.3/var/mccoy.err cannot create chown: /usr/local/mysql-4.1.3/var/mccoy.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql-4.1.3/var ./mysqld_safe: /usr/local/mysql-4.1.3/var/mccoy.err: cannot create If i remove the /var/mysql-4.1.3/my.cnf file, i get the same output as above, so its not being read either way. And i did specify /var/mysql-4.1.3/ as my datadir with .configure when building 4.1.3 if i put the /etc/my.cnf file back, i get the following: A mysqld process already exists So clearly, the /etc/my.cnf is being read, but the /var/mysql-4.1.3/my.cnf is not. so i guess it doesnt matter what i specify in there at this point. One strange thing is that ./msqyd_safe tries to use the databases in /usr/local/mysql-4.1.3/var/ But i specified a different datadir with configure! my configure --prefix=/usr/local/mysql-4.1.3 but why should that matter? In fact, when i installed 4.1.3 (make install), the directory /usr/local/mysql-4.1.3/var/ was NOT created.
OT: anyone had a surge of spam recently?
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 list, as this is the only list I post to from both addresses. Anyone else noticed an increase? Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT: anyone had a surge of spam recently?
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: 2004/05/20 Thu AM 08:14:03 CDT To: [EMAIL PROTECTED] Subject: OT: anyone had a surge of spam recently? 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 list, as this is the only list I post to from both addresses. Anyone else noticed an increase? Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM]Re: e: Select distinct year from unix timestamp
From: Paul DuBois At 17:50 -0500 5/16/04, Paul DuBois wrote: Not a huge difference, I guess. But I suppose if a query that uses one or the other of these expressions processes a large number of rows, it might pay to run some comparative testing. Another interesting point is whether one timestamp format is to be preferred over the other in terms of performance of the operations to be done on it. The OP should be able to do this testing with the mechanism you demonstrated. John -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
