Franck Collineau writes:

> I have read the manual again.
> I can connect as root (i type: mysql -u root -p then password and i have the 
> prompt)
> 
> But when i type: mysql --user=root mysql
> i have the message:
> ERROR 1045: Access denied for user: 'root@localhost' (using password NO)

mysql --help shows you this:
  -p[password], --password[=...]
                 Password to use when connecting to server
                 If password is not given it's asked from the tty.

In other words, you must specify -p (without a password) if you
want to be asked for a password. 

//C

-- 
 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

Reply via email to