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/
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
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:
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]
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]
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: [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: {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'
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: [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]
Re: [SPAM]Re: Select distinct year from unix timestamp
From: Paul DuBois At 22:27 +0200 5/16/04, John Fawcett wrote: Year does not operate on a unix timestamp. Sure it does: mysql select t, year(t) from tsdemo1; ++-+ | t | year(t) | ++-+ | 20010822133241 |2001 | | 20010822133241 |2001 | ++-+ The problem lies elsewhere. Where that might be is difficult to say, because no PHP code has been shown yet. The first column doesn't look like a unix timestamp. It should be expressed in seconds since 1970-01-01 00:00:00 GMT. Try this to get the unix timestamp of the above date. Year shouldn't work on it. SELECT UNIX_TIMESTAMP('2001-08-22 13:32:41'); John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM]Re: Select distinct year from unix timestamp
At 0:25 +0200 5/17/04, John Fawcett wrote: From: Paul DuBois At 22:27 +0200 5/16/04, John Fawcett wrote: Year does not operate on a unix timestamp. Sure it does: mysql select t, year(t) from tsdemo1; ++-+ | t | year(t) | ++-+ | 20010822133241 |2001 | | 20010822133241 |2001 | ++-+ The problem lies elsewhere. Where that might be is difficult to say, because no PHP code has been shown yet. The first column doesn't look like a unix timestamp. Sorry. It's a TIMESTAMP column. It should be expressed in seconds since 1970-01-01 00:00:00 GMT. Try this to get the unix timestamp of the above date. Year shouldn't work on it. SELECT UNIX_TIMESTAMP('2001-08-22 13:32:41'); You're right. You'd have to apply YEAR() to FROM_UNIXTIME(UNIX_TIMESTAMP(arg)). -- 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]
Re: [OT] Autoresponders (is Re: Spam from this list)
Ok, let's collect the spamming addresses: [EMAIL PROTECTED] [EMAIL PROTECTED] (The Oracle) [EMAIL PROTECTED] [EMAIL PROTECTED] -- To Unix or not to Unix. That is the question whether 'tis nobler in the mind to suffer slings and arrows of vast documentation or to take arms against a sea of buggy OS and by raping the support lines end then? ; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Spam from this list
are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Joe Baptista - only at www.baptista.god Whenever we attack, they retreat. When we pound them with missiles and heavy artillery, they retreat even deeper. But when we stopped pounding, they pushed to the airport for propaganda purposes.'' ... Muhammed Saeed al-Sahaf former Iraqi Information Minister On Sat, 23 Aug 2003, Thomas Andersson wrote: Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply to my post to the list. Aparently a company is subscribed and use posts here to build a list of valid addresses to spam... The offending mailer was: [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 from this list
Joe Baptista wrote: are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Both, when I get a 'requested' salespitch I call it spam, no matter if it was auto or not. Seems I get it for every mail I post here. Best Wishes Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Spam from this list
Strange, I never get those!! Marc - Original Message - From: Thomas Andersson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 23, 2003 3:41 PM Subject: Re: Spam from this list Joe Baptista wrote: are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Both, when I get a 'requested' salespitch I call it spam, no matter if it was auto or not. Seems I get it for every mail I post here. Best Wishes Thomas -- 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 from this list
one doesn't even need to be subscribed to a list to get all the mail addresses. since all mails are archived and accessible from the web, a simple mail spider is sufficient. for this reason, i never use my private mail address for public postings of this kind. and as soon as i have my own mail server, i'll put it under a strict spam filter. ok, i fortunately don't get much spam for now, but you never know. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -Ursprüngliche Nachricht- Von: Thomas Andersson [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Samstag, 23. August 2003 15:25 Betreff: Spam from this list Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply to my post to the list. Aparently a company is subscribed and use posts here to build a list of valid addresses to spam... The offending mailer was: [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 from this list
Hi Thomas, I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its gone ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 23 22:25Thomas Andersson : Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply to my post to the list. Aparently a company is subscribed and use posts here to build a list of valid addresses to spam... The offending mailer was: [EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Spam from this list
Marc Storck wrote: Strange, I never get those!! I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... Best Wishes Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ITS NOT SPAM - ITS AN AUTORESPONDER - WAS Re: Re: Spam from this list (fwd)
This is not spam - it's an autoreponder - so lets not get to excited here. Joe Baptista - only at www.baptista.god Who is this dog Franks in Qatar? ... Muhammed Saeed al-Sahaf former Iraqi Information Minister -- Forwarded message -- Date: 23 Aug 2003 09:37:30 EDT From: Telemobile Inc. [EMAIL PROTECTED] Reply-To: Autoresponder [EMAIL PROTECTED] To: Joe Baptista [EMAIL PROTECTED] Subject: Re: Re: Spam from this list Telemobile Inc - Wireless Communication Solutions Thank you for your request. Please go to http://www.telemobile.com/ruraltelephony/ to download your information. Your sales manager has been notified and will contact you shortly to review your requirements. If you need immediate information then please contact us via email, fax or by phone at the numbers below. Thank you again for your interest. Best Regards, Telemobile Inc. ~~ Telemobile Inc - Wireless Communication Solutions an ISO-9001 registered company 19840 Hamilton Ave; Torrance, CA 90502; USA Tel: +1-310-538-5100; Fax:+1-310-532-8526 [EMAIL PROTECTED] http://www.telemobile.com Wireless Voice, Fax and Data. Anywhere! ~~ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Spam from this list
you should not bother the list with this nonsense - your concept of spam is another persons concept of managing information. Just send them an email to block autoreponder messages to this lists participants. If they can;'t comply then complain to the list manager. And this by definition is not spam. Spam is when you get something unsolicited. You solicited this response by sending a message which went to their MX. Once the message gets to them it's up to them to decide how they respond back to you - and that is not spam. There are better ways to deal with this then bother the list with spam complaints. contact the moderator and see what they can do. regards joe Joe Baptista - only at www.baptista.god {:::{::{:{{:::{::{:}::}:::}}:}::}:::} Why does a slight tax increase cost you two hundred dollars and a substantial tax cut saves you thirty cents? ... Happy Thought for the day :-) On Sat, 23 Aug 2003, Thomas Andersson wrote: Joe Baptista wrote: are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Both, when I get a 'requested' salespitch I call it spam, no matter if it was auto or not. Seems I get it for every mail I post here. Best Wishes Thomas -- 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 from this list
On Sat, 23 Aug 2003, Thomas Andersson wrote: Marc Storck wrote: Strange, I never get those!! I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... Best Wishes Thomas Now you have good reason to complain - because thats not right. An autoresponder should only send out email once per email address. Repeated sends is the sign of some twit not knowing how to operate an autoresponder. So this is good reason for the list moderator to take them off the list. regards joe Joe Baptista - only at www.baptista.god RONALD REAGAN on WHY DID THE CHICKEN CROSS THE ROAD? .. What chicken? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[OT] Autoresponders (is Re: Spam from this list)
Joe Baptista wrote: Now you have good reason to complain - because thats not right. An autoresponder should only send out email once per email address. Repeated sends is the sign of some twit not knowing how to operate an autoresponder. Yea - and very well set up autoresponders should maintain a pool of addresses *not* to respond to such as mailing lists. BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these mails twice to three times or so. Just wondering... Jakob ^-- To Unix or not to Unix. That is the question whether 'tis nobler in the mind to suffer slings and arrows of vast documentation or to take arms against a sea of buggy OS and by raping the support lines end then? ; Contact: \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \/Jakob Dölling \/EMail: mailto:[EMAIL PROTECTED]/ Treuerzipfel 13 ICQ #: 47326203 /\D-38678 Clausthal /\SMS #: +49-82668-8918663/\ /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ /\Webmaster of http://www.bank-ic.de/ /\ \/\/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [OT] Autoresponders (is Re: Spam from this list)
On Sat, 23 Aug 2003, Jakob [iso-8859-1] Dölling wrote: BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these mails twice to three times or so. Just wondering... i've been getting email from something called the oracle. regards joe baptista -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [OT] Autoresponders (is Re: Spam from this list)
I've been getting autoresponders from [EMAIL PROTECTED] [EMAIL PROTECTED] (The Oracle) [EMAIL PROTECTED] On Saturday, August 23, 2003, at 12:41 PM, Joe Baptista wrote: BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these mails twice to three times or so. Just wondering... i've been getting email from something called the oracle.
Re: Spam ?
Hi, I'm not sure what list this should go to, so I'm sending it to the general list. It's not about sql or queries it's more of a webmaster problem. Apologies to the offended. After sending several messages to the list I started receiving strange messages. It may be spam, it may be just a virus harvesting e-mail addresses from the list and then sending binaries attached - I can't tell because the charset looks Koreean. Maybe somebody has a clue about this. Sample attached bellow: cut here Received: from naver337.naver.com (HELO naver337) (211.218.150.17) by 0 with SMTP; Sat, 08 Mar 2003 04:32:10 + Date: Sat, 08 Mar 2003 13:32:02 +0900 (KST) From: [EMAIL PROTECTED] Subject: =?ks_c_5601- 1987?B?uN7AzyDA/LzbIL3HxtAgvsu4siA8bWFzdGVyZm9yY2VAbmF2Z XIu?= =?ks_c_5601-1987?B?Y29tPg==?= To: [EMAIL PROTECTED] Message-id: [EMAIL PROTECTED] MIME-version: 1.0 X-Mailer: NAVER Mailer 1.0 Content-type: multipart/mixed; boundary=Boundary_(ID_7dYFGzWCZdsyiOhNGcdvFA) Original-recipient: rfc822;[EMAIL PROTECTED] X-PMFLAGS: 570949760 0 1 P5A630.CNM --Boundary_(ID_7dYFGzWCZdsyiOhNGcdvFA) Content-type: multipart/alternative; boundary=Boundary_(ID_VNMNQwUzr2fCyUwiSpr4Tg) --Boundary_(ID_VNMNQwUzr2fCyUwiSpr4Tg) Content-type: Text/Plain; charset=euc-kr Content-transfer-encoding: base64 Ck5BVkVSIC0gaHR0cDovL3d3dy5uYXZlci5jb20vCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tCgrIssH4u+ogKG1hc3RlcmZvcmNlKSC01LK yILq4s7u9xSC43sDP IDxSZTogUmU6IEhBVklORyBiZWhhdmlvdXI+IMDMILTZwL2w+iCwsMC 6IMDMwK+3ziDA/LzbIL3H xtDH373AtM+02S4KCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tL S0tLS0tLS0tLS0t Cgq89r3FwNrAxyC43sDPILq4sPwgv+u3rsDMILChtebC9yDA1r3AtM+02 S4gs6rB37+hILTZvcMg vcO1tcfPvcq9w7/ALgoKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS 0tLS0tLS0tLS0t LS0tCg== --Boundary_(ID_VNMNQwUzr2fCyUwiSpr4Tg) Content-type: Text/HTML; charset=euc-kr Content-transfer-encoding: base64 CjxodG1sPgo8aGVhZD4KPHRpdGxlPrPXwMy59iC43sDPPC90aXRsZT 4KPHN0eWxlPgpBIHt0ZXh0 LWRlY29yYXRpb246IG5vbmV9CkE6bGluayB7Y29sb3I6IGJsdWV9CkE 6dmlzaXRlZCB7Y29sb3I6 ICM2NjY2NjZ9CkE6aG92ZXIge2NvbG9yOiAjZmY5OTMzfSAKI3JlZCB7 Y29sb3I6ICNkZDNmMDB9 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SPAM
Dear Daniel, Thanks for taking an interest in spam fighting. I have passed this information on to our list manager. He will do what he can to deal with this problem. In the future, please keep several things in mind: - we do not tolerate name calling based on religeon, race, sexual preferences, nationality, etc. on the MySQL lists! - please mail the list manager before mailing the general list. The list manager will do what they can to solve the problem. - we cannot condone attacks against systems suspected of delivering or relaying spam. Yours Truly, Zak Greant MySQL AB Community Advocate On Thu, Feb 27, 2003 at 10:59:35AM +1100, Daniel Kasak wrote: SQL. Query. Every time I post to the MySQL lists ([EMAIL PROTECTED] and [EMAIL PROTECTED]) I get a sign-up verification message claiming to be coming from a yahoo groups list. I checked out the source and found it is the same faggot who is spamming with various get-rich-quick schemes: bash-2.05# smbclient -L 220.72.176.55 added interface ip=10.146.0.254 bcast=10.146.255.255 nmask=255.255.0.0 session request to 220.72.176.55 failed (Called name not present) session request to 220 failed (Called name not present) Password: Anonymous login successful Domain=[WORKGROUP] OS=[Windows 5.0] Server=[Windows 2000 LAN Manager] Sharename Type Comment - --- Error returning browse list: NT_STATUS_ACCESS_DENIED Server Comment ---- SUPERMAIL WorkgroupMaster ---- WORKGROUPSUPERMAIL bash-2.05# Unfortunately, smbdie doesn't work on this computer, otherwise I would add him to my reboot-every-5-minutes cron job. If anyone else can take him off the 'net, be my guest. Alternatively, how about banning him from receiving posts? He's adding EVERYONE who posts to his spam lists. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com
On 23 Nov 2002 12:49:33 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (4.20 hits, 4 required) SPAM: NO_REAL_NAME (1.3 points) From: does not include a real name SPAM: FORGED_RCVD_FOUND (0.8 points) Possibly-forged 'Received:' header found SPAM: SPAM_PHRASE_05_08 (1.6 points) BODY: Spam phrases score is 05 to 08 (medium) SPAM: [score: 6] SPAM: MAILTO_TO_SPAM_ADDR (0.7 points) URI: Includes a link to a likely spammer email address SPAM: SIGNATURE_SHORT_DENSE (-0.3 points) Short signature present (no empty lines) SPAM: MSG_ID_ADDED_BY_MTA_2 (0.1 points) 'Message-Id' was added by a relay (2) SPAM: SPAM: End of SpamAssassin results - Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: mysql-sc.1038055773.fmkjmofeihfglclhmmci-lloy0076=adam.com.au@list s.mysql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 22014 invoked by uid 7797); 23 Nov 2002 12:49:33 - Delivered-To: request processor for [EMAIL PROTECTED] Received: (qmail 22009 invoked from network); 23 Nov 2002 12:49:31 - Received: from monster.filearena.net (202.6.159.69) by www.mysql.com with SMTP; 23 Nov 2002 12:49:31 - Received: from lightning.adam.com.au (lightning.adam.com.au [203.2.124.20]) by monster.filearena.net (8.12.6/8.12.6) with SMTP id gANCnRbT035234 for [EMAIL PROTECTED]; Sat, 23 Nov 2002 23:19:28 +1030 (CST)(envelope-from [EMAIL PROTECTED]) Received: (qmail 70429 invoked from network); 23 Nov 2002 12:49:23 - Received: from 202-6-129-44.ip.adam.com.au (HELO localhost) (202.6.129.44) by eden.adam.com.au with SMTP; 23 Nov 2002 12:49:23 - Date: Sat, 23 Nov 2002 23:31:12 +1030 From: David Lloyd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: subscribe Message-Id: [EMAIL PROTECTED] X-Mailer: Sylpheed version 0.8.5 (GTK+ 1.2.9; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit --
Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com
On 23 Nov 2002 12:54:52 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (4.20 hits, 4 required) SPAM: NO_REAL_NAME (1.3 points) From: does not include a real name SPAM: FORGED_RCVD_FOUND (0.8 points) Possibly-forged 'Received:' header found SPAM: SPAM_PHRASE_05_08 (1.6 points) BODY: Spam phrases score is 05 to 08 (medium) SPAM: [score: 6] SPAM: MAILTO_TO_SPAM_ADDR (0.7 points) URI: Includes a link to a likely spammer email address SPAM: SIGNATURE_SHORT_DENSE (-0.3 points) Short signature present (no empty lines) SPAM: MSG_ID_ADDED_BY_MTA_2 (0.1 points) 'Message-Id' was added by a relay (2) SPAM: SPAM: End of SpamAssassin results - Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: mysql-sc.1038056092.mkconkllmfaolhocmndb-lloy0076=adam.com.au@list s.mysql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 22305 invoked from network); 23 Nov 2002 12:54:44 - Received: from monster.filearena.net (202.6.159.69) by www.mysql.com with SMTP; 23 Nov 2002 12:54:44 - Received: from lightning.adam.com.au (lightning.adam.com.au [203.2.124.20]) by monster.filearena.net (8.12.6/8.12.6) with SMTP id gANCsfbT035321 for [EMAIL PROTECTED]; Sat, 23 Nov 2002 23:24:41 +1030 (CST)(envelope-from [EMAIL PROTECTED]) Received: (qmail 72873 invoked from network); 23 Nov 2002 12:54:37 - Received: from 202-6-129-44.ip.adam.com.au (HELO localhost) (202.6.129.44) by eden.adam.com.au with SMTP; 23 Nov 2002 12:54:37 - Date: Sat, 23 Nov 2002 23:36:27 +1030 From: David Lloyd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] X-Mailer: Sylpheed version 0.8.5 (GTK+ 1.2.9; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit -- I'm sure you'll see there's more to Martin Guerre than a name! (From the musical, Martin Guerre) -- I'm sure you'll see there's more
Re: Spam
It seems they are using SPEWS (www.spews.org). A rude way to find out that our ISP has a problem with the IP address they gave us :-{ -- From: MySQL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Spam Reply-To: [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 08:23:23 -0700 (PDT) Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST) From: Gabriele Carioli [EMAIL PROTECTED] -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. Only if the wars between the various blacklists have died out. A little internet history: open relays were designed to allow people with unreliable email connections to communicate. The newbies on the internet have messed that up, but there are still areas in the world where the original problem still exists. Frankly the antispammers are more of a pita than the spammers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Spam
Gabriele Carioli wrote: -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. On this note, may I beg for a meta-list for the discussing of the management of mysql.com's lists in general? That way suggestions / discussions / arguments have a place to go. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Spam
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST) From: Gabriele Carioli [EMAIL PROTECTED] -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. Only if the wars between the various blacklists have died out. A little internet history: open relays were designed to allow people with unreliable email connections to communicate. The newbies on the internet have messed that up, but there are still areas in the world where the original problem still exists. Frankly the antispammers are more of a pita than the spammers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SPAM *** Audit feature in MySQL ***
Try http://www.mysql.com/doc/en/Query_log.html -Original Message- From: Imro Benito STROK [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 20:04 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; Imro Benito STROK Subject: SPAM *** Audit feature in MySQL *** Hi All, Due to security reasons we have to implement an audit functionality in our MySQL production databases. Q; Is there an audit feature in MySQL. If YES can someone send me the information how to implement this. Thanks, Imro Strok StarHub Pte Ltd Information Technology Phone: +65 6825 5703 Email : [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: *****SPAM***** Query problem
Amit, I am trying to run the following query:- select red,green,blue from colorchanger where colorcode = select value from jobattributekit where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; It doesn't support subselects. It's having a problem with the second select... I believe that subselects are on the wish list and will (eventually) appear but not at the moment in a stable release. DSL mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: *****SPAM***** when I installed mysql 3.23.43
Dave [ mysql query] when I installed mysql 3.23.43 it instructed me to be sure to add a password with the following results- : seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Read the man pages for mysqladmin for full details on all options (there are lots of them ;-P). The option -p is the password you use to connect to the server, however on a default installation you should specify no password. Essentially what you're doing is saying: Connect me to the server at 'localhost' with the password 'password' and user 'root' ...which is NOT what you want to do because the default databases don't expect a password _at all_ [which is why it is strongly suggested you change the passsword] Drop the -p so it looks like: /usr/mysql/bin/mysqladmin -uroot password 'newpassword' Also, don't forget to flush the privileges after changing the password. DSL -- We are not the United States' ally We are the 53rd sovereign state of the Federation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Spam Filtered - Re: Making Unique Pairs ??
alter table your_table add unique index (path_id,word) ; -Message d'origine- De : Jon Shoberg [mailto:[EMAIL PROTECTED]] Envoyé : mardi 5 février 2002 16:40 À : [EMAIL PROTECTED] Objet : Spam Filtered - Re: Making Unique Pairs ?? HUH ? Oh well lets try again, please read below ... SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%' Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table such as IDpath_idword ID is the primary key unqigned int path_id is a foreign key unsigned int word is a single word of text varchar (32) How can I set up the table such that all -pairs- of PATH_ID and WORD are unique? The table should look like the following 12jim 23tom 32joe 47jack but if I try an insert '2' and 'jim' again, the statement fails. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Spam - a possible cause ?
- Original Message - From: Marjolein Katsma [EMAIL PROTECTED] To: [EMAIL PROTECTED] [RegSoft/mysql] [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 12:44 PM Subject: RE: Spam - a possible cause ? Matthew, snip Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. Marjolein, They sound like great opportunities. Do you have any more info? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Spam - a possible cause ?
snip Spam is people not interested in MySQL at all posting a Business opportunity (Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!) or Golden Investment Opportunity or Great Growth Potential stock scams. Marjolein, They sound like great opportunities. Do you have any more info? Tony, Tony, Wouldn't your first step in such innocense and foolishness be to e-mail [EMAIL PROTECTED] !? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php