Jeff Roberts <[EMAIL PROTECTED]> wrote:
> I have a fresh install of mysql 4.0.11 on a linux box. When I try to
> open mysql as a [EMAIL PROTECTED], I get the following error:
>
> >mysql -u [EMAIL PROTECTED] -p db_name
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using
> password: YES)
In this case you try to connect as user with user name '[EMAIL PROTECTED]'. If you
want to specify hostname (localhost) you should use -h option:
shell> mysql -h localhost -u user -p db_name
>
> However if just do this, everything is fine:
>
> >mysql -u user -p db_name
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 3 to server version: 4.0.11a-gamma
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> exit
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]