Date: Mon, 10 Apr 2000 16:43:34 +1200 From: "Dan Langille" <dan@freebsddiary.org> To: freebsd-questions@freebsd.org Subject: mysql root password Message-ID: <200004100443.QAA68025@ducky.nz.freebsd.org>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200004100443.QAA68025>