If you haven't explicitly set a mysql password for the root user, then there isn't one. Remove the '-p' from command line, and if you're logged in as root, you shouldn't even need the -u root.....
-- Kelly F. Hickel Senior Software Architect MQSoftware, Inc 952.345.8677 [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:rt-users- > [EMAIL PROTECTED] On Behalf Of Thornton, Patrick J > Sent: Friday, May 05, 2006 2:05 PM > To: Justin Findlay; rt-users@lists.bestpractical.com > Subject: RE: [rt-users] mysql password problems > > This may be a dumb question, but are you sure the mysql daemon is > running? > > (Something like "# ps -ef | grep mysqld" should tell you) > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Justin > Findlay > Sent: Friday, May 05, 2006 2:22 PM > To: rt-users@lists.bestpractical.com > Subject: [rt-users] mysql password problems > > 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 _______________________________________________ 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
