Hi,
May be you have already set a password for "root" user.
Try to connect as
$ /usr/local/mysql/bin/mysqladmin -u root -p password 'secret'
It will prompt for password. If you believe you havent set any password press
enter.
regards
-- Tusar
On Thursday 18 September 2003 10:56 pm, Dr. Sharukh K. R. Pavri. wrote:
> On Mon, 15 Sep 2003, Arvind wrote:
> > > mysql> SET PASSWORD FOR [EMAIL PROTECTED](secret);
> > > ERROR 1064: You have an error in your SQL syntax. Check the manual
> > > that corresponds to your MySQL server version for the right syntax to
> > > use near 'secret)' at line 1
> > > mysql> SET PASSWORD FOR [EMAIL PROTECTED]('secret');
> > > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> >
> > normally , for a freshly installed mysql , the root password is a blank (
> > NULL).
> >
> > try setting a password using "mysqladmin."
>
> did not work. this is what I get:
>
> ------------------------------
>
> [EMAIL PROTECTED] snortreport]$ /usr/local/mysql/bin/mysqladmin -u root
> password 'secret'
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
>
> -------------------------------
>
> regards,
>
> Sharukh
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
