View Single Post
  #1  
Old 10th October 2008, 16:59
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default Question on adding user to user table

Hi folks,


Virtual MailBox
Postfix
MySQL
Courier


mysql> show tables;
Code:
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.00 sec)

mysql> select user,host from user;
Code:
+------------------+-----------------------+
| user             | host                  |
+------------------+-----------------------+
| debian-sys-maint | localhost             |
| mail_admin       | localhost             |
| root             | localhost             |
| mail_admin       | localhost.localdomain |
| root             | xen6.satimis.com      |
+------------------+-----------------------+
5 rows in set (0.00 sec)

To add user 'satimis' to user table, whether run following commands;


mysql -u root -p

GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO
'satimis'@'satimis.com' IDENTIFIED BY 'satimis_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'satimis'@'localhost'
IDENTIFIED BY 'satimis_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO
'satimis'@'localhost.localdomain' IDENTIFIED BY 'satimis_password';
FLUSH PRIVILEGES;


# grep mydestination /etc/postfix/main.cf
Code:
mydestination = xen6.satimis.com, localhost, localhost.localdomain

Do I need to add "satimis.com" on the line?

TIA


B.R.
satimis
Reply With Quote
Sponsored Links