---
title: "MySQL添加用户远程访问权限"
date: 2009-04-23T07:02:55.000Z
tags: ["mysql", "权限"]
categories: ["技术"]
canonical: https://www.zhaojian.net/mysql-add-to-user-remote-access-permission/
author: 赵健
---

```
GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY '' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 用户名@"%" IDENTIFIED BY '密码' WITH GRANT OPTION;
```


第一句是增加用户和密码，第二句是提升权限。只需更改红色字体为你需要的就OK了。