Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the command
./mysqladmin --skip-grant-tables, I get the error message
mysqladmin: ERROR: unknown option '--grant-tables'
I also tried ./mysqladmin --skip-grant-tables --user=root and this
didn't help either
I'm using Mysql version 4.0.17-standard which came bundled with my OS
(Ubuntu Linux Warty)
Pointers much appreciated.
Thanks,
Alfred Vahau
IT Services
University of Papua New Guinea
You appear to have misread the manual. --skip-grant-tables is not a mysqladmin
option. It's a mysqld option.
Just follow the directions in the manual
<http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
