Difference between revisions of "SPPEWEBMAIL"
| Line 1: | Line 1: | ||
| − | ==''Create User''== | + | =='''Create User'''== |
SELECT * FROM mywebmail.users WHERE username = 'busdev' | SELECT * FROM mywebmail.users WHERE username = 'busdev' | ||
SELECT * FROM mywebmail.users WHERE uid = '6537' | SELECT * FROM mywebmail.users WHERE uid = '6537' | ||
| Line 7: | Line 7: | ||
UPDATE mywebmail.`users` SET `active` = 'N' WHERE username = 'busdev' | UPDATE mywebmail.`users` SET `active` = 'N' WHERE username = 'busdev' | ||
| − | == ''Insert User Syntax''== | + | =='''Insert User Syntax'''== |
SELECT * FROM mywebmail.users WHERE username LIKE '%dmrs_ic%' | SELECT * FROM mywebmail.users WHERE username LIKE '%dmrs_ic%' | ||
UPDATE mywebmail.users SET username = 'dmrs_ic' WHERE username LIKE '%dmrs_ic%' | UPDATE mywebmail.users SET username = 'dmrs_ic' WHERE username LIKE '%dmrs_ic%' | ||
| Line 30: | Line 30: | ||
UPDATE mywebmail.users SET quota = '2000' WHERE username = 'mad_ca' | UPDATE mywebmail.users SET quota = '2000' WHERE username = 'mad_ca' | ||
| − | == ''Update Password''== | + | =='''Update Password'''== |
1. log in using putty | 1. log in using putty | ||
202.2.2.88 | 202.2.2.88 | ||
| Line 39: | Line 39: | ||
3.passwd init1234 | 3.passwd init1234 | ||
| − | == ''Create User''== | + | =='''Create User'''== |
202.2.2.88putty | 202.2.2.88putty | ||
username:root | username:root | ||
| Line 61: | Line 61: | ||
UPDATE mywebmail.`users` SET `gid` = '100' WHERE username = 'fd_spc' | UPDATE mywebmail.`users` SET `gid` = '100' WHERE username = 'fd_spc' | ||
| − | == ''Create User''== | + | =='''Create User'''== |
cd /home/user | cd /home/user | ||
du -hs | du -hs | ||
Revision as of 18:02, 16 June 2016
Create User
SELECT * FROM mywebmail.users WHERE username = 'busdev' SELECT * FROM mywebmail.users WHERE uid = '6537'
INSERT INTO mywebmail.`users` (username,home,uid,gid,quota,empname) VALUES ('cnc_ar_asst5','/home/','6591','100','2000','Cindy Biares')
UPDATE mywebmail.`users` SET `active` = 'N' WHERE username = 'busdev'
Insert User Syntax
SELECT * FROM mywebmail.users WHERE username LIKE '%dmrs_ic%'
UPDATE mywebmail.users SET username = 'dmrs_ic' WHERE username LIKE '%dmrs_ic%'
INSERT INTO `mywebmail`.`users`
(`username`,
`home`,
`uid`,
`gid`,
`quota`,
`active`,
`empname`)
VALUES ('dmrs_mktg_asst1',
'/home/',
'6598',
'100',
'3000',
'Y',
'Ma. Theresa Ann C. Dy');
UPDATE mywebmail.users SET quota = '2000' WHERE username = 'mad_ca'
Update Password
1. log in using putty 202.2.2.88
Username:root
password:spp3w3b
2.cd /home 3.passwd init1234
Create User
202.2.2.88putty username:root Password: spp3w3b cd /home useradd "username" -g users passwd "username" input password id "username" look for uid,gid
go to database
202.2.2.88
username: admin
password: myadminmail
insert records
INSERT INTO mywebmail.`users` (username,home,uid,gid,quota) VALUES ('fd_spc','/home/','6494','100','2000')
UPDATE mywebmail.`users` SET `gid` = '100' WHERE username = 'fd_spc'
Create User
cd /home/user du -hs
