RE: Help resetting password on MySQL 5

2005-12-01 Thread Logan, David (SST - Adelaide)
4259 - Fax -Original Message- From: untz [mailto:[EMAIL PROTECTED] Sent: Friday, 2 December 2005 10:09 AM To: mysql@lists.mysql.com Subject: Re: Help resetting password on MySQL 5 Ok, this worked... My question is that is the password for 'root' supposed to match the sudo passwo

Re: Help resetting password on MySQL 5

2005-12-01 Thread untz
Ok, this worked... My question is that is the password for 'root' supposed to match the sudo password used to grant super priveleges to the bash user? I purposely wanted this different and changed my root password on mysqladmin to something else... Is it supposed to be the same as the root's

Re: Help resetting password on MySQL 5

2005-12-01 Thread untz
Nestor, When I tried this... This is what I got: mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> delete from user where id='root'; ERROR 1054 (42S22): Unknown column 'id'