MySQL :: Re: How do I fix error 1045 hello Martin see what grants the root user has by using this query should list the accounts privileges with Y or N the privileges might do more then whats based on their name so look through the manual if the privilege is not enabled select * from mysql user where user = 'root' and host = 'localhost'; there's a grant column so the root user might not have it enabled there is also the global
MySQL :: ERROR 1045 (28000) Access denied for user Subject Written By Posted ERROR 1045 (28000) Access denied for user James Preston November 05, 2024 01:12AM Re: ERROR 1045 (28000) Access denied for user
MySQL :: ERROR 1045 (28000): Access denied for user root@localhost . . . Hi I'm currently trying at MySQL and just logging in seems to be a challenge!? >mysql -u root If MySQL itself asks for the password, I can log in as desired >mysql -u root -p'xyz' However, if I enter the password directly on the command line, strangely it doesn't work |mysql: [Warning] Using a password on the command line interface can be insecure |ERROR 1045 (28000): Access denied for user
MySQL :: Re: How do I fix error 1045 The error 1045 "Access denied for root@localhost (using password yes)" occurs because the root user does not have the GRANT privilege To fix this, you can grant the GRANT privilege to the root user by executing the following statement: