|
- 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 :: 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 :: 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: MySQL ERROR 1045 (28000): Access denied for user root . . .
Hi Willians, Assuming that the weird concatenation in the `password` is a mistake in your reply here, I would recommend you to check what password plugin do you have for the user `root` (select user, host, plugin, ssl_type from mysql user), then try to connect using a mysql client using the option --protocol=TCP to avoid using unix sockets or so The `ssl_type` will tell you if this 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: Error Nr. 1045 Access denied for userroot@localhost . . .
可是今天再登陆时就报1045错误代码。 错误代码 1045 Access denied for user 'root'@'localhost' (using password:YES) 我的解决办法是重新设置root用户密码，在Windows平台下操作步骤如下： 1、以系统管理员身份登录到系统； 2、如果MySQL服务器正在运行，停止它。
|
|
|