ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) on Windows

when i want start mysql in windwos cmd i got this error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) what can i do?

mysql -u root -p

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

You can reset your root password. Have in mind that it is not advisable to use root without password.

Fixing MySQL 1045 Error: Access Denied, Start the instance. Access with root user (mysql -uroot -hlocalhost); Issue the necessary GRANT/CREATE USER/SET PASSWORD to correct the issue (likely setting a known root password will be the right thing: SET PASSWORD FOR 'root'@'localhost' = 'S0vrySekr3t'). MySQL - ERROR 1045 (28000): Access denied for user. Ask Question Asked 7 years, 3 months ago. Active 2 months ago. Viewed 115k times 9. 4. I just installed a fresh

install MYSQL again and define pass for root and define a user and after instalation MYSQL work on cmd whit

cd c:\Program Files\MySQL\MySQL Server 5.7\bin>

then

mysql -u myusername -p

then ask my pass and enter the password of this user name(not root password) and it work

other way for run MYSQL is start menu

in start menu find folder that named MySQL and expand it and run MySQL command line client

MySQL - ERROR 1045 (28000): Access denied for user, The reason you could not login as repl@'%' has to do with MySQL's user authentication protocol. Since you did not specify an IP address, mysql assumes host is localhost and tries to connect via the socket file. This is why the error message says Access denied for user 'repl'@'localhost' (using password: YES) . ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) it was a problem with the port running on. By default the mysql is running on port 3306 .

you can find your password by

#  cat /var/log/mysqld.log  | grep password

Solved: ERROR 1045 (28000): Access denied for user 'mahi , Re: ERROR 1045 (28000): Access denied for user 'mahi'@'localhost' (using password: YES). jsensharma. Super Mentor. Created 07-15-2017� ERROR 1045 (28000): Access denied for user 'ayaz'@'localhost' (using password: YES) It says, Password: Yes. That means I am sending the password to SQL and that is wrong.

[Solved] ERROR 1045 (28000): Access denied for user 'user'@'host , Error 1045: Access denied for user (using password: YES) in MySQL, [Solved] ERROR 1045 (28000): Access denied for user 'user'@'host'� MySQL ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES); Wampserver 3.2.0 new instalation or upgrading. Probably xamp using mariaDB as default is well. Wamp server comes with mariaDB and mysql, and instaling mariaDB as default on 3306 port and mysql on 3307, port sometimes 3308. Connect to mysql!

ERROR 1045 28000 Access denied for user 'root'@'localhost' using , ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO Duration: 4:10 Posted: Jun 14, 2018 [root ~]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:NO) Stop the service/daemon of mysql running [root ~]# service mysql stop mysql stop/waiting Start mysql without any privileges using the following option; This option is used to boot up and do not use the privilege system of MySQL.

"root" user password or How to fix error 1045 (28000) Access denied, Hello Friends, In this video, I am telling you 'How to reset MySql "root" user password or How Duration: 2:15 Posted: Sep 10, 2019 Solution for this type of error is very simple. Just enter the correct username and password. This error will be resolved. In case if you forget the password you can reset the username/password. If you forget the password for admin / root account, there are many ways to reset / recapture the root password.

Comments
  • did you ever set a root password?
  • no i havnot password
  • then you don't need the -p tag -p specifies with password, just run mysql -uroot
  • i have not password
  • Add more info on why this is an asnwer.