installation package: mysql-workbench-community-8.0.18-winx64. Msi
version no. : MySQL Workbench 8.0 CE
connection tip:
tried
1. Neither localhost nor ::1
2. Query whether host exists under user, -> Invalid
3. Add
bind-address = 127.0.0.1
“
” under [mysqld] in my. Navicat and hedisql can both connect
finally found a solution in bug-75745: due to the high version of the incompatible, download version 6.3.10 at the workbench download address to install
why do you want to use MySQL Workbench?Because you need to switch databases in multiple environments in your work, so after using heidisql(GPL open source) and navicat(charged), I tried a wave of MySQL Workbench(Community GPL open source) and found that there are multiple tabs to switch multiple environment databases, which can be used. If you are used to heidisql and navicat, you can use them without changing
Read More:
- How to Fix failed to Connect to MySQL at localhost:3306 with user root
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- Solution to MySQL workbench error 1148 unable to load local data
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- Navicat for MySQL error 1251 failed to connect to MySQL
- Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘
- [MySQL] the solution of MySQL workbench “error code: 1175”
- MySQL connection error access denied for user ‘root’ @ ‘localhost‘
- Error 1045 (28000) access denied for user ‘root’ @’localhost ‘appears in MySQL under Windows system
- PHP connection to MySQL database error: call to undefined function MySQL_ connect()
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- Mysql Error:The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- [How to Fix] MySQL Workbench for Mac Flashback
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- mysql problem solving: mysqladmin: connect to server at’localhost’ failed