MysQL Installation
I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - 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: MysQL Installation
Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 2:17 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MysQL Installation Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - 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: MySQL Installation
I know this is OT a bit, but now I need to either re-compile PHP to get mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I need to do this at all? Even at rpmfind.net is seems hard to distinguish what it is I need. Is there anyway to get a 'complete' PHP rpm somewhere? Thanks! -Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 5:12 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MySQL Installation Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the server package, but MySql.com has it in the client's: $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin /usr/bin/mysqladmin /usr/share/man/man1/mysqladmin.1.gz sql, query ~Kelly W. Black PS IN the future check out http://www.rpmfind.net/ -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 12:51 PM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: MysQL Installation Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 2:17 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MysQL Installation Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - 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
MySQL statement problem
Shouldn't this come up with a list of names from each table that matches? SELECT * FROM table1,table2 WHERE table1.name = table2.name; Does anyone see anything wrong with this query? It keeps giving me an empty set - but there definitely matches. I even did a LIKE instead of =, takes longer, but comes out the same. I triple checked the data, and it is *exactly* the same! Help! Thanks! :) -Mike - 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
Getting Data From One Table Based On Another - Agh!
Looking through the MySQL stuff online, I still can't come up with a statement to pull data from one table based on data from another. Table1 Contains: orderid Table2 Contains: orderid otherfield1 otherfield2 I want to get the data from table 2 based on a matching orderid first pulled from table1. Anyone have any ideas? Either this isn't able to be done, or I am (and I'm not) not advanced enough to understand the SQL statement needed. So far, I have tried a number of them that haven't worked. Any ideas? Thanks! -Mike - 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: Is The MySQL Mailing List On Crack?
Jeremy Zawodny wrote : I'm getting duplicate messages separated by several hours. Am I alone in this, or are others seeing it too? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 5 days, processed 189,890,555 queries (402/sec. avg) Hi, Me too... I am even seeing one week old messages ! Me too! I'm even seeing messages from *next* week! -Mike - 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
Granting Privileges
Hey there! Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic privileges for just such. However, he is asking for privileges to be able to use CHECK, ANALYZE, and REPAIR table. He has privileges for OPTIMIZE. So I'm not sure how to grant him these privileges, or whether that would open a big security whole in MySQL if I did. I've checked the manual, but it is rather unspecific about these things. In fact, I couldn't find what References_priv represented privileges for either, so maybe that is it? Thanks for any and all help! -Mike [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