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... :-) [EMAIL PROTECTED] ~]# 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/ * * * *********************************************************************** _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com