title: mysql创建账户分配数据库  
CreateTime: 2014-07-02 18:40:00  
UpdateTime: 2014-07-02 18:40:00  
CategoryName: web  
---

---
title: "mysql创建账户分配数据库"
date: 2014-07-02T18:40:00+08:00
draft: false
tags: ["web"]
categories: ["web"]
author: "springrain"
---

```sql
-- 创建数据库  
create database db1;  

-- 创建用户     
CREATE USER userdb1@'localhost' IDENTIFIED BY 'password';  

-- 给数据库分配所有权  
GRANT ALL PRIVILEGES ON db1.* TO userdb1@'localhost';  

```