格式为
链接名 mysql
主机ip localhost
端口 3306
用户名 root
密码 1234(自己定义的密码)
连接不上的原因是数据库字段名没有识别,执行红色的sql语句,执行完之后再测试navicat 即可成功链接
MariaDB [mysql]> select host from user where host='localhost' and user ='root';
+-----------+
| host |
+-----------+
| localhost |
+-----------+
1 row in set (0.00 sec)
MariaDB [mysql]> update user set host='%' where host='localhost' and user ='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)