MySQL Forums
Forum List  »  Install & Repo

Re: * ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) * another solution?
Posted by: Richard Pratt
Date: April 07, 2010 05:52PM

Hi,

I was getting this error when running /usr/bin/mysql_secure_installation and other scripts designed to set up mysql as the backend for a web app that we are running.

/usr/bin/mysql_secure_installation would succesfully set the root password and then refuse to continue, giving this error, after reading some of the other posts above it dawned on me that it was a shell script, and my root password included shell wildcards! :|

after using one of the methods outlined above to reset the root password to something simpler (alphanum only) all the scripts are running perfectly.

Hope that helps someone :)

Options: ReplyQuote


Subject
Written By
Posted
June 27, 2009 08:29PM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
August 27, 2009 12:22AM
Re: * ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) * another solution?
April 07, 2010 05:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.