MySQL Forums
Forum List  »  Install & Repo

Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Nanda kishore Toomula
Date: July 28, 2008 05:27AM

Hi all,
after fresh installation, if you set password to root user
whenever you type mysql it implicitly invoke mysql -u root -p
command i.e mysql utilizes root as default user
if you want avoid this problem
in my.cnf add the following

password=(password goes here)
socket=/var/lib/mysql/mysql.sock (whatever the socket name)

Nanda kishore Toomula
Sr DBA,Nokia india
Certified MySQL Database Administrator

Options: ReplyQuote

Written By
June 27, 2009 08:29PM
December 16, 2007 02:18AM
December 27, 2007 02:08PM
January 16, 2011 06:51AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
July 28, 2008 05:27AM
August 27, 2009 12:22AM

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.