You can have a file called .my.cnf in your home directory that stores it. This page outlines it pretty well:
http://www.modwest.com/help/kb6-242.html In your case, you would just want to use the password = 'foo' part of it. -Dan On 3/4/08 4:10 AM, "Thufir" <[EMAIL PROTECTED]> wrote: > I understand that there's a configuration so that instead of typing: > > [EMAIL PROTECTED] ~ $ mysql -u root -ppassword > > > that the password (of "password") is stored so that whenever this user > connects as root the password is automatically passed. > > > Is this possible? > > > > thanks, > > Thufir > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]