Mysql 8.0 cannot connect from CMD issue

See more:

MySQL

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