# Navicat连接数据库1130

## 1.背景

Navicat连接云服务器的mysql报1130，内容是Host"xxx.xxx.xx.xx"is not allowed...

## 2.正文

* 解决方法（来源于网络[地址](https://www.cnblogs.com/devan/p/7055339.html)）

  > 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改"mysql" 数据库里的 "user" 表里的 "host"项，从"localhost"改称"%"

总体运行语句:

```sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysqlpswd' WITH GRANT OPTION;
flush privileges;
```

### 推一波自己的网站[Makeprogress.xyz](https://github.com/JonXia/LotsOfNotes/tree/80b3448219860cb336a538105b1d4eafcfeac85a/云服务器/makeprogress.xyz)，里面的博文由4只猿共同更新，包含的东西比较广，包括大数据、Java后台、前端等，内容目前比较初级，欢迎访问和交流\~


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://jon-xia.gitbook.io/workspace/linux-fu-wu-qi-2/navicat-lian-jie-shu-ju-ku-1130.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.