From: Martin Gainty Date: September 1 2008 12:21am Subject: RE: mysql user and authentication ??? List-Archive: http://lists.mysql.com/mysql/214308 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_8000f8c2-53cc-4ddd-a6ce-1585177cb597_" --_8000f8c2-53cc-4ddd-a6ce-1585177cb597_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable you can use GRANT statement to create and grant privs for a mysql db so use= rs can access specific host DB servers @'server.domain' specific DB on spec= ific Db Servers 'custom'@'server.domain'specific tables on specific DB cust= omer.* specific privs (Select_priv=2CInsert_priv=2CUpdate_priv=2CDelete_priv=2CCre= ate_priv=2CDrop_priv) for those specific tables on specific DBe.g.GRANT SEL= ECT=2CINSERT=2CUPDATE=2CDELETE=2CCREATE=2CDROP ON customer.* TO 'custom'@'s= erver.domain' IDENTIFIED BY 'obscure'=3B http://www.devshed.com/c/a/MySQL/Managing-MySQL-User-Accounts/1/ =20 HTH/Martin ______________________________________________ Disclaimer and co= nfidentiality note Everything in this e-mail and any attachments relates to= the official business of Sender. This transmission is of a confidential na= ture and Sender does not endorse distribution to any party other than inten= ded recipient. Sender does not necessarily endorse content contained within= this transmission. > Date: Sun=2C 31 Aug 2008 19:38:15 -0400> From: alex.k= atebi@stripped> To: mysql@stripped> Subject: mysql user and authent= ication ???> > Hello=2C> > I just installed the 6.0.6 version of the mysqld= on Linux using the> binary RPM.> The RPM installed all the programs then i= t started the mysqld server.> > I read lots of documents about mysql user a= nd password. But I have no idea> what the users are used for=2C and how use= rs are created.> > The Linux root user is the only user that can start and = stop the server. Is> this fact correct?> > Thanks=2C> -Alex _________________________________________________________________ Get thousands of games on your PC=2C your mobile phone=2C and the web with = Windows=AE. http://clk.atdmt.com/MRT/go/108588800/direct/01/= --_8000f8c2-53cc-4ddd-a6ce-1585177cb597_--