How to enable OpenSSL support
Hi list, I'd like to try out the OpenSSL support of MySQL, but I could not find out how to enable it. The documentation just says, Configure MySQL with --with-vio --with-openssl. Since I do not compile my MySQL binaries myself, this is impossible to me... Instead I'm using the Lnux binary RPMs (Server + Max + Client) for my Linux machine and the Win32 binary (mysqld-max-nt) distribution for my Windows XP machine. Of course I have installed the latest OpenSSL toolkit on both machines first. I went through all startup parameters that mysqld-max-net --help prints out, but I still could not find a clue how to enable it. On the MySQL download page, there is a not about the Max binary packages saying, The Max version includes additional features such as [...] OpenSSL support. So, the Max binarys do support OpenSSL, but how do I enable it? Thanks in advance, Alexander M. Turek PS.: Please also reply to my address because I did not subscribe to this list, thanks. - 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 4.0.7-gamma: Bugs affecting the privilege system
Hi Stefan, -Original Message- From: Stefan Hinz, iConnect (Berlin) Alexander, - After having set up both machines completely, I installed the Win32 binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade from an earlier version, the privileges tables still have the old structure without the new columns introduced with MySQL 4.0.2-beta! Furthermore, the script menioned in the documentation (mysql_fix_privilege_tables) is obiously not included in the distribution. Because of this, there is no way to use the new privilege system but fixing the tables manually... I encountered the same issue, and Miguel Solórzano from MySQL AB replied that it was his fault, simply forgetting the new privilege tables in the Win32 dist. mysql_fix_privilege_tables is nowhere to find, but a list member who had pulled the 4.1 source found it in there and sent it to me. I extracted the SQL statements, ran the script, and now my 4.0.7 has all the new privileges. You'll find it at the bottom of this mail. Maybe this can fix the other bugs you reported, too. Hi Stefan, It does not. I fixed the priv tables manually, but the other two bugs are still occuring. Have you tried to reproduce them? Thanks, Alexander - 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: subselect workaround help?
-Original Message- From: Lefevre, Steven [mailto:[EMAIL PROTECTED]] Hey folks- 'nother question. I'm not an SQL expert, and I think I need a subselect, which means I need a workaround on MySQL 3.23 or whatever version it is. Here's the tables I have, with the relevant columns: Students - Name - StudentID (PK) - ClassID Classes - ClassID (PK) - Name Each Student belongs to one class. So, I have the StudentID. I want to get the Classes.Name... Final result should look like Student | Class -- Steve Lefevre | Math101 Stacy Adams | Intro to SQL Hi Steve, try SELECT `Students`.`Name` AS Student, `Classes`.`Name` AS Class FROM `Students` LEFT JOIN `Classes` USING `ClassID`; Regards, Alexander - 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 4.0.7-gamma: Bugs affecting the privilege system
Hi MySQL team, I'm not sure, if this is the right place for bug reports, so, if it isn't, please forward this to those who are resposible. Running MySQL 4.0.7 on a Windows NT 5.2 RC2 machine and on a Windows NT 5.1 one as well, I encoutered some bugs: - After having set up both machines completely, I installed the Win32 binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade from an earlier version, the privileges tables still have the old structure without the new columns introduced with MySQL 4.0.2-beta! Furthermore, the script menioned in the documentation (mysql_fix_privilege_tables) is obiously not included in the distribution. Because of this, there is no way to use the new privilege system but fixing the tables manually... - If I create a user by GRANT USAGE ON *.* TO 'foo'@'foohost'; and try to get the GRANT query by SHOW GRANTS FOR 'foo'@'foohost'; afterwards, MySQL returns an empty result set. If I add a query like SET PASSWORD FOR 'foo'@'foohost' = PASSWORD('foobar'); and try the SHOW GRANTS query menitioned above again, MySQL correctly returns: +--- --+ | Grants for foo@foohost | +--- --+ | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD '4655c05b05f11fab' | +--- --+ - If I create a user by GRANT USAGE ON `footable`.* TO 'foo'@'foohost' IDENTIFIED BY 'foobar' WITH GRANT OPTION; and try to get the GRANT query again, MySQL returns this: +--- --+ | Grants for foo@foohost | +--- --+ | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD '4655c05b05f11fab' | | GRANT ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION | +--- --+ While the first query is completly correct, the second one would result in an error... Happy fixing, Alexander M. Turek [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