import user into mysql

[Ramsey, Robert L]

Import in what sense?  Since any user can read /etc/passwd you could go through and parse the names out of it and then and see if the name is a user name or group name.  You'd want to do a lot of error checking because you probably don't want to import the generic users like "nobody" or "apache" and so forth.

If you connected to the mysql database as someone who can grant rights, you could then grant rights to tables.  Or just import the names into a table.  I don't think you will be able to sync passwords though because the passwords should be stored in /etc/shadow.  Unless of course you are using ldap, ad, or other form on non-local authentication, which case they are stored somewhere else.  Not sure on that though; it should be possible to set up mysql to use your regular password, but I don't know how.

bob

> -----Original Message-----
> From: redhat-list-bounces at redhat.com [mailto:redhat-list-
> bounces at redhat.com] On Behalf Of Davis, Jared Scott
> Sent: Tuesday, November 06, 2007 11:34 AM
> To: General Red Hat Linux discussion list
> Subject: import user into mysql
> 
> Is there any way to import a user in /etc/passwd to MySQL?
> 
> 
> 
> Thanks,
> 
> 
> 
> jared davis.
> 
> Internet Administrator
> 
> Residential Life
> 
> University of Missouri-Columbia
> 
> 100 Pershing Hall
> 
> (573) 884-3616
> 
>