|
- MySQL :: Re: ERROR 1045 (28000): Access denied for user root . . .
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Filipe Silva Date: March 25, 2021 11:59AM
- 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 :: Re: ERROR 1045 (28000) Access denied for user
Re: ERROR 1045 (28000) Access denied for user Posted by: James Preston Date: November 14, 2024 12:32PM
- 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:
- MySQL :: Error Connecting to DataBase!: SQLSTATE [HY000] [1045] Access . . .
SQLSTATE [HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)" From the documentation this seems to imply that I'm somehow passing in a password for the user "root"
- 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 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: ERROR 1045 (28000) Access denied for user
New Topic Re: ERROR 1045 (28000) Access denied for user Posted by: James Preston Date: November 14, 2024 04:29AM Wish someone had an idea of where I should be looking :^ ( On to next steps and results: SSL is running server as far as I can tell and password plugin seems correct: 0 [Warning] [MY-010068] [Server] CA certificate ca pem is self signed
|
|
|