Matthew Darcy wrote:
>
>I have 3 UNIX users on my server.
>
>test1, test2, and test3.
>
>I have created 3 users for mysql test1, test2, and test3 (shock horror)
>
>If I want to connect to the database as root then I understand I must do
>mysql -u root -p
>
>but I would like test1 2 and 3 to be able to type mysql and be either logged
>in as their unix username, ie test2 types mysql and connects to the database
>as test2 (mysql account)
>or at least be prompted for the password for test2.
>
>The only way I can think of doing this is by setting up an alias ie
>
>alias mysql_connect=`mysql -u $username -p`
>
>there must be some sort of autologin from username like in oracle.
>
>Thanks,
>
>Matt.
>
The user defaults to the unix user.
You can put a .my.cnf file in their home directory with
[client]
password=whatever
to make it even easier.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
