1045 Access denied for user 'root'@'localhost'

adopt a reward of 10 yuan, 1045 Access denied for user "root"@"localhost" (using password:NO)

recently, when I was at the front end of my self-study, I came into contact with a little bit of database. This happened when I made a new connection on Navacat Premium. If I can help solve this and follow-up problems, I would like to give you a reward of 10 yuan to express my gratitude.
I"ve tried everything on the Internet, but I haven"t solved it.

clipboard.png

clipboard.png

clipboard.png


Open the local installation directory, and then cmd enter the command line
mysqld-nt-- skip-grant-tables enter this command for security mode, and then you can enter the database without outputting the password
and then change the password

.

if you can't, then change the account password and reply

using the command line.

clipboard.png

The

password is incorrect. You can try the root password root
navicat client to enter the information as prompted. Enter
mysql-uroot-p
on the cmd side will prompt you to enter the password, and then enter the password. Check whether the default password is root


this is obviously an error in the database password. You should have set it during installation. Generally, you try the root password or 123456 password


maybe:
1, you have entered the wrong password
2, you have just installed the database
3, and the root user does not have the permission to log in remotely.


password is wrong. If you do not remember the password to reinstall


1, the password is incorrect, if it is a local connection
2, or a remote link, then your remote server does not have the remote link permission to open port 3306. You can add this open port command to the firewall

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b22706-4ccb4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b22706-4ccb4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?