[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