[rt-users] mysql password problems

[Romeo Theriault]

mysql -u username -pPassword

works for me.  No space between -p and the password. Like an earlier  
poster said. If you haven't set a root password, there is none.

Romeo
On May 5, 2006, at 2:21 PM, Justin Findlay wrote:

> I apologize if this question is off topic, yet I am a MySQL newbie and
> haven't found any resolution on my own.  I've been following this
> install guide
>
> http://wiki.bestpractical.com/index.cgi?RHEL4InstallGuide
>
> and everything seems to work except this command:
>
> # mysqladmin -u root password newpass
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:  
> NO)'
>
> I've also tried this alternate syntax:
>
> # mysqladmin -uroot -p create
> Enter password:<some password>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:  
> YES)'
>
> What can I do?
>
>
> Justin
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: http:// 
> bestpractical.com/about/jobs.html