|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?
From: s. keeling (keeling
spots.ab.ca)
Date: Sun Oct 02 2005 - 22:03:19 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Incoming from Paul DuBois:
> At 18:50 -0600 10/2/05, s. keeling wrote:
> >
> >Groan. More stuff to learn, configure, maintain, and memorize. I'm
> >trying to replicate Unix's "root vs. mere user" security paradigm in
>
> I think your analogy is flawed. If you really want the root vs mere
> user distinction, the analogy would be that you su to the appropriate
> user before running MySQL programs. If you did that, the .my.cnf
I am the appropriate user. It's my database, and no other user has
access. The root mysql user has given my login ID two roles:
administrator and user of the db. I don't want to add the complexity
of multiple login accounts, nor should I have to. MySQL is an app,
which I as a user should be able to use as my OS's security regime
allows.
> >How about if I submit a feature request? Parse the command line. If
>
> If you submit a feature request, I hope that it would be more detailed
No need, since this:
> Because you're not using the mysql_read_default_group or
> mysql_read_default_file option in your connect string, most likely.
works perfectly. Just what I was looking for for the perl programs.
Thanks. Now I just need to futz with ~/.my.cnf, dependent on whether
I want keeling or sbk to have passwordless access. This is workable.
--
Any technology distinguishable from magic is insufficiently advanced.
(*) http://www.spots.ab.ca/~keeling Please don't Cc: me.
- -
For the ChiComms: democracy human rights Taiwan Independence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]