LinuxSA Mailing list archives

  From: Andrew Reid <andrew.reid@plug.cx>
  To  : Matthew Geddes <mgeddes@xavier.sa.edu.au>
  Date: 23 May 2001 15:14:19 +0930

Re: MySQL problems

On 23 May 2001 16:10:42 +0930, Matthew Geddes wrote:

> use crud
> INSERT INTO user ( host, user, password ) values
> ('localhost','cruduser','crudpass');
> 
> The first line returns a message letting me know that I've changed
> databases, but the second line fails telling me that the table crud.user
> doesn't exist. Is it necessary for me to create that table? If so,
> what's the schema look like? If not, what did I do to break it? :-)

I'm not sure of the integrity of my method, but I generally assign
connection permissions like this:

GRANT select, insert, update, delete ON crud.* TO cruduser@localhost
IDENTIFIED BY 'crudpass'

You may want to modify it so that it could only SELECT and UPDATE to the
table fooble:

GRANT select, update ON crud.fooble TO cruduser@localhost IDENTIFIED BY
'crudpass'

Modify to your heart's content!

   - andrew

-- 
Andrew Reid                   email: andrew.reid@plug.cx
                              www:   http://www.plug.cx
"It's difficult to see the    phone: +61 401 946 813
 picture when you are 
 inside the frame."


-- 
LinuxSA WWW: http://www.linuxsa.org.au/  IRC: #linuxsa on irc.linux.org.au
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject