From owner-freebsd-questions Mon Apr 10 11:15:39 2000 Delivered-To: freebsd-questions@freebsd.org Received: from java.dpcsys.com (java.dpcsys.com [206.16.184.7]) by hub.freebsd.org (Postfix) with ESMTP id 013C937BC7A for ; Mon, 10 Apr 2000 11:15:27 -0700 (PDT) (envelope-from dan@dpcsys.com) Received: from localhost (dan@localhost) by java.dpcsys.com (8.10.0.Beta12/8.10.0.Beta12) with SMTP id e3AI6q701531; Mon, 10 Apr 2000 11:07:00 -0700 (PDT) Date: Mon, 10 Apr 2000 11:06:52 -0700 (PDT) From: Dan Busarow To: Dan Langille Cc: freebsd-questions@FreeBSD.ORG Subject: Re: mysql root password In-Reply-To: <200004100443.QAA68025@ducky.nz.freebsd.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 10 Apr 2000, Dan Langille wrote: > # 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 With --skip-grant-tables you can $ mysqldump mysql user > afile Edit afile by removing the create table command, adding a delete from user where User = 'root'; And then change the two inserts for root to use a normal user login id. (no password) Shutdown and restart mysql without the skip-grant-tables argument. Dan -- Dan Busarow 949 443 4172 Dana Point Communications, Inc. dan@dpcsys.com Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message