[Serusers] aliases in MySQL tables

Timur Elzhov elzhov at warelex.com
Thu Mar 31 14:26:15 CEST 2005


On Thu, Mar 31, 2005 at 11:46:56AM +0200, Llanos Serna Garc?a-Conde wrote:

> I think I have the right configuration for MySQL database, because I
> can add users, but I want to add aliases also to the MySQL database,
> and it seems that the aliases are added to some dynamic table I can't
> view.

mysql> connect ser;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    4478
Current database: ser

mysql> connect ser;
mysql> show tables;
+-----------------------+
| Tables_in_ser         |
+-----------------------+
| acc                   |
| active_sessions       |
| admin_privileges      |
| aliases               |
 ^^^^^^^^^
??

simply type in mysql prompt

  select * from aliases;

to view `aliases' content.


-- 
Best regards,
Timur V. Elzhov
COO
Warelex LLC




More information about the sr-users mailing list