mysql - Why I cant create a new connection in SQL in VS code

Question

When i am trying to make a new connection in VS Code, this error message popped-off

One another thing, Could someone just tell me what are the needed extensions to work with mysql in VS-code.

question from:https://stackoverflow.com/questions/65874658/why-i-cant-create-a-new-connection-in-sql-in-vs-code

Answer 1

It's because mysql default root user cant login with password and is set to auth_socket. To change this behavior you should connect to mysql if you on linux with this command: sudo mysql -u root and run this command to enable password login: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';