Shulou(Shulou.com)06/01 Report--

This article mainly introduces navicat for mysql connection unsuccessful solution, the text is very detailed, has a certain reference value, interested friends must read!

navicat for mysql connection unsuccessful solution: 1. Login mysql;2. Execute the command [ALTER USER 'root'@'localhost' IDENTIFIED], skip password verification;3. Refresh permissions.

Step 1: Open Command Line Client

Step 2: Enter mysql password Enter is the password set when installing mysql Enter password only without semicolon

Step 3: Enter ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysql password'; Enter do not miss a semicolon at the end mysql password is the password set when mysql is installed

Step 4: Enter FLUSH PRIVILEGES; Enter (don't miss the semicolon)

The above is "navicat for mysql connection unsuccessful solution" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.