Matthew Darcy writes:
> If I want to connect to the database as root then I understand I must do > mysql -u root -p Unless you're logged in as root, in which case mysql -p is enough. > 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. Unless you have a broken version of mysql, not specifying a username is equivalent to specifying -u `whoami`. If you want the users to be prompted for a password, try alias mysql="mysql -p" //C - thinks that'll do it. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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
