Change access settings?

Hello,

In order to access mysql I must type at the command prompt

mysql --user='username' --password='password'

How can I change it so that all I have to type is

mysql

at the command prompt?

Thanks,
Courtney

Re: Change access settings?

wrote in message
news:1137438776.961060.145700@g14g2000cwa.googlegroups.com.. .
> Hello,
>
> In order to access mysql I must type at the command prompt
>
> mysql --user='username' --password='password'
>
> How can I change it so that all I have to type is
>
> mysql
>
> at the command prompt?

If Linux - create a hidden file in your home directory named [.my.cnf] with
the contents thus:

[client]
user={whomever}
password={whatever}

Then when you issue the "mysql" command, it will draw the user name and
password from the my.cnf file and bounce you (or anyone else logged in as
you!) right in.

I'm sure the Windows version supports a nearly identical setup but you will
have to look it up.

The details vary.
Thomas Bartkus