Click here to Skip to main content
15,123,367 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i can't connect my mysql from CMD but I can login from MySQL 8.0 command line whats is the issue can't find

showing me
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)



please help me

MYSQL 8.0 Version

What I have tried:

1.
GRANT ALL ON ISGElast_Db.* TO 'root'@'localhost' IDENTIFIED with mysql_native_password by  '123456';
flush privileges;


2.
mysqld --defaults-file="D:\\MySQL\\MySQL Server 8.0\\my.ini" --init-file=C:\\reset.txt --console

in reset.txt below code I wrote
Use mysql;
update user set authentication_string=password('123456') where user='root';
FLUSH PRIVILEGES;


but no success
Posted
Comments
Richard MacCutchan 7-Aug-20 9:22am
   
It would appear that your password is not correct.
ZurdoDev 7-Aug-20 12:55pm
   
Password is wrong.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900