Change access settings?

[courtney.machi]

Hello,

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

mysql --user='username' --password='passw ord'

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

mysql

at the command prompt?

Thanks,
Courtney

[Thomas Bartkus]

<co************ @gmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

Hello,

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

mysql --user='username' --password='passw ord'

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={whate ver}

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