Re: Start from scratch
Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - 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: Start from scratch
OK I get what you mean except that I installed on debian potato and therefore do not have the reinit step since I used apt-get. Do you have any ideas on this one. Thanks again jm - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "John-Mark" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 1:35 PM Subject: Re: Start from scratch Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - 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: Start from scratch
I have no idea what 'apt-get' is. MySQL, IMHO, should always be installed from the sources by compiling by hands. Get the sources and learn to install it correctly. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: "Artem Koutchine" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:56 PM Subject: Re: Start from scratch OK I get what you mean except that I installed on debian potato and therefore do not have the reinit step since I used apt-get. Do you have any ideas on this one. Thanks again jm - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "John-Mark" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 1:35 PM Subject: Re: Start from scratch Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - 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