Difference between revisions of "SPPEWEBMAIL"

Revision as of 18:01, 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