Date: Mon, 10 Apr 2000 11:06:52 -0700 (PDT) From: Dan Busarow <dan@dpcsys.com> To: Dan Langille <dan@freebsddiary.org> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: mysql root password Message-ID: <Pine.BSF.3.96.1000410110236.13391E-100000@java.dpcsys.com> In-Reply-To: <200004100443.QAA68025@ducky.nz.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.1000410110236.13391E-100000>