From owner-freebsd-questions Sun Apr 9 21:43:51 2000 Delivered-To: freebsd-questions@freebsd.org Received: from ducky.nz.freebsd.org (chilled.unixathome.org [203.79.82.27]) by hub.freebsd.org (Postfix) with ESMTP id E1A4A37B53E for ; Sun, 9 Apr 2000 21:43:45 -0700 (PDT) (envelope-from dan@freebsddiary.org) Received: from wocker (wocker.int.nz.freebsd.org [192.168.0.99]) by ducky.nz.freebsd.org (8.9.3/8.9.3) with ESMTP id QAA68025 for ; Mon, 10 Apr 2000 16:43:39 +1200 (NZST) Message-Id: <200004100443.QAA68025@ducky.nz.freebsd.org> From: "Dan Langille" Organization: The FreeBSD Diary To: freebsd-questions@freebsd.org Date: Mon, 10 Apr 2000 16:43:34 +1200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: mysql root password Reply-To: dan@freebsddiary.org X-mailer: Pegasus Mail for Win32 (v3.12b) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I'm trying to reset the root password for mysql. All the resources I've found have said to restart mysql with the -Sg command and then reset the root password. All attempts to reset the password have failed: mysql> grant ALL PRIVILEGES on * to root identified by 'password'; ERROR 1047: Unknown command mysql> SET PASSWORD FOR root = PASSWORD('password'); ERROR 1132: You must have privileges to update tables in the mysql database to be able to change passwords for others # mysqladmin -u root password newpassword mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' I've tried both of the following starts for mysqld: /usr/local/bin/safe_mysqld --skip-grant-tables /usr/local/libexec/mysqld --skip-grant-tables I'm stuck. TIA. -- Dan Langille - DVL Software Limited [I'm looking for more work] http://www.dvl-software.com/ | http://www.unixathome.org/ http://www.racingsystem.com/ | http://www.freebsddiary.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message