Re: How to know MySQL instance(all daemons) really startup?
Robert, `mysqladmin ping` will print mysqld is alive if the server is running, or error message in any other case. Peter On Wed, 20 Feb 2002, Li, Robert wrote: Hi, all mysql team As we know, use safe_mysqld or mysql.server we can startup Mysql instance. But how can i know when all the mysqld daemons really startup except use command ps? Thanks in advance. Robert Li Computer Associates -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: Please have a look on this group by
Oliver, select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesnt bring the expected pair preis / lfd but all available preis/lfd grouped ascending. you're grouping by the same column you're trying to aggregate with MIN(), so it's normal that you're getting all of the values of 'preis' in the result. You might want to GROUP BY a different column, e.g. 'typ' or 'marke' in your example. HTH, Peter sql, query -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: [SECURITY] How do these blank passwords get into mysql.user?
Philip, you should explicitly specify host/password in the GRANT statement, like this: GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; This way the user will only granted access from the specified host, you don't need to manually INSERT into the user table. (You'll also get rid of the empty passwords.) Peter On Tue, 19 Feb 2002, Philip Mak wrote: One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec) mysql insert into user set host='localhost', user='xxx', password=password('yyy'); Query OK, 1 row affected (0.03 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql grant all privileges on xxx to xxx; Query OK, 0 rows affected (0.03 sec) mysql grant all privileges on xxx.* to xxx; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql select host,user,password from user where user='xxx'; +---+--+--+ | host | user | password | +---+--+--+ | % | xxx | | | localhost | xxx | 66debff13dff1053 | +---+--+--+ 2 rows in set (0.00 sec) What did I do wrong to cause these users with blank passwords to be created (essentially opening me wide to the outside)? My MySQL version is 3.23.47. It's worked fine after I delete the extra row in the user table manually, but this could be dangerous to someone who doesn't notice it! -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: Please have a look on this group by
In this case you have to omit GROUP BY from your query. Peter On Tue, 19 Feb 2002, CreaCtion wrote: At 19.02.2002 10:20, you wrote: What would you expect the database to return Thanks to all so far, The query should give the smallest price MIN(preis) and the according lfd number of this record. so the answer should only be one pair f.e.: 15200,00 | 41 . I think this should work, as this is the same row ??? Maybe a bug? MySQL 3.22.32 is running. Oliver -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: Decrypt Password
The ENCRYPT() function uses one-way encryption algorithm, which means the resulting hash cannot be decrypted. If you want to compare a not crypted value to a crypted one, you should also use ENCRYPT(), and compare the hashes. HTH, Peter On 18 Feb 2002, Amit Dilip Lonkar wrote: Hi Can anyone tell me if there is a function as DECRYPT. If there is not, then how to decrypt a field which is Encrypted by the Mysql function ENCRYPT. URGENT Thanks Amit Lonkar -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: Regex man page
Joe, you can find it here: http://arglist.com/regex/ Peter On Fri, 15 Feb 2002, Joe Polanik wrote: According to the online manual the regex man page contributed by Henry Spencer is included in the source distribution of MySQL. I'm hesitant to download and install a source distribution just to get a man page. Is it found anywhere else? thanks, Joseph Polanik -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: domain name bug
Put quotes around the hostname: grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net' identified by 'X'; Peter On Thu, 7 Feb 2002, Paul Faber wrote: Not sure if thius is supposed to go here but my version of MySQL mysql status; -- mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686) the GRANT command errors out when the domain name has a '-' dash in it. mysql grant Select, Insert, Update, Delete on X.* to [EMAIL PROTECTED] identified by 'X'; ERROR 1064: You have an error in your SQL syntax near '-tech.net identified by 'X'' at line 1 escaping the - makes things worse. -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: domain name bug
Put quotes around the hostname: grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net' identified by 'X'; Peter On Thu, 7 Feb 2002, Paul Faber wrote: Not sure if thius is supposed to go here but my version of MySQL mysql status; -- mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686) the GRANT command errors out when the domain name has a '-' dash in it. mysql grant Select, Insert, Update, Delete on X.* to [EMAIL PROTECTED] identified by 'X'; ERROR 1064: You have an error in your SQL syntax near '-tech.net identified by 'X'' at line 1 escaping the - makes things worse. -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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