Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10th October 2008, 15: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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
Ruby / FastCGI Problem Chad Server Operation 1 8th March 2008 20:38
Strato Server - Restoring with SystemImager popper2001 HOWTO-Related Questions 5 28th July 2007 10:18
log files cruz Technical 3 15th May 2007 14:35
Creating image with Systemimager cuongtim HOWTO-Related Questions 3 18th November 2006 13:55


All times are GMT +2. The time now is 12:33.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.