I just installed MySQL and HeidiSQL on my new Win11 computer. Using the PW I created for the root account, I get Access denied for user 'root'@'localhost' (using password: YES) Session: Documents Network type TCP/IP library: libmysaql.dll Hostname: 127.0.0.1 User: root Password: <pw I created root account with> Port:3306 Databases: Documents (I will have to create with Create Database once I login) What do I need to do?
Access Denied
You can stop the server using net stop mysql
command, then restart it by hand in a console, without loading the user privileges:
path\to\mysqld.exe --standalone --skip-grant-tables
When mysqld runs, you can start HeidiSQL to connect with any random username/password. You should immediately change the user's password in the user manager, and then restart the server normally.
Please login to leave a reply, or register at first.