[rt-users] mysql password problems

[Kelly F. Hickel]

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
kfh at mqsoftware.com


> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
> bounces at lists.bestpractical.com] On Behalf Of Thornton, Patrick J
> Sent: Friday, May 05, 2006 2:05 PM
> To: Justin Findlay; rt-users at 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: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Justin
> Findlay
> Sent: Friday, May 05, 2006 2:22 PM
> To: rt-users at 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: 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
> 
> _______________________________________________
> 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