[rt-users] Default password

[John Oliver]

On Tue, Jul 31, 2007 at 02:53:50PM -0700, Chaim Rieger wrote:
> John Oliver wrote:
> >I shouldn't have to manually add a 'root' user.  Right?
> >
> >  
> 
> after use rt3 do show tables
> then
> select * from Users
> 
> is root in there ?

No.

But the tables are there...

[root at rt3 ~]# mysql -h ntdbs01 -u rt_user -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
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> show tables;
+-------------------------+
| Tables_in_rt3           |
+-------------------------+
| ACL                     |
| Attachments             |
| Attributes              |
| CachedGroupMembers      |
| CustomFieldValues       |
| CustomFields            |
| GroupMembers            |
| Groups                  |
| Links                   |
| ObjectCustomFieldValues |
| ObjectCustomFields      |
| Principals              |
| Queues                  |
| ScripActions            |
| ScripConditions         |
| Scrips                  |
| Templates               |
| Tickets                 |
| Transactions            |
| Users                   |
| sessions                |
+-------------------------+
21 rows in set (0.00 sec)

Absolutely bizarre.

OK, how do I add a root user correctly?

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