mysql access denied

[mrossTTX]

i know this isnt an mysql forum but.. on my 1.2.22 cacti server , on windows.. im trying to import a .sql file into the cacti database..
i am getting

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u cactiuser -p cacti < ent.sql
Enter password: **********
ERROR 1045 (28000): Access denied for user 'cactiuser'@'localhost' (using password: YES)

i get this on cacti user or ROOT.. i cant login to mysql using any mysql tools.. anyone else see this and know a way to fix it without uninstalling and reinstalling mysql?

[Osiris]

Did you set a root password in MySQL? If so, use that account. If you did not record/set the root password. It's easier to just start over.

[mrossTTX]

Did you set a root password in MySQL? If so, use that account. If you did not record/set the root password. It's easier to just start over.

i used the windows installer.. and im trying the pw that it puts in the text file it leaves behind.

[TheWitness]

That's the way to do it. Keep it in a lock box.

[mrossTTX]

fyi finally fixed this.
had to make a text file in my c drive called mysql-init.txt
in that file is ALTER USER 'root'@'localhost' IDENTIFIED BY 'somenewpassword;
then stopped mysql service
open cmd as admin
ran "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --init-file=C:\\mysql-init.txt

it will just stay up there, wont give you a response.. thats ok.
i opened mysql workbench, used my new pw.. set my root user to have all rights, then closed out of mysql workbench.
i killed that process i spawed with that command.
restarted the service.
voila.. i could log into mysql workbench and cmd line as root and create a seperate user to use and\or use root for what is needed..

hope this helps, remember to delete that mysql-init.txt file afterwards