Re: [cobalt-users] multiple mysql access

[shimi <shimi@xxxxxxxxxxxxxxxx>]

you need to define a root password for mysql...
i think it's mysqladmin -u root password <somepass>
read mysqladmin's manual if this is not true :)

also you'll need to create other users with access to mysql. the level of
access to every thing is configurable. you can limit a user only to one
dbase; only to one column in the dbase. this has MANY options... i would
go to mysql's site and check their online manuals
they're pretty good if you're an english speaker :)

  Best regards,
     shimi [mailto:shimi@xxxxxxxxxxxxxxxx]


----

Some quotes:

   "Outlook is a massive flaming horrid blatant security violation, that
    also happens to be a mail reader."                                   

   "There are two major products that come out of Berkeley: LSD and BSD.     
    We don't believe this to be a coincidence."
          -- Jeremy S. Anderson

 Windows: "Where do you want to go today?"
   Linux: "Where do you want to go tomorrow?"
     BSD: "Are you guys coming or what?"

On Sun, 25 Mar 2001, James Godwin wrote:

> Hi,
> 
> I can now login to mysql my typing
> 
> [jeff@fresh1 jeff]$ mysql -h 196.31.3.53
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 7 to server version: 3.22.32
> 
> Type 'help' for help.
> 
> mysql>
> 
> Problem is that any user who types this command has access to mysql. 
> How do I set mysql so that they can login but not have the ability to 
> create and delete databases?
> 
> Cheers
> 
> James
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>