Re: user accounts using Active Directory

2012-08-22 Thread Ignacio Ocampo
Hi Aastha, I think that you can develop a Plugin to do it. Recently, I post a plugin that allow authenticate users through LDAP Server ( http://nafiux.com/blog/2012/08/16/mysql-ldap-authentication-plugin-clear-password-client-plugin/ ). More info about MySQL Authentication Plugins: http://dev.my

user accounts using Active Directory

2012-08-22 Thread Aastha
Hello, I want to create users and give access to different schema within the database. I also want to give them selective privileges to access the table in different schema. One way is to create users in MySQL and then grant with privileges. Is there any way to give them access to MySQL database

Re: User Accounts

2005-10-22 Thread Michael Stassen
Colin Shreffler wrote: After installing MySQL on OS X, there don't appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an Admin account? Cheers -c After installation, you need t

User Accounts

2005-10-22 Thread Colin Shreffler
After installing MySQL on OS X, there don¹t appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an ŒAdmin¹ account? Cheers -c

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
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

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
At 18:50 -0600 10/2/05, s. keeling wrote: Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: > >The admin account, with no password, doesn't function at all. perl >programs appear to ignore ~/.my.cnf forcing me to open() them and >slurp username and password that way. >

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
Incoming from Paul DuBois: > > At 16:39 -0600 10/2/05, s. keeling wrote: > > > >The admin account, with no password, doesn't function at all. perl > >programs appear to ignore ~/.my.cnf forcing me to open() them and > >slurp username and password that way. > > > >How is this supposed to work? Su

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
ing via ~/.my.cnf from the same login account? This is MySQL 4.0 on Debian/Gnu Linux (Testing/Etch) (note the "anonymous user" accounts have had their passwords changed, if they exist at all; I'm not sure about that latter bit). Yes, there are more recent MySQL versions available

~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
in your source, are you? How can I have separate user and admin accounts working via ~/.my.cnf from the same login account? This is MySQL 4.0 on Debian/Gnu Linux (Testing/Etch) (note the "anonymous user" accounts have had their passwords changed, if they exist at all; I'm not

Re: Newbie question -- user accounts

2003-07-20 Thread Paul DuBois
At 14:30 -0500 7/20/03, Nate Dawg wrote: I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL for dummies. I am having a problem. Look: mysql> SELECT * FROM user -> ; ERROR 1046: No Database Selected mysql> Ok so the book says " Thi

Re: Newbie question -- user accounts

2003-07-20 Thread Veysel Harun Sahin
Did you try to select a database before querying the table? You can do this with use command. mysql>use mysql; Then your command; mysql>select * from user; [EMAIL PROTECTED] wrote: I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL fo

Newbie question -- user accounts

2003-07-20 Thread Nate Dawg
I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP & MySQL for dummies. I am having a problem. Look: mysql> SELECT * FROM user -> ; ERROR 1046: No Database Selected mysql> Ok so the book says " This message means your account is not allo

Re: User Accounts...

2003-02-01 Thread Zak Greant
On Fri, Jan 31, 2003 at 10:55:18AM -0300, Alejandro C. Garrammone wrote: > How can I create different user accounts for a table?. (I've just installed > the MySQL, and the root just don't have a password yet..how can assign one? Hey Alex, Check out the user account managemen

User Accounts...

2003-01-31 Thread Alejandro C. Garrammone
How can I create different user accounts for a table?. (I've just installed the MySQL, and the root just don't have a password yet..how can assign one? Thxs in advance, Alex - Before posting, please chec

Re: migrating user accounts

2002-06-18 Thread Joshua Horton
rs table. > > > I think you can only remove a row from MySQL.user directly. True, GRANT is > preferred to add and alter user accounts, but DELETEing the user's entry in > MySQL.user is fine. > > - &

migrating user accounts

2002-06-12 Thread Joshua Horton
Hi, I have been watching the list for a while now as I get to know MySQL. I must admit that it is one of the more vibrant communities I have encountered. I have seen many good answers and even better questions, but I haven't seen my particular issues come up. I have two questions, one spec