From owner-freebsd-questions@FreeBSD.ORG Sat Oct 29 17:32:57 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 937A316A420 for ; Sat, 29 Oct 2005 17:32:57 +0000 (GMT) (envelope-from john.destefano@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by mx1.FreeBSD.org (Postfix) with ESMTP id CA78643D45 for ; Sat, 29 Oct 2005 17:32:56 +0000 (GMT) (envelope-from john.destefano@gmail.com) Received: by wproxy.gmail.com with SMTP id 71so329638wra for ; Sat, 29 Oct 2005 10:32:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ZYPFe7YG9GuHGqcx6KFv3txjCdfT3cwy7WZjzPrWLgZPEAR+ZPaqczsH6IvuVivYvxVfl9MZ4PpnF6oapXmJac1YYDrXNLufg5acKqeh93EK9LLL0oC/nP7L+zmDyqQN3ObvNIKUo1dZr2dFtr/L+iwbUjg2M842VAEhKjoFrgA= Received: by 10.65.75.17 with SMTP id c17mr261470qbl; Sat, 29 Oct 2005 10:32:56 -0700 (PDT) Received: by 10.65.154.4 with HTTP; Sat, 29 Oct 2005 10:32:56 -0700 (PDT) Message-ID: Date: Sat, 29 Oct 2005 13:32:56 -0400 From: John DeStefano To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Subject: reusing existing mysql permissions/dbs/tables after update X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Oct 2005 17:32:57 -0000 mysql was among the many ports I just upgraded, and (of course) I can now no longer connect using mysql or mysqladmin. I've tried just about every method I've found including starting the daemon with the --skip-grant-tables option to reset the password (which has worked in the past), and most every other suggestion listed in section 5.7.8 of the MySQL reference manual. It seems like running the mysql_install_db script might do the trick... but if I understand correctly, running this script will re-initialize the grant tables... correct? Is there another way of regaining access to mysql, without losing the current relationships between dBs/tables and their users? Or, how can I get to the current grant information (in human-readable format), so that I can restore it later? Thank you, ~John # uname -a FreeBSD zurg.thedestefanos.com 5.4-STABLE FreeBSD 5.4-STABLE #0: Mon Oct 24 22:27:33 EDT 2005 =20 root@zurg.thedestefanos.com:/usr/obj/usr/src/sys/MYKERNEL i386 # pkg_info | grep mysql mysql-client-5.0.15 Multithreaded SQL database (client) mysql-server-5.0.15 Multithreaded SQL database (server) php5-mysql-5.0.5_1 The mysql shared extension for php