Re: Setting up "no password" users?

2001-07-25 Thread Walter Lee Davis
307-388 > >- Original Message - >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, July 25, 2001 5:59 PM >Subject: Setting up "no password" users? > > >> >> >> >> I recently did my first mySQL inst

Re: Setting up "no password" users?

2001-07-25 Thread Christian Grimm
hello kynn, you have to : first you must UNDERSTAND the USER-table from mysql-DB on your box. from that point you are able to insert directly values into USERS like values into any other MySQL-Table: example: INSERT INTO USER VALUES ('localhost','Testuser','PASSWORD('little lamer'),'Y','Y',

Re: Setting up "no password" users?

2001-07-25 Thread Stefan Hinz
ROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 5:59 PM Subject: Setting up "no password" users? > > > > I recently did my first mySQL installation (the OS is Linux). How can > I set up users so that they do not need to supply a password to use &g

Setting up "no password" users?

2001-07-25 Thread kynn
I recently did my first mySQL installation (the OS is Linux). How can I set up users so that they do not need to supply a password to use mysql? I want to be able to issue commands like mysql -e "select host,db,user from db" mysql instead of having to do something like mysql -e "select