mysql> insert into user (username,password,uid,gid,posix_homedir) values ("foo","$1$hNsL70rh$ypiLapNqQwgd9lejS.plV/",8000,100,"/tmp"); Query OK, 1 row affected (0.03 sec) users: +-----------------------+--------------+------+-----+---------+----------------+ | user_id | int(9) | | PRI | NULL | auto_increment | | logon_time | int(9) | YES | | NULL | | | logoff_time | int(9) | YES | | NULL | | | kickoff_time | int(9) | YES | | NULL | | | pass_last_set_time | int(9) | YES | | NULL | | | pass_can_change_time | int(9) | YES | | NULL | | | pass_must_change_time | int(9) | YES | | NULL | | | username | varchar(255) | YES | MUL | NULL | | | domain | varchar(255) | YES | | NULL | | | nt_username | varchar(255) | YES | | NULL | | | nt_fullname | varchar(255) | YES | | NULL | | | home_dir | varchar(255) | YES | | NULL | | | dir_drive | varchar(4) | YES | | NULL | | | logon_script | varchar(255) | YES | | NULL | | | profile_path | varchar(255) | YES | | NULL | | | acct_desc | varchar(255) | YES | | NULL | | | workstations | varchar(255) | YES | | NULL | | | unknown_str | varchar(255) | YES | | NULL | | | munged_dial | varchar(255) | YES | | NULL | | | uid | int(9) | | MUL | 0 | | | gid | int(9) | YES | MUL | NULL | | | user_sid | varchar(255) | YES | | NULL | | | group_sid | varchar(255) | YES | | NULL | | | lm_pw | varchar(255) | YES | | NULL | | | nt_pw | varchar(255) | YES | | NULL | | | acct_ctrl | int(9) | YES | | NULL | | | unknown_3 | int(9) | YES | | NULL | | | logon_divs | int(9) | YES | | NULL | | | hours_len | int(9) | YES | | NULL | | | unknown_5 | int(9) | YES | | NULL | | | unknown_6 | int(9) | YES | | NULL | | | realname | varchar(32) | | | | | | shell | varchar(20) | | | /bin/sh | | | password | varchar(40) | | | | | | lastchange | varchar(50) | | | | | | min | int(11) | | | 0 | | | max | int(11) | | | 0 | | | warn | int(11) | | | 7 | | | inact | int(11) | | | -1 | | | expire | int(11) | | | -1 | | | origpw | varchar(50) | YES | | NULL | | | posix_homedir | varchar(32) | | | /pub | | +-----------------------+--------------+------+-----+---------+----------------+ ### after smbpasswd -a: mysql> select * from user where username = "foo"; +---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ | user_id | logon_time | logoff_time | kickoff_time | pass_last_set_time | pass_can_change_time | pass_must_change_time | username | domain | nt_username | nt_fullname | home_dir | dir_drive | logon_script | profile_path | acct_desc | workstations | unknown_str | munged_dial | uid | gid | user_sid | group_sid | lm_pw | nt_pw | acct_ctrl | unknown_3 | logon_divs | hours_len | unknown_5 | unknown_6 | realname | shell | password | lastchange | min | max | warn | inact | expire | origpw | posix_homedir | +---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ | 51040 | 0 | 0 | 0 | 1066985902 | 1066985902 | 2147483647 | foo | FCESI | NULL | NULL | \\server\foo | NULL | logon.bat | \\server\profiles\foo | NULL | NULL | NULL | NULL | 7002 | 100 | S-1-5-21-2011390343-3838542023-4164093905-15004 | S-1-5-21-2011390343-3838542023-4164093905-1201 | A6428F2551EDEE1BAAD3B435B51404EE | 86C156FC198B358CCCF6278D8BD49B6A | 16 | NULL | 168 | 21 | NULL | NULL | | /bin/sh | $1$aH/xIuYN$H8ffY2mPSyUGLFQ3yFrFb/ | | 0 | 0 | 7 | -1 | -1 | 699083 | /home/foo | | 51546 | NULL | NULL | NULL | NULL | NULL | NULL | foo | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8000 | 100 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | /bin/sh | $1$hNsL70rh$ypiLapNqQwgd9lejS.plV/ | | 0 | 0 | 7 | -1 | -1 | NULL | /tmp | +---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ 2 rows in set (0.00 sec)