[rt-users] Default password

John Oliver joliver at john-oliver.net
Tue Jul 31 17:49:40 EDT 2007


On Tue, Jul 31, 2007 at 01:49:29PM -0700, Chaim Rieger wrote:
> John Oliver wrote:
> >I found http://wiki.bestpractical.com/view/RecoverRootPassword
> >However... it doesn't help :-(
> >
> >mysql> update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where
> >Name='root';
> >Query OK, 0 rows affected (0.00 sec)
> >Rows matched: 0  Changed: 0  Warnings: 0
> >
> >mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE
> >Name='root';
> >Query OK, 0 rows affected (0.01 sec)
> >Rows matched: 0  Changed: 0  Warnings: 0
> >
> >
> >0 rows affected sounds like there is no username "root"
> mysql  -u (whatever) -p (if needed)
> then you need to change to the rt db
> use "name_of_rt_db"
> then you can reset the passwd.

Yes, I know... :-)

[root at rt3 ~]# mysql -h ntdbs01 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use rt3;
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> update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where
Name='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE
Name='root';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0  Changed: 0  Warnings: 0


I shouldn't have to manually add a 'root' user.  Right?

-- 
***********************************************************************
* John Oliver                             http://www.john-oliver.net/ *
*                                                                     *
***********************************************************************



More information about the rt-users mailing list