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: [EMAIL PROTECTED]
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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
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
