RE: privileges when moving from mysql 3.23 to 4.0
i used this mysql_fix_privilege_tables hoping it would migrate about 100 user database privileges, but it doesnt seem to have done the job what else do i need to do ? as i said before i dont particularly want to have to reset and regrant everyones passwords. -Original Message- From: Dan Rossi [mailto:daniel;electroteque.org] Sent: Friday, November 08, 2002 9:20 AM To: [EMAIL PROTECTED] Subject: RE: privileges when moving from mysql 3.23 to 4.0 how is there a way to retain the user privileges in the mysql table when dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these individually , let me know 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 - 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: privileges when moving from mysql 3.23 to 4.0
never mind it worked now , had to restart the server heh -Original Message- From: Dan Rossi [mailto:daniel;electroteque.org] Sent: Saturday, November 09, 2002 3:25 AM To: Dan Rossi; [EMAIL PROTECTED] Subject: RE: privileges when moving from mysql 3.23 to 4.0 i used this mysql_fix_privilege_tables hoping it would migrate about 100 user database privileges, but it doesnt seem to have done the job what else do i need to do ? as i said before i dont particularly want to have to reset and regrant everyones passwords. -Original Message- From: Dan Rossi [mailto:daniel;electroteque.org] Sent: Friday, November 08, 2002 9:20 AM To: [EMAIL PROTECTED] Subject: RE: privileges when moving from mysql 3.23 to 4.0 how is there a way to retain the user privileges in the mysql table when dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these individually , let me know 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 - 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: privileges when moving from mysql 3.23 to 4.0
how is there a way to retain the user privileges in the mysql table when dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these individually , let me know 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