Member Avatar for newbie26

When I type in: "mysqladmin -u root -p" and enter the password I get reset I get the message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

  • 2 Contributors
  • 1 Reply
  • 193 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Hello,

Quick note in case you are not aware of this. The system root user and the MySQL root user are two entirely different accounts and passwords. Even though they are both called root the MySQL password is stored in the application and the system root password is stored in /etc/shadow. The system root user does not have root privleges in MySQL and the MySQL root user does not have system root privdgles.

If you were already aware of this then either you have the wrong password for root or the host is incorrect. If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

mysqladmin -u root password NEWPASSWORD

You could try root@127.0.0.1 or if you have system root access to the box then there is a procedure that allows you to reset MySQL root to what ever you want.

http://www.thegeekstuff.com/2009/07/how-to-reset-forgot-mysql-root-password-on-unix-linux-windows/

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.